Page 1 of 1

PostPosted: Tue Jul 30, 2002 8:09 pm
by design4use
Does anybody here have any ideas on how to search a database fast (say contacts for all LastNames starting with "D"). I know how to access single records in the database, what I am wondering is whether there is a faster way then looping through each record, reading and comparing which is what I am doing right now.
Thanks for any leads...

PostPosted: Wed Jul 31, 2002 7:38 am
by dancreation
Try using moverec().

PostPosted: Wed Jul 31, 2002 3:07 pm
by design4use
moverec as I understand it just changes the position of a record. How do you envision this being used to find all records, e.g. whose entry "LastName" starts with "Dan"?

PostPosted: Wed Jul 31, 2002 5:21 pm
by PenreeSoft
I emailed Jeremy about adding support for the Global find in PalmOS, we'll see how it turns out, maybe we'll see it in OrbForms 2.0 :-D

Nicholas J. Penree

PostPosted: Wed Jul 31, 2002 8:10 pm
by design4use
that would be great - if it was accessible from Orbworks directly meaning you could access it in the background without a dialog, and do custom stuff with the find results...