Re: LOV Search screen problem - Forms 4.5
Date: Mon, 20 Dec 1999 13:54:38 +1100
Message-ID: <83k610$3or$1_at_gossamer.itmel.bhp.com.au>
Tim,
You can only search on the first column in the LOV list. If you need to
search on more than one column then perhaps you should consider a second LOV
for the Description.
The other issue is that LOV's handle "begins with" correctly, but not
"contains".
Thus if you search for Bob% you will find Bob Biggins, but %Bigg% is
unpredictable.
[Quoted] Tim Hogben wrote in message <385ac13e.0_at_kastagir.senet.com.au>...
>Howdy,
>
>I am pretty new at this and have a question which I am hoping someone can
>answer.
>
>I have a LOV search screen which has two columns, the first being the code
>and the second being a description. The problem is when I use the <Find>
>button the results are not always as expected. Entering search criteria
for
>finding matches in the description column does not always come back with
the
>results.
>For example if the description column contained:
>"Bob Biggins" and I searched for %Bigg% it would not find this item.
Received on Mon Dec 20 1999 - 03:54:38 CET