Early versions of the desktop hotsync did not guarantee preserving the unique id, so it's better if you generate and maintain your own.
For more details, visit Palm's KnowledgeBase and search on "unique id": http://oasis.palm.com/dev/kb/ --Mike Y. www.ytechnology.com Ben A. HiLLeLi <[EMAIL PROTECTED]> wrote in message news:76216@palm-dev-forum... > > I've posted this on several newsgroups to no avail... > > I'm working on my first palm app... It is a BIG Palm App involving a > relational database with MANY "tables" (I know they are not really tables, > more like file i/o)... > > I've got one table created, opened and sorted... My question now is related > to the Primary Key. The Unique Identifier in a database used for ID and > linkage to other databases (as a "Secondary Key")... I know that PalmOS > assigns a uniqueID automatically in the database record header (a 3 byte > UniqueID says PalmOS API). My question is: Is > this what I "SHOULD" use as my primary Key? > > I am concerned about the fact that I am also synchronizing to a PC. Do > primaryID's assigned to the database header get changed by PalmOS under > certain circumstances (i.e. if a record is deleted or set to "archive" on > the Palm?)... I am worried about circumstances where database integrity > would be trashed by a UniqueID being changed or > reused by PalmOS when a new recorded is created... > > I've emailed this to soooo many newsgroups to no avail... If something is > not clear please notify me and I will clarify... I am at the > "clock-ticking-midnight-oil-burning-head-spinning phase" > > Sincerely Signed: > Ben Ahi HiLLeLi (Can send replies/questions etc. to: [EMAIL PROTECTED] if > you wish) > > ...A full time student that took on a project besides professors LouD > objections that it was too big :-) Trying to prevent the horrid "I > told you sooo" > > > > -- For information on using the Palm Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/tech/support/forums/
