Subject Generators as rows IDs
Author Fernando Azevedo
I use IBO and Firebird in a simple Delphi book catalog program I
developed. The PKs consist in firebird generators, triggered to
increment before each insert, as usual.The problem with this method (not
for me, of course, but for a client of mine) is that when we insert and
do not commit, the ID (the table PK) is lost, and therefore not used in
the next insert. This really annoys my client, because I use the ID in
grids, and as search parameters.
So, what do you suggest me? Is it possible for IBO to increment the
value only after commit? How will that affect my program?

Thanks in advance,

Fernando Azevedo
Rio de Janeiro, Brazil