[Lazarus] TSQLQuery Error Database not assigned.

2012-12-26 Thread Giuliano Colla
I'm trying to familiarize with MySql components, using mysql 5.1. I downloaded the TryMySql example linked from the Wiki page, I've changed TMySQL50Connection to TMySQL51Connection, and set in SQLQuery ParseSQL=False and ReadOnly=true, as suggested, but when I try to run it, the connect to

Re: [Lazarus] TSQLQuery Error Database not assigned.

2012-12-26 Thread Michael Van Canneyt
On Wed, 26 Dec 2012, Giuliano Colla wrote: I'm trying to familiarize with MySql components, using mysql 5.1. I downloaded the TryMySql example linked from the Wiki page, I've changed TMySQL50Connection to TMySQL51Connection, and set in SQLQuery ParseSQL=False and ReadOnly=true, as

Re: [Lazarus] TSQLQuery Error Database not assigned.

2012-12-26 Thread William Oliveira Ferreira
Another point is add a transaction on your project and assign it to sqlconnection... At least, i never connected without a transaction Em 26/12/2012 12:37, Michael Van Canneyt mich...@freepascal.org escreveu: On Wed, 26 Dec 2012, Giuliano Colla wrote: I'm trying to familiarize with

Re: [Lazarus] TSQLQuery Error Database not assigned.

2012-12-26 Thread Giuliano Colla
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