I want to get the code of the sql statement that fires trigger ...
if i have after insert trigger when an insert statements is executed i want to get the sql code of that insert into the trigger ...



-------- Оригинално писмо --------
От: Thomas Steinmaurer
Относно: Re: [firebird-support] how can i get the sql code of the current
executed statement
До: firebird-support@yahoogroups.com
Изпратено на: Събота, 2010, Ноември 20 14:13:05 EET

> 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/



[Non-text portions of this message have been removed]