Devart Forums

Hello CoreLabs team,

I have recently upgraded to version 4.0 of the dbExpress driver for MySQL.
In my program, I use the TSQLConnection.GetTableNames to retrieve a list of tables in the database. With the latest release of your drivers, I now get the following Error: #42000You have an error in your SQL Syntax; check the manual...".
The actual statement sent to the database server is: 'GetTables "my_database"."my_database".% Table;View;'

It used to work smoothly with the previous version of the driver.
My environment is: Delphi 2007, dbExpress driver 4.0, MySQL 5.0. I really do appreciate a solution.

Thank you
Chris

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

Hello,

We have reproduced this problem and fixed it. This fix will be included in the next build of DbxMda.

sounds good - but is there any chance you could give me an approximation of when this would be? The code is part of a database-independent abstraction layer and I do not really like to hack any workarounds for the MySQL driver in there if it is going to be fixed in a foreseeable timeframe.

Thanks,
Chris

We are planning to release the new build of DbxMda including this fix in about couple of weeks.