Hi,

> Is there SQL or stored(or UID) function to get current transaction ID ?

In Firebird 1.5, yes. Read the Release Notes.

With regards,

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