I am quite happy with that, but will it be unique for SQL statements
executed in the same transaction? I am assuming that it will be.

Joseph


-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Thomas
Steinmaurer
Sent: 19 April 2005 14:55
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Transactions

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

Of course. ;-)

Cheers,
Thomas



_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe

>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> Service.


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