At 12:58 PM 19/04/2005 +0200, you wrote:

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

./hb