Subject | Re: [firebird-support] how can i get the sql code of the current executed statement |
---|---|
Author | Thomas Steinmaurer |
Post date | 2010-11-20T12:13:05Z |
> I want to get the sql code of the current executed statement. If thereIf you are using Firebird 2.5, this all can be done with the new Trace
> 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.
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/