Re: LOV in Forms 4.5 pops up: why?

From: Joost Bataille <j.r.l.m.batailleREMOVETHIS_at_uva.nl>
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 centre
Received on Wed Sep 25 2002 - 09:13:10 CEST

Original text of this message