"Invalid field size" on "show create table"

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for MySQL in Delphi and C++Builder
Post Reply
ffcDev
Posts: 8
Joined: Mon 05 May 2008 14:00

"Invalid field size" on "show create table"

Post by ffcDev » Wed 25 Feb 2009 22:09

Hi, when I execute the command:
"show create table xxxxxx"

I get the following error:
EDatabaseError: "Invalid field size"

My specs:

dbexpmda40.dll 4.40.0.14
Delphi 2009 SP2
MySQL 5.0.51a on Ubuntu 8.04.1
Win XP SP3

My setup:

TClientDataset->TDataSetProvider->TSQLQuery->TSQLConnection->DevartMySQLDirect

thanks,
Bill.

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Thu 26 Feb 2009 14:32

Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next DbxMda build.

ffcDev
Posts: 8
Joined: Mon 05 May 2008 14:00

Post by ffcDev » Wed 15 Jul 2009 20:32

Hi Dimon,

I've updated to the latest dbexpmda40.dll 4.40.0.16.

Now when I run "show create table ...." I get:

EDBClient: "Invalid field type."

I'm still using the same setup as before:

TClientDataset->TDataSetProvider->TSQLQuery->TSQLConnection->DevartMySQLDirect

Interestingly, when I just run the TSQLQuery (without sucking the data into the TClientDataset) I don't get an error, and I can inspect the fields returned. The second field (the one with the create statement) is an ftWideString with a size of 32,766.

After some trial and error testing, the largest sized ftWideString that a TClientDataset will allow is 32,764.

Can you check this out?

Thanks again for your help,
Bill.

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Mon 20 Jul 2009 13:41

Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next DbxMda build.

Post Reply