> My database will have these fields: > > Code,Product,Embal,Value > > Sometimes,I'll need to find a record using the Code, another > time, using the > Product name. Which function can I use to search into a database > and return > me the record index or the record unique id in less than a second, without > creating indexes tables that will make my hotsync time increase > from 2 to 5, > 6 minutes? >
Generally, I would do this. Sort your database by Code, and keep it that way. Then, create another database that points to the original DB, and looks like this: Product, record id in original DB Sort this DB by Product. When you need to search by code, search your main DB, when you need to search by Product, search the lookup DB. I'm sure someone else might have refinements of this strategy, but the basic concept has worked fine for me. Good luck! - Colin -- For information on using the Palm Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/support/forums/
