Stephen
Code your own 'generator' as a stored proc using a UniqueIdentifier (GUID)
datatype
and the NEWID() function
Neven
----- Original Message -----
From: Stephen Bertram <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Sent: Thursday, 11 January 2001 15:31
Subject: [DUG]: [DUG-DB]: Unique IDs
> I need a bulletproof routine to create unique integer IDs for inserting
rows
> into multiple tables in a MSSQL 7 database.
>
> The catches are that I want the ID's to be unique in the database, not
just
> each table, and the generator must be available to stored procedures.
>
> Also the generator needs to unaffected by transactions - rollbacks should
> not reset the sequence of values - and the generator must not be locked by
a
> slow transaction.
>
> Any bright ideas?
>
> Stephen
>
>
> --------------------------------------------------------------------------
-
> 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"
