Cool! I actually thought of adding a field to the start of each record. But then I figured it would be harder to sort, etc. But maybe not. Then I read the warning in the Companion that said all records in a database should be of the same type. I guess there would be some performance overhead in having to check the record type all the time but that probably wouldn't be bad.
Andy Arhelger "Dave Lippincott" <[EMAIL PROTECTED]> wrote in message news:103552@palm-dev-forum... > > You could use the size of the record to determine which record type you're > working with. If your record types are not static in size (or happen to be > the same size), add a field to the beginning of the record that denotes the > record type so you will know which format to unpack the record as. > > ----- Original Message ----- > From: "Andy Arhelger" <[EMAIL PROTECTED]> > Newsgroups: palm-dev-forum > To: "Palm Developer Forum" <[EMAIL PROTECTED]> > Sent: Monday, December 02, 2002 6:07 PM > Subject: Application database design question > > > > I am designing an application that contains 2 different type of records. > One > > type of record would contain person type information like name, age, > > birthdate.... Then for each person I will have database records that > record > > information about some activity. Let's say this information is date, > weight, > > exercise information, ... The question is how do I handle the 2 types of > > data records in my database? Do I put both type of records in the same > > database or is it better to use 2 databases? One for the person > information > > and one for the records associated with that person? I am new to Palm > > programming and haven't run across any examples yet that show this type of > > data structure. > > > > -- > > Andy Arhelger > > > > > > > > -- > > 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/
