Re: LOV Search screen problem - Forms 4.5

Tim,
  You're right about an LOV Find searching all columns, and about way a %text% search normally works. (scratched my head for a while when records were being returned that didn't contain the string I was looking for in the column the LOV was attached to, the string was there, only in a different column). That leaves the question of why you are not getting the return set you expect. LOV Find searches are case sensitive, so is it possible that the case of each of the characters of the entered string does not match the stored data exactly? If you are looking for %Bigg% and the name is stored as 'BOB BIGGINS', you won't find it.
Hope this helps,
Paul

In article <385f5a98.0_at_kastagir.senet.com.au>,   "Tim Hogben" <thogben_at_senet.com.au> wrote:
> The Help on LOV states that %XXX% does search all columns of the LOV
screen
> which explains why on most occasions the search is successful.
>
> Any ideas?
>
> Thanks
> Tim
>
> 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.
> >
> >Any ideas?
> >
> >Thanks
> >Tim
> >
> >
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 22 1999 - 02:26:21 CET