I've been batting this about in my head for over a day now... I'm hoping the
pool of experience can lend some insight.
Background: I have an app that is just a front-end to a table of
information. In Palm-speak, it's a Form with a Table that displays Records
from a Database. Because the table is too long to scroll through, I want to
provide a query mechanism.
Question: How can I return the results of a query to the user.
Answer: I've thought of two ways:
1) Identify the records matching the search criteria using their unique IDs.
I'm not clear on how I could also sort these records.
2) Copy the matching rows to a second table that is used for displaying the
records. The second table could then be sorted using quicksort.
Explanation:
The second case appears less complicated, but copying records might be
expensive. The records are 26 - 34 bytes long. Also, if the search isn't
narrow, then almost an entire copy of the database will be made.
The problem with the first case is knowing the best way to flag a record as
"viewable" and then to impose some kind of order on the "viewable" records.
I guess I could call DmMoveRecord on them so that they are physically
ordered.
Any suggestions or insights would be appreciated. Thanks.
Gary Miller
Consultant, CIBER Inc.
(703) 610-6564
[EMAIL PROTECTED]
--
For information on using the Palm Developer Forums, or to unsubscribe, please see
http://www.palm.com/devzone/mailinglists.html
