🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

dbExpress: version problems? Invalid Field Type

#28
From: kw
Date: Fri, 08 Sep 2006 10:37
26 lines
2165 bytes
Hi,

I downloaded Turbo C++ Explorer and tried to port my app (originally working 
under BCB6) to TC++Explorer. Firstly, the TSQLConnection in TC++E is 
working, connecting to my MySQL database without complaints. Then I dropped 
a TSQLDataSet and set the CommandType to ctTable. When I clicked on the 
CommandText property to select a table, nothing happened. There is no list 
of Tables for me to select as it's supposed to have. So I changed the 
command type to ctQuery and clicked the CommandText, I was show a dialog 
where the name of my database is shown correctly in the Schema Name, but 
there is not list of Tables or Fields, they are empty! I ignored the problem 
and go ahead typed in "SELECT * FROM classlist" in the SQL box and try to 
ativate it. All I get is "dbExpress Error:[0x0003]: Invalid Field Type". 
What gives?

I tried with all other dbExpress components, the results are the same. 
However, my original app, which is done in BCB6 works without any fuss. Why 
is the supposedly newer (or even if they never fixed or update the 
components since BCB6 - they are supposed to behave in the same way) 
dbExpress in TC++E act worse than those already 4 or 5 years old ones in 
BCB6?

MySQL server version 4.0.20 (Appserv 5.2.1)

-- 
I Feel Good! 
Technical Details
Message-ID: <450147d3@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Thread: fb4e2,23cefe06ee2df069,start
X-Google-Attributes: gidfb4e2,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "kw" <kw@nospam.com>
Newsgroups: borland.public.cppbuilder.database.dbexpress
Subject: dbExpress: version problems? Invalid Field Type
Date: Fri, 8 Sep 2006 18:37:03 +0800
Lines: 28
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
NNTP-Posting-Host: 60.48.207.89
Message-ID: <450147d3@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1157711827 60.48.207.89 (8 Sep 2006 03:37:07 -0700)
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail