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/
