Subject Re: [firebird-support] Transactions
Author Thomas Steinmaurer
> 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.

Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2 (NEW!)
Upscene Productions