If you must rely on the sort index, leave 'deleted' records in place and simply mark them deleted. You can reuse the records by linking them together in a 'deleted' list.
-------------------- Jeff Loucks Work 425-284-1128 [EMAIL PROTECTED] Home 253-851-8908 [EMAIL PROTECTED] Mobile 253-691-8812 -----Original Message----- From: Ralph Curtis [mailto:[EMAIL PROTECTED] Sent: Monday, November 15, 2004 12:59 PM To: Palm Developer Forum Subject: Re: question about record indexing technique Yes, they change from (x+n) to (x+n-1). The index is just the record's sort position in the db. Ralph "Jennifer Fell" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi, > > If I delete a record say with index x from the database, what happens > to the > indexes of records with a value greater than x? Do they change from > (x+n) to > (x+n-1)? > > - If not, what happens if a new record is added to the end of the > database using dmMaxRecordIndex? > - If yes, is there any way to avoid this? > > Thanks a lot. > > Regards, > Jenni > -- For information on using the Palm Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/support/forums/ -- For information on using the Palm Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/support/forums/
