Re: [Lazarus] Setting SQL locale

2011-06-14 Thread Mark Morgan Lloyd
Mark Morgan Lloyd wrote: Michael Van Canneyt wrote: 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

[Lazarus] Setting SQL locale

2011-06-13 Thread Mark Morgan Lloyd
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? I'm trying to send a SET TIMEZONE command to the server, to get DST correction applied to the resultset. This has to

Re: [Lazarus] Setting SQL locale

2011-06-13 Thread José Mejuto
Hello Lazarus-List, Monday, June 13, 2011, 8:01:44 PM, you wrote: MML I'm trying to send a SET TIMEZONE command to the server, to get DST MML correction applied to the resultset. This has to be done using the same MML handle as will be used for the query, otherwise the server thinks it's a MML

Re: [Lazarus] Setting SQL locale

2011-06-13 Thread Michael Van Canneyt
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

Re: [Lazarus] Setting SQL locale

2011-06-13 Thread Mark Morgan Lloyd
Michael Van Canneyt wrote: 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

Re: [Lazarus] Setting SQL locale

2011-06-13 Thread Mark Morgan Lloyd
José Mejuto wrote: Hello Lazarus-List, Monday, June 13, 2011, 8:01:44 PM, you wrote: MML I'm trying to send a SET TIMEZONE command to the server, to get DST MML correction applied to the resultset. This has to be done using the same MML handle as will be used for the query, otherwise the