Have you looked at DmFindSortPosition?
Joel Henderson wrote:
I was able to convert an Excel spreadsheet into a pdb file using
PDB Converter. The list was already sorted in Excel so I am
assuming that I won't need to use the DmSort features.
Also the records will consist of one numerical field, so indexing
will not be needed.
My Question:
Is there a better way to search the database than using DmQueryRecord
and cycling through by index? I was thinking of writing a for loop and
some
sort of algorithm so it doesn't search 1 by 1. I'm sure I can figure
something
out but didn't know if there was a function for this that I wasn't
aware of.
On Mar 31, 2006, at 12:13 AM, Thomas Damme wrote:
Joel Henderson schrieb:
I am new to Palm databases. Here's my questions:
1) I need to import about 30,000 records onto a Palm TX. Can anyone
recommend a software tool that I could use to import these records
from MS Excel and export it to a pdb file that the Palm OS will be
able to read?
There are plenty of tools for this:
http://flippinbits.com/twiki/bin/view/Main/DevelopmentToolsList
2) My program needs to search through this database of 30,000
records and find one unique record. Each database record will
consist of one unique number. Is there any way to do this using the
DmGetRecord() or DmQueryRecord() functions and have it cycle through
all of the indexes?
It depends what are you looking for: the ID or the content of another
field. In general it is wise to sort the database after the field you
are looking for. If you have more than one field, you will need indexes.
When it is sorted once, there is no need to to cycle through all
records.
Thomas
--For information on using the PalmSource Developer Forums, or to
unsubscribe, please see http://www.palmos.com/dev/support/forums/
--For information on using the PalmSource Developer Forums, or to
unsubscribe, please see http://www.palmos.com/dev/support/forums/
--
For information on using the PalmSource Developer Forums, or to unsubscribe,
please see http://www.palmos.com/dev/support/forums/
