View Single Post
Old 05-29-2007, 08:33 AM   #8 (permalink)
Salchester
Salchester
 
Salchester's Avatar
 
Join Date: Jul 2005
Location: In a house
Posts: 230
Salchester is an unknown quantity at this point
Delete Records using an Array

Quote:
Originally Posted by sde View Post
yeah, the purpose of an id field is just so that each record has a unique piece of data you can identify it with.

as you pointed out, the id's will have gaps when you delete them, but why do you need to number them?

is it only so you can show the users a nicely numbered list? if that is the case, then you should just number it when you print out the data to the user.. you don't have to use a database field for that.
SDE,

As you mentioned above, why do I need to number them?
I'm not numbering the records to output a numbered list, so why do I need the ID's?

I'm now confused, so do I need the ID's now? :-)
But how will the code now which records to delete?

Many Thanks,
__________________
Many Thanks, in advance!

Salchester.
The Future Is Here - Are You Ready?
Salchester is offline   Reply With Quote