FWIW
After various tests I have concluded that when a Client needs to access the
result of an
Interbase Generated key value before the record is committed it is more efficient to
write an
Object initiated by the Client to generate the key value and forget the server side
generation.
This system works regardless of the update methods/options chosen. Its' only drawback
is that
if a user abandons a transaction it is possible to have gaps in the generated
sequence. If strict
sequence numbering is essential it is possible to place the abandoned number "back on
the
pile" for the next user to collect before returning the the "natural sequence".
Jim Quickenden
PerfectData Wellington
Ph: 064 4 801 5290
Fx: 064 4 801 5299
Mb: 064 25 465 108
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
