"B Wiley Snyder" <wwwileynet@stripped> wrote on 04/11/2005 10:38:12 PM:
> Hello experts,
>
> I just need someone to please point me in the right direction on
retaining
> my "key" or id order in my table when I delete a row. So for example I
have
> 10 rows Id 1-10 that are created automatically when the record is
inserted.
>
> So if I delete record with id 5 my id's are not 1,2,3,4,6,7,8,9,10 but
> 1,2,3,4,5,6,7,8,9 ???
>
>
> thanks
>
> _________________________________________________________________
> Express yourself instantly with MSN Messenger! Download today - it's
FREE!
> http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
>
It sounds like you are confusing a data storage requirement (a unique,
non-repeating identifier for every row) with a presentation requirement (a
neatly numbered list of records). If I need a nicely ordered list of
numbers, I use my programming language to provide it. If I need to
uniquely identify a record, I use the ID.
When an ID has been issued, it generally stays "used" even if that record
no longer exists.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
