lookup problem

Kenneth Brody kenb at fptech.com
Wed Aug 4 11:15:17 PDT 2010


On 8/3/2010 6:16 PM, Richard Kreiss wrote:
[...]
>> *** A filePro Error Has Occurred ***
>>
>> On File: C:\appl\ccp/filepro/transaction/index.A
>>
>> Input Processing
>>
>> Line Number: 450
>>
>>           rn=sales(@rn);GOTO lok_sjn
>> ^
>>
>>           @bk = "s"
>>           rn=sales(@rn);GOTO lok_sjn
[...]
> 445  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
>         ◄ If:
>         Then: aa="(brw=10 xkey=xs show=keep pop=show fill=desc,top)"
> 446  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
>         ◄ If:
>         Then: ab="[JOURNAL # START DATE  TYPE  PER    FEE       CC TYPE    LAST 4]"
> 447  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
>         ◄ If:
>         Then: ac="*1        *6            *7    *8  $*9          *14      *32"
> 448  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
> do_lk_r◄ If:
>         Then: lookup sales = sales_journal  k=16   i=C -NXm b=(aa&ab&ac)
> 449  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
>         ◄ If:         @sk = "BRKY" or @bk = "X"
>         Then:         CLEARB;SHOW "";pw="";END
> 450  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
>         ◄ If:         @bk = "s"
>         Then:         rn=sales(@rn);GOTO lok_sjn
> 451  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
>         ◄ If:
>         Then: CLEARB;END

First, as others have pointed out, you have no "if not sales" after the lookup.

Since you say this is failing in dclerk, I would add:

do_lk_r
     then: debug on
     then: lookup sales = sales_journal ...
       if: not sales
     then: ... do something ...

When you hit the lookup statement, check the value of field 16, including 
any leading, trailing, and embedded spaces.  What is the exact value of 
field 16, including all spaces?

Step through the lookup.  Did it display the browse window, and wait for you 
to press "S"?

What does the debugger show as the value of "not sales"?

-- 
Kenneth Brody


More information about the Filepro-list mailing list