Paul
The two probs with "identity columns" are
a/ They are only unique to a connection and
b/ They are only held for the last action (ie if your insert fires a trigger
and the trigger insert and idenity)
you are stuffed
PS
Did I note that Gary had posted this discussion to DUG tut tut :-)
Neven
----- Original Message -----
From: Paul Ritchie <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Sent: Thursday, 11 January 2001 17:37
Subject: RE: RE: [DUG]: [DUG-DB]: Unique IDs
> > (Interbase is so easy in this sense because generators are
> > produced outside any transactions).
>
> So are SQL Server identity columns, and I've got to say they're even
easier.
>
> <ducks for cover>
>
> Paul Ritchie.
> --------------------------------------------------------------------------
-
> 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"
