[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