John,

>> but you may need to work on the partial name searching.
>> It seems silly to download 5000 records because the user has written "N"

>I agree.  We would need to force a min number of characters for the "begins
>with" query.  Something like 3 or 5 chartacters may do the job.

Just have the server return only enough rows to fill one page of your "grid" --
which I presume will be a table object.  This avoids sending large recordsets
(and therefore inconsistent response times), and lets you easily handle any
"begins with" entry even if just one character.

With only sending back (say) 11 rows, you minimize the wireless network traffic.
When they scroll, you pick up the next (say) 11 rows.  Basically it would work
much like how one normally populates a table object in Palm OS, except your
database is remote rather than local.

Doug

--
For information on using the Palm Developer Forums, or to unsubscribe, please see 
http://www.palmos.com/dev/tech/support/forums/

Reply via email to