Mine was used for 10 digit item code lookup, many items had identical
digits in the 1st 3 positions so I displayed after 4 characters were
entered.
The number of characters can be adjusted for each application as you noted.
On 2/20/2013 5:14 PM, jan johansen wrote:
Doug,
I used Razzak's code and included something like you did.
Only I settled on 3. 2 was too little and 4 didn't work very well
because we have some clients that have a space at character 4.
Jan
-----Original Message-----
From: Doug Hamilton <[email protected]>
To: [email protected] (RBASE-L Mailing List)
Date: Wed, 20 Feb 2013 17:01:59 -0600
Subject: [RBASE-L] - Re: City Field in a Contacts form
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
