Hi,

> gstat can show transaction numbers (OAT, Next transaction).
>
> But how do I find out the transaction number corresponding to the
> current transaction (i.e., to a given isc_tr_handle) ?
>
> I need this to help finding out which is the query corresponding to
> the OAT.

With Firebird 1.5, CURRENT_TRANSACTION

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com