RE: [DUG]: embedded database.

[Myles Penlington]

> This is and interesting point - how do other access methods & SQL DBMS
> handle
> surrogate key generation - ie how do they relocate the record 
> they have just
> inserted

Very easily - they all fail. You  have to write special code to get the
generated primary key value back from the server. 
These days I generate a stored procedure for every table to do inserts, and
these return from the server the primary key value of the newly inserted
record which updates the TDataSets with the new primary key values.

Myles.
---------------------------------------------------------------------------
    New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED] 
with body of "unsubscribe delphi"