Nothing in the PalmOS API supports the notion of fields within a database
record. It is one big field as far as the OS is concerned. The task of
dividing the record into fields is left to the programmer to implement in a
way that is efficient and makes sense for the application. This is how the
internal PIM applications do it.
An alternative is using some kind of database engine like Oracle Lite or
Sybase. At the time we embarked on writing an enterprise app, these were not
in full release yet and the licensing requirements were an issue. I ended up
writing my own database engine that manages tables, fields, filters, and
lookups for me so I can work at a higher level and not reinvent the code
every time I need to make a new table or modify an existing one. It has paid
off as we've continued to enhance the main application. We were going to
make this engine available to developers, but things are just too busy
around here. I think I saw in passing someone has released something similar
at low cost or free.
.. Geoff
----- Original Message -----
From: Lurenzel <[EMAIL PROTECTED]>
To: Palm Developer Forum <[EMAIL PROTECTED]>
Sent: Monday, June 12, 2000 6:17 PM
Subject: Re: Can a Palm database have more than one field per record?
> In general a database row is divided into fields. The firstname in column
0
> would be a field. The lastname in the second column would be a field. I
see
> nothing that directly supports fields.
--
For information on using the Palm Developer Forums, or to unsubscribe, please see
http://www.palmos.com/dev/tech/support/forums/
