[Lazarus] What is a TSQLTransaction and why do I need one?
Mark Morgan Lloyd
markMLl.lazarus at telemetry.co.uk
Wed Dec 1 14:50:16 CET 2010
Joost van der Sluis wrote:
>> Is there somewhere I can hook into the TSQLQuery to (a) see exactly what
>> query was passed to the server (b) collect any error text and (c) get
>> execution timing?
>
> a) Easiest is to use the database-client's log mechanism. (If there is
> any). Else you can change the TPQConnection.Preparestatement function.
> The 'buf' parameter is the actual query. But as you'll see it also adds
> some more to the query, so it opens a cursor, before it is send to the
> database-server.
>
> b) Ehm.. the error-text is in the exception?
>
> c) Hook into TPQConnection.PrepareStatement and TPQCOnnection.Execute
Thanks Joost, all noted.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
More information about the Lazarus
mailing list