A thought, Jason - do you have NULL set to a space while the form is in use?
Albert
Jason Kramer wrote:
I am trying to write a form that will display a steadily refined list
of names. I have a variable edit and a variable lookup list box. As
the user types in a name I wan the list in the list box to update by
dropping all the invalid names. For example, if my list of names is:
John Doe
Jason Kramer
James A Garfield
James Joyce
And the user types J, nothing will be changed, but if the user types
Ja, then John Doe should be dropped. The problem I am running into is
when the user gets to the point that there is a space in the name.
After the user types a space, the cursor jumps back to the first
position in the Variable Edit and the trailing space is dropped. So
far the only way I can find to work with a space is to type the first
and last name together (JamesJ) and then go back and add the space
(James J). The is probably not going to go over well with the end users.
I am currently using an ON KEYPRESS EEP that starts by getting the
TEXTVALUE of the variable edit and putting it into a variable
(GETPROPERTY vesearchbox TEXTVALUE vmyvar) and then using vmyvar to
refine the list:
SELECT COUNT names INTO vnamecount FROM mytable WHERE fname = .vmyvar.
Does anyone know of a way to handle a name (or other string) with
a space in it and retain the space using ON KEYPRESS? I can rewrite
the form so that the search limit is entered and then a button (or an
on exit EEP is fired) to trigger the search, but I thought that a
slicker implementation would have the list being refined automagically
(at least as far as the end user is concerned).
Thanks,
Jason
--
Jason Kramer
University Archives and Records Management
002 Pearson Hall
(302) 831 - 3127 (voice)
(302) 831 - 6903 (fax)
