GetTables does not seem to work properly

tripunkt · Post by **tripunkt** » Thu 27 Sep 2007 17:25

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

Antaeus · Post by **Antaeus** » Fri 28 Sep 2007 09:27

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

tripunkt · Post by **tripunkt** » Fri 28 Sep 2007 15:35

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

Antaeus · Post by **Antaeus** » Mon 01 Oct 2007 09:19

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