Quite simply the question was/is... Can @@identity be relied on?
and also a statement of shock that generators dont exist in SQL Server 7!
which means an entirely different design approach to Interbase, Oracle.
-----Original Message-----
From: Chris Reynolds <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Date: Thursday, 4 November 1999 06:58
Subject: RE: [DUG]: Generators - Sequences, and Identities
we use @@identity all the time without problems so i am slightly confused by
the diatribe. What exactly are you missing?
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Tony Blomfield
Sent: Wednesday, November 03, 1999 3:47 PM
To: Multiple recipients of list delphi
Subject: [DUG]: Generators - Sequences, and Identities
Unless I have missunderstood, SQL7 has no equivolent of Interbases
generators, or Oracles Sequences? Instead it has the identity data type
which is akin to Access or paradox Autoincrement columns.
The only time you seem to be able to see what your identity value was/is is
immediatly following a insert statement.
Coming form an Interbase background for the last few years, this idea of
identity columns looks very decadent, and extremely shortsighted of
MS/Sybase, and really surprised me that it is still like this.
So what about the multi user situation. Can we guarantee that Select
Identity@@ will allways get the last identity for this specific user?
What a dumb dumb idea. It more or less completely ignores the concept of
using surrogate keys.
What do others do about this for MSSQL based Delphi Apps? It seems to me
that the only reasonable approach is to use an increment table, and
copmpletely abandon the Indentity concept. What are others doing here?
Thanks,
Tony.
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
