Article View: borland.public.cppbuilder.database.dbexpress
Article #28dbExpress: version problems? Invalid Field Type
From: kw
Date: Fri, 08 Sep 2006 10:37
Date: Fri, 08 Sep 2006 10:37
26 lines
2165 bytes
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-mailShow 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