> What we did, is to have an internal PK value (by a generator),
> insert the new records and once everything was inserted (saved)
> to the database and the transaction was committed (as in: no
> faults), we then did:
>
> UPDATE <table>
> SET UserVisibleColumn = GEN_ID(mygenerator, 1);
> (actually, the Oracle equivalent, but you get the idea).
> I don't think we ever missed a number.

Can you share some more information on this approach, please? As in how
do we actually implement something like this with
Firebird/Delphi/IBObjects, for example? The approach sounds safe, and
it's similar to what i've been thinking about, but i thought it would
need a server-side ON_AFTER_COMMIT trigger ...:)

Thanks in advance,
sugi.