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 > > > > > >
