> What kind number of CURRENT_TRANSACTION
> Is it auti increment can i used in my database without worry about
> duplicating it
> Or it repeat him self when all transaction finished (for example)

No it is a 32 bit integer > 0, which puts a limit on the possible
records. As others have mentioned, it is restored to 1 when you
restore the database (a good thing, otherwise your database could run
out of transactions and become unusable).

I believe there has also been some talk about changing the how the
transaction numbers rollover, but I am not sure of the details. For
the record, at 100 transactions per second, you dont even get a year
before the fireworks.

Assume only that it will be stable for the current transaction.

With Firebird 2, the new context variables make a lot of the uses for
CURRENT_TRANSACTION redundant.

Adam