Devart Forums

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.

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

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.

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