Il 26/12/2012 15:53, William Oliveira Ferreira ha scritto:

Another point is add a transaction on your project and assign it to sqlconnection...

At least, i never connected without a transaction ....

>
> Did you set
>  SQLQuery1.Database:=MySQLConnection1;
>
> ?
>
> Also 'Show databases' will - to my knowlegde - not work. It is not valid SQL. > as far as I know, it's a metadata statement that is handled by the mysql client which translates it to an API call.
>

Thanks to both of you. Filling up SQLQuery and SQLTansaction properties (which most likely had been cleared from the example when changing TConnection from 5.0 to 5.1) now it works.

BTW "show databases" appears to work, because databases are shown.

Giuliano.

--
_______________________________________________
Lazarus mailing list
Lazarus@lists.lazarus.freepascal.org
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus

Reply via email to