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

You might find this useful:
http://www.ibobjects.com/TechInfo.html#ti_AuditableSeries



Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com