Trouble getting data from MySQL

[criageek]

I'm new to Lazarus, very experienced with Delphi.  I'm trying to build my first database app, and I'm having trouble getting any data out of the database.  I downloaded the source from this page:

http://wiki.lazarus.freepascal.org/MySQLDatabases

and I'm trying to make that work.  After changing the connection component to a TMySQL50Connection I can connect, and it looks like the query is being sent.  I'm having trouble getting the debugger to work (I have a thread in the debug forum), so I put messages at various places to get status. and it looks like the query executes without any exceptions, but when I test the "active" property it says it's closed and no data appears in the dbgrid.  If I change the query to specify an invalid table name, it fails and says the table does not exist, so I know it's talking to the database.  

Another odd thing is that I can't do "show databases" and "show tables"....it says I have a syntax error in my sql (yet I can issue these commands from "MySQL Query Browser).

I'm using Ubuntu 6.10 on the 2.6.19.3 kernel, and MySQL Administrator says I'm using server 5.0.24a-Debian_9-log and client 5.0.21.

Any ideas what's going on?

Thanks,
Rich

[RudieD]

Do you use a ; at the end off the statement like in pascal like "show databases;" ?

[criageek]

I've tried it both ways...no luck either way.  The error message says something like "syntax error at '' in line 1".  I'm not at home so I'm going from memory right now.

Rich

[Vincent Snijders]

Can you try the following? Use

Code: [Select]

SqlQuery.Execute; to execute the query.

You can also try to set SqlQuery.ParseSQL := false;

Please update the wiki, if you get it working.

Disclaimer: I haven't tried this and I am not even sure about the exact method and property names.

[criageek]

Thanks for the tips Vincent.  I finally got this working, but I'm not completely sure what did it.  The way I have it now, I have to have a valid SQL statement in my TSQLQuery component, and I have to open the query in the FormCreate event.  If I don't do both of those, I get the exception detailed above when I try to do a query (with the same TSQLQuery component) later.  If I do both if I don't  of those it works fine.

Rich

[criageek]

Thanks for the tips Vincent.  I finally got this working, but I'm not completely sure what did it.  The way I have it now, I have to have a valid SQL statement in my TSQLQuery component, and I have to open the query in the FormCreate event.  If I don't do both of those, I get the exception detailed above when I try to do a query (with the same TSQLQuery component) later.  If I do both if I don't  of those it works fine.

Rich

Oops...I'll finish that last sentence properly.

"If I do both of those things, it works fine."

Rich