Subject Re: [firebird-support] how can i get the sql code of the current executed statement
Author Thomas Steinmaurer
> I want to get the sql code of the current executed statement. If there
> is some log or system table where are logged the executed sql statments
> it will be great (some kind of audit).
> If i use ADO to connect to the database is there way to get the executed
> statements.
> One more question - is there way to get the execution time with milliseconds accuracy.

If you are using Firebird 2.5, this all can be done with the new Trace
API. You can read my article here:
http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_audit_trace_steinmaurer

If you are serious about using the new Trace API, you should definitly
look at our FB TraceManager product.
http://www.upscene.com/products.misc.fbtm.php

The current public release is 1.0, but we are working on 1.5 with some
great additions, so I can provide you access to 1.5 beta, to start with
1.5 right away, instead of starting with 1.0.


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/