>>>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.
>
>
> As long as you realise that CURRENT_TRANSACTION, if stored, won't be unique
> in the lifetime of the database.