[Lazarus] show tables problem

claude claude.pomalo at free.fr
Sun Jul 4 15:44:46 CEST 2010


hi

i have created a component to dump mysql database whis zeoslib.
Converting it to use lazarus SQLDb component i have the folowing problem

to list table in my database i use the "SHOW TABLES" statment.
According with the mysql 5 syntax
SHOW [FULL] TABLES [{FROM | IN} /|db_name|/]

    [LIKE '/|pattern|/' | WHERE /|expr|/]

I use a "SHOW TABLES FROM dbname". this work well with zeoslib but
on SQLDb. the query raise an error:

"Error executing query: table "mysql.mysql" does'nt exist"

using only "SHOW TABLES" work and return result

I think it 's a bug
no?


thanks
Claude
 








More information about the Lazarus mailing list