From: "Ryan Bruner" <[EMAIL PROTECTED]> > Now, the catch is that one of the fields, for efficiency sake, is a > string of small size. If, however, the size of the data exceeds the > size of that field (set to 24 bytes now, previously it was 50 bytes), > then I store the data in a data record that ONLY contains the string > information. This "notes" field method allows me to have quick access > to most notes (which tend to be small for my application), but allow > larger notes as well. > One approach would be to store the notes in a single record as an array of index, string - essentially building your own data management and just using the database as a file system.
There's a fair amount of work involved in this, however, and I would have thought that your best bet was variable-length strings with the data you use for statistical analysis stored at the front of the record. You'd then only call the unpack routine if you wanted to display or modify the notes. Chris Tutty -- For information on using the Palm Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/support/forums/
