No - but then we have not tested it with lots of users. We are using Midas
and have customised the Dataset Provider to go and get the Unique ID for the
table when an insert is made. It works well under these conditions.
> -----Original Message-----
> From: Julien Thomas [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, November 03, 1999 3:52 PM
> To: Multiple recipients of list delphi
> Subject: RE: [DUG]: Generators - Sequences, and Identities
>
> We use a separate table to maintain the nextID for all the tables.
>
> > -----Original Message-----
> > From: Tony Blomfield [SMTP:[EMAIL PROTECTED]]
> > 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
