List:General Discussion« Previous MessageNext Message »
From:Dave Crawford Date:April 28 1999 10:59am
Subject:Re: Primary Key Renumbering... Bug?
View as plain text  
I apologize for my mistype last night, it was late. What I meant was:

delete from table where (ID < 40);
                            ^  
Where I deleted all records with an ID of less than 40. I tested it
again this morning and yes, it definitely moves the record in the #40
'slot' down to #1 along with 'sliding' down the remaining records.
Thanks again.

-Dave
Thread
Primary Key Renumbering... bug?Dave Crawford28 Apr
  • Re: Primary Key Renumbering... bug?Paul DuBois28 Apr
  • Re: Primary Key Renumbering... bug?Sasha Pachev28 Apr
Re: Primary Key Renumbering... Bug?Dave Crawford28 Apr
  • Re: Primary Key Renumbering... Bug?Paul DuBois28 Apr
  • Re: Primary Key Renumbering... Bug?Dave Crawford29 Apr
  • Re: Primary Key Renumbering... Bug?Benjamin Pflugmann29 Apr