Invalid field size

[e arlati]

I have installed the rev 2.10 of dbExpress and now when I run the query "SHOW FULL PROCESSLIST" I got the error Invalid field size

If I use "SHOW PROCESSLIST" or other standard query all works well
The revision of mysql is 4.1.7 and my ide is Borland C++Builder 6

[Ikar]

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

As a temporary solution you can set LongStrings := False:

To use this option with TCRSQLConnection you may set it in Params property of TCRSQLConnection.

To use the option with TSQLConnection you should define constant and set appropriate option value using event handlers, e.g.
TSQLConnection.AfterConnect
TSQLQuery.BeforeOpen

Sample code looks like this.

Code: Select all

const
  coLongStrings = TSQLConnectionOption(101);

procedure TForm1.SQLQuery1BeforeOpen(DataSet: TDataSet);
begin
  SQLConnection1.SQLConnection.SetOption(coLongStrings, Integer(False));
end;