Subject Generator and Triggers with IB6 from Delphi and IBX
Author Christopher P. Boothe
I have a question.

If I manually start a transaction for adding a new record. I'm using the
IBX components with IBSQL IBTransaction and IBUpdateSQL. Well anyway If I
manually start a transaction the user clicks to add a record, and the user
cancels and I then rollback the transaction. The generator will have
triggered and if the user then goes in and adds a new record because the
generator triggers again it will be 2 integers away from the last record.
It will skip one number?

Now this isn't a huge problem because the record will still be unique. But
I hate having order numbers skip every once in a while when someone cancels
an entry. Any way to take care of this?