lookup

[Kenneth Brody]

On 3/19/2014 10:38 AM, davidrottkamp at echoes.net wrote:
> Hi
>
>
> Doing a lookup with filepro 04.05.08R4
> lookup is a fuzzy search lookup
> also have flag for processing label so I can drop records if some other
> values in record are not true
>
> it is bypassing the processing label, not running that portion at all, if
> I change lookup to an index lookup it obeys the processing label
>
> any ideas or input would be great, we are moving to latest version of
> filepro shortly so if this is just a problem for my current version and
> works in later versions that would be great to know as well.

Works fine for me in 4.5.08R9 on Windows.

==========
::end:
@entsel::show "\r T \r - test fuzzy brwlook":
::end:
::fl(1,*,g):
@keyT::input popup ky(28,*,g) "Enter city to fuzzy search
 ":
:ky = "":end:
::fl = "":
::lookup zip = zipcodes  Z=3    K=ky   -n b="(brw=12 fuzzy=50 prc=zipit 
fill=asc)[Zip   State  City]*1    *2     *3 ":
::end:
zipit:::
:zip[2] = "NY":drop:
:fl ne "":end:
::mesgbox "Here I am in zipit." ; fl = "X":
::end:
==========

-- 
Kenneth Brody