Hi Albert - I did a similar thing and found that it was better to get
the first 2 or 3 characters before displaying "all" the results.
1) If it's a big list, it isn't that helpful to display 100 item after
the first character or 2 or 3.
2) The resulting list will probably display faster if there are only 20
or so items rather than 100.
Set a var called vCharCount that counts the number of characters typed
in, then:
IF vCharCount < 4 THEN
RETURN
ENDI
[display and processing code here]
RETURN
I haven't looked at Razzak's code - he may have something like that
already in place.
Doug
On 2/20/2013 10:56 AM, A. Razzak Memon wrote:
At 11:44 AM 2/20/2013, Albert Berry wrote:
Has anyone done anything like this? I'd rather not reinvent the wheel.
I would like to bring up a city name as the user types, and when a match
appears allow the user to press [enter] to save it or keep on typing if
it is a new city. I've got insert after and update after triggers to add
a new city to a table if it isn't already in it. I tried using a right
click eep on the field, but it's not elegant.
Albert,
Take a look at the "On Key Press" EEP option of DB Edit or Variable Edit
controls to achieve such goal.
R:BASE eXtreme 9.5 SAT Sample Applications includes an application to
demonstrate the use of such cool feature in R:BASE.
Database...: RBU_SAT
Section....: Sample Applications (Part II)
Application: Search Screens using the "On Key Press" EEP
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
