Re: [lazarus] SQL DB access functional?

2006-04-19 Thread Jon Foster
Joost van der Sluis wrote: [...] With PostgreSQL it blows when I try to go up records in a grid instead of going down. Probably has more to do with I was going up from a newly inserted record. Yes, it was probably a bug in TBufDataset, which is used for all

Re: [lazarus] SQL DB access functional?

2006-04-19 Thread johnf
transaction.commit John On Wednesday 19 April 2006 09:23, Jon Foster wrote: Joost van der Sluis wrote: [...] With PostgreSQL it blows when I try to go up records in a grid instead of going down. Probably has more to do with I was going up from a newly inserted record. Yes, it was probably a

Re: [lazarus] SQL DB access functional?

2006-04-16 Thread Joost van der Sluis
I followed the on-line examples... At least as far as setting up the basic components. I've entered all of the login information in the connection properties. With PostgreSQL it blows when I try to go up records in a grid instead of going down. Probably has more to do with I was going up from

[lazarus] SQL DB access functional?

2006-04-15 Thread Jon Foster
Are the SQL DB components supposed to be functional? I've tried using TMySQLConnection and TPQConnection with the associated TSQLTransaction and TSQLQuery attached through a datasource to a data grid. The TMySQLConnection always says, Server connect failed when I try to make a query active.

Re: [lazarus] SQL DB access functional?

2006-04-15 Thread Michael Van Canneyt
On Fri, 14 Apr 2006, Jon Foster wrote: Are the SQL DB components supposed to be functional? I've tried using TMySQLConnection and TPQConnection with the associated TSQLTransaction and TSQLQuery attached through a datasource to a data grid. The TMySQLConnection always says, Server connect

Re: [lazarus] SQL DB access functional?

2006-04-15 Thread johnf
On Friday 14 April 2006 23:08, Jon Foster wrote: Are the SQL DB components supposed to be functional? I've tried using TMySQLConnection and TPQConnection with the associated TSQLTransaction and TSQLQuery attached through a datasource to a data grid. The TMySQLConnection always says, Server

Re: [lazarus] SQL DB access functional?

2006-04-15 Thread Jon Foster
Michael Van Canneyt wrote: On Fri, 14 Apr 2006, Jon Foster wrote: Are the SQL DB components supposed to be functional? That is because for each query, a new 'native' connection is started. Probably there is some limitation to your MySQL installation ? no, it works