'show databases' not working
lazarus / 16-Databases

----------------------------------------------------------------------
steve080233 · 2006-09-28 04:12

i'm trying to run the database component example posted on wiki at
http://wiki.lazarus.freepascal.org/MySQLDatabases. I've gotten to the
point where I can regular query's at the 'show databases' point, but
not the actual 'show databases' command that populates the list
component(well, I'm doing a list, anyway). I always get 'Error
executing query. You have an error in your syntax'. Obviously 'show
databases' works at the mysql prompt, but not from the gui.
help?????[/url]

----------------------------------------------------------------------
RudieD · 2006-09-28 15:24

I use 'show databases;' and it works fine. Did you remember to put the
; at the end of the command ?

----------------------------------------------------------------------
steve080233 · 2006-09-28 15:30

It wasn't in the published code, but I tried it anyway and got the
same thing. Get the same thing with 'show tables, with or without the
';'. Like I say, regular 'select * from <blah>' works fine even
without the ';'. Hmmm......

----------------------------------------------------------------------
RudieD · 2006-09-28 16:27

What version of MySQL are you running ?

----------------------------------------------------------------------
steve080233 · 2006-09-29 02:39

I have mysql  Ver 12.22 Distrib 4.0.26, for Win32 (ia32)

----------------------------------------------------------------------
RudieD · 2006-09-29 13:45

MySQL are now only at version 5.x ?