Article View: borland.public.cppbuilder.database.dbexpress
Article #133Re: Dynamic MYSQL tables in datasets
From: Max
Date: Fri, 11 Feb 2005 22:38
Date: Fri, 11 Feb 2005 22:38
46 lines
2848 bytes
2848 bytes
Max schreef: > Hello, > > I'm encountering a problem in the combination of MySQL and dbexpress in > Borland C++Builder 6. > With one TSQLConnection and a couple of TSQLClientDataSets I've made an > application. The TSQLClientDataSets are from the CommandType ctTable and > the MySQL tablenames are loaded at runtime just before the datasets are > opened. In fact the initial tables exist already in the database and > their names have been put in the datasets at designtime already. > The idea is that I want to copy the database tables to new tables (in > fact saving the old tables for later reference) and from then on use the > new tables with the datasets. > The new tables are created using a TSQLQuery with the exact create SQL > query MySql generates with a mysqldump. > I open a dataset with the old table and I use a separate destination > dataset for the new table. This way I copy the data from the old table > to the new copy. > > So far so good. > > The new tables have the same size and the same record count as the old > ones and all seem well. > > When the new tablenames get loaded in the datasets, these datasets > behave differently than they did with the old tables! This changes when > I enter the new tablenames at designtime in the IDE. > There is something that happens to the dataset if you define it at > design time using a database table, what I couldn't duplicate by just > putting the database tablename in the dataset. > > What am I missing? > > Regards, > Max Suddenly it started to work. Although I'm not too confident about it. What worries me really is the non-activity of this newsgroup. Doesn't Borland believe in it's dbexpress? Most questions here stay un-answered. If you compare the responses with cpp or vcl you could call this group dead. Can somebody of Borland comment on this? -- Max C++U2
Technical Details
Message-ID:
<420d33f4$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<42092632$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: fb4e2,8a94ac271044c9a3 X-Google-Attributes: gidfb4e2,public X-Google-Language: ENGLISH,ASCII-7-bit Date: Fri, 11 Feb 2005 23:38:20 +0100 From: Max <nomail@4me.nl> User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: nl-NL, nl, en MIME-Version: 1.0 Newsgroups: borland.public.cppbuilder.database.dbexpress Subject: Re: Dynamic MYSQL tables in datasets References: <42092632$1@newsgroups.borland.com> In-Reply-To: <42092632$1@newsgroups.borland.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 213.84.188.198 Message-ID: <420d33f4$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1108161524 213.84.188.198 (11 Feb 2005 14:38:44 -0800) Lines: 46 Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail