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/
