Re: LOV in Forms 4.5 pops up: why?
Date: Wed, 25 Sep 2002 09:13:10 +0200
Message-ID: <amrnm6$2cs$1_at_mail.ic.uva.nl>
"Henk Hultink" <hhu_at_stopspam.stoas.nl> wrote in message
news:3d90906d$1_at_news.wau.nl...
> We are still using Oracle Forms 4.5 on Win98.
> I have the following problem: I have an item with an LOV attached, and
the
> LOV automatically pops up when a wildcard is entered in the field. The LOV
> for validation on the item is set to false, and I can't find any trigger
or
> procedure that sets this property to true.
> Seems that the wildcard (%) automatically triggers the LOV to pop up
anyway,
> akthough I want to allow the user to enter wildcards. So this is annoying.
> Does anybody have an idea how to stop the LOV from popping up?
Hello Henk,
I can only make a suggestion. Add a line to the LOV-record-group-query like
this:
<original statement>
union
select '%' from dual;
or something alike, depending on the number of columns in your record group.
Hope this helps, regards,
Joost
-- Joost Bataille University of Amsterdam ICT centreReceived on Wed Sep 25 2002 - 09:13:10 CEST