Code Forums - View Single Post

Salchester · 05-29-2007, 11:22 AM

SDE,

Sorry, I think I'm confusing my-self, and you for that matter.

Currently I have a table that adds an ascending number to a ID column in a database, the problem is when a user deletes a record, gaps in the numbering are left.

Can the ID be set depending on the total amount of records stored in the database? Upon a record being deleted, the ID's are replaced with new ID's totaling the amount of records currently stored in the database.

For example, f i had ten records and deleted 4, the ID's for the remaining records will need to be replace with number 1-6.

Many Thanks,

05-29-2007, 11:22 AM	#10 (permalink)
Salchester Salchester Join Date: Jul 2005 Location: In a house Posts: 230	Delete Records using an Array SDE, Sorry, I think I'm confusing my-self, and you for that matter. Currently I have a table that adds an ascending number to a ID column in a database, the problem is when a user deletes a record, gaps in the numbering are left. Can the ID be set depending on the total amount of records stored in the database? Upon a record being deleted, the ID's are replaced with new ID's totaling the amount of records currently stored in the database. For example, f i had ten records and deleted 4, the ID's for the remaining records will need to be replace with number 1-6. Many Thanks, __________________ Many Thanks, in advance! Salchester. The Future Is Here - Are You Ready?