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.
"Invalid field size" on "show create table"
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.
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.