> Is there a way to get a global transaction identifier for an sql
> statement?
>
> For instance suppose I have a trigger (on insert of a row in table),
> which inserts a row in another table.
>
> Is there a way to know that these statements have been executed from the
> same transaction?

If you are using Firebird 1.5, then you can use the CURRENT_TRANSACTION
context variable.


--
HTH,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2 (NEW!)
Upscene Productions
http://www.upscene.com