[Lazarus] Setting SQL locale

Michael Van Canneyt michael at freepascal.org
Mon Jun 13 20:46:03 CEST 2011



On Mon, 13 Jun 2011, Mark Morgan Lloyd wrote:

> When using the standard DB components connecting to e.g. a PostgreSQL 
> backend, is there an event that fires between the connection being 
> established and the query being issued?

Normally, I'd suggest TSQLConnection.AfterConnect ?

>
> I'm trying to send a SET TIMEZONE command to the server, to get DST 
> correction applied to the resultset. This has to be done using the same 
> handle as will be used for the query, otherwise the server thinks it's a 
> different session and it has no effect.

Hm. 
I think for the Postgres engine, there is a connection per transaction.
I don't think there is an event connected to the transaction. Joost will have to answer this one.

Michael.




More information about the Lazarus mailing list