🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.dbexpress
Article #133

Re: Dynamic MYSQL tables in datasets

#133
From: Max
Date: Fri, 11 Feb 2005 22:38
46 lines
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-mail
References: <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