Help! Tricky(?) query in Forms 3.0.
Date: Fri, 16 Sep 1994 14:21:19 -0400
Message-ID: <9TcRsc1w165w_at_vicuna.ocunix.on.ca>
Hello:
I am having some difficulty with a Forms 3.0 query trigger. I have a table which contains employee information, including the employees' surnames. The surname is in a "pleasing format", ie. 'Frampton' or 'McDonald' as opposed to 'FRAMPTON' or 'MCDONALD'. Hey, I didn't design the table! :-)
Anyways, my form allows the user to perform a query based on surname. Trouble is, unless they enter the name in the same case it is represented in the table, no records are retrieved.
How do I change my query execution to match the upper(form_var) with the upper(table_record)? I have tried to play with KEY-ENTQRY as well as KEY-EXEQRY but I haven't been able to get this to work.
Any information would be greatly appreciated. Please reply via e-mail; I
read every posting that comes across in this newsgroup, but my feed
is...well...less than reliable. :-(
Thanks in advance!
Steve Frampton E-mail: <frampton_at_vicuna.ocunix.on.ca>
Received on Fri Sep 16 1994 - 20:21:19 CEST