Re: Question about autoincrement ID

2006-03-23 Thread saf
om table where deleted = 1 > limit 1". If this returns a result, use update to re-populate that record, > clearing the deleted flag. If it returns nothing, use insert to create a > new record. Great idea!! Many thanks!!! -- Best regards, saf http://Trashmail.net/ signature.asc Description: Digital signature

Re: Question about autoincrement ID

2006-03-23 Thread saf
On Thu, Mar 23, 2006 at 11:04:55AM -0500, [EMAIL PROTECTED] wrote: > [EMAIL PROTECTED] (saf) wrote on 03/23/2006 10:50:10 AM: > > The short answer is "no". The Record #2 already existed. It's current > status is "deleted". If you had other tables that link

Question about autoincrement ID

2006-03-23 Thread saf
imes) many entries in my SQL database, but not more than the highest value of an signed integer. -- Best regards, saf http://TrashMail.net/ signature.asc Description: Digital signature