GetTables does not seem to work properly

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for MySQL in Delphi and C++Builder
Post Reply
tripunkt
Posts: 13
Joined: Wed 06 Jun 2007 11:33

GetTables does not seem to work properly

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
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

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
Posts: 13
Joined: Wed 06 Jun 2007 11:33

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
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

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.

Post Reply