Re: [SQL] Re: unique sequences

2000-06-27 Thread DalTech - Continuing Technical Education
I imagine it should if you create a unique index on the field. Cheers, Christopher Currie - Original Message - From: K Parker <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 27, 2000 1:52 AM Subject: [SQL] Re: unique sequences > > Rather, each time

[SQL] Re: unique sequences

2000-06-26 Thread K Parker
> Rather, each time you wish to do an insert, > query the existing data to see what the > maximum value is existing in the database. > Add 1 to that and use this as your new value. > This is guaranteed to not have any holes in > the sequence. True, but alas it _doesn't_ guarantee uniqueness, sinc