Subject RE: [firebird-support] Auto-Increment and Rollback
Author Thomas Steinmaurer
> If I have a application in Delphi (version 7 with IBX 7.08) and execute
> a Insert command (in a IBQuery in Delphi) but I change my mind and
> Rollback the transactions, why the field (with generator to
> auto-increment) in the table was add by 1, if my record was not write ?
> What I need to do to can not add 1 when transations was rollbacked ?

Generators are running outside of transaction control. Once
a generator value got increased, this value is gone, more or

You might find this useful:

Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions