Thanks Pal! That was a great idea!Just like an Adabase storage scheme! On Mar 31, 2006, at 2:03 PM, Roger Stringer wrote: At 03:16 AM 3/31/2006, you wrote:
Subject: Re: Querying a database
From: Thomas Damme <[EMAIL PROTECTED]>
Date: Fri, 31 Mar 2006 10:13:32 +0200
X-Message-Number: 15
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.
Couple of suggestions...
1) Sort it on the PC not on the PalmOS unit
2) Bundle multiple actual records inside of each PDB 'record'
I don't know how big your records are but aim for 10K blocks or 100 records, which ever is smaller.
--
For information on using the PalmSource Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/support/forums/
Roger Stringer
--
For information on using the PalmSource Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/support/forums/
|
- Re: Querying a database Joel Henderson
-
