Myles
If ADO Supports this (if only for MS SQL and Access) is this
part of the ADO Provider Spec (ie could other OLE DB Providers support this)
Neven
----- Original Message -----
From: Myles Penlington <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Sent: Monday, 27 November 2000 11:29
Subject: RE: [DUG]: embedded database.
> > 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"
>
---------------------------------------------------------------------------
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"
