I have found that the uniqueID remains constant, and unique. I think that it is actually a MemPtr to the location in the Storage Heap where the record is stored. If this is the case, the uniqueness is quaranteed, but it *may* be moved in certain circumstances. I have not been able to duplicate a method of causing the uniqueID of a record to change...
I'd be interested to know an official opinion on this, as this topic seems to be relevent to may of us. There was a post earlier today by Simon St James asking a related question. (But refering to LocalID) Alan "Sean Kennedy" <[EMAIL PROTECTED]> wrote in message news:93652@palm-dev-forum... > > I am hoping someone can help clear up some confusion I have regarding > unique IDs of records in a database. > > I am working on a program that relies heavily on the concept that > each record has a unique ID, the unique IDs will not change, and the > unique IDs are in fact unique (no duplicates). However, after doing > some research it appears that unique IDs might not in fact be so > unique. They can change under certain circumstances and there can be > duplicates. > > So my questions are as follows: > > 1) Are the flaws in the unique ID system such that I really can't > rely on them, or are they more theoretical and won't be a problem in > the real world? > > 2) If the problems are real, I guess I have to "roll my own". Can > anyone point me to any advice as to the best way to do this? Off the > top of my head, I would probably just start generating my own unique > IDs from 1 and just count forward. I guess I would just need to keep > track of what the current highest numbered unique ID is so I could > simply generate a new one by adding 1 to this number. I could also > keep a list of unique IDs that came from items that have been deleted > so that they could be "recycled". Can anyone suggest anything better? > > I am appreciative of any help I can get. > > -Sean Kennedy > > > -- For information on using the Palm Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/support/forums/
