As with Generators a specific sequence is set for each table that requires the client
to access a
generated key before commit. All clients access the same sequence set for each table.
This
can be another table or a LAN ini or whatever.
There is another benefit of this approach and that is to do with Distributed
databases. Say you
have a number of Branch databases and wish to amalgamate some or all the data to a
central
database. It is a little more simple to do using the local transaction log and
replaying it against
the central database. Something that is not possible when the server dishes out the
keys. Each
Branch of course would be allocated a discrete sequence of numbers for each table
affected.
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
