lookup problem

Kenneth Brody kenb at fptech.com
Tue Aug 3 14:15:30 PDT 2010


On 8/3/2010 4:35 PM, Richard Kreiss wrote:
> I have a program which looks up from on file to another using index c in the
> second file.  The lookup was coded for the get lowest, using the master_code
> and a sequence number(NN).  Lv=master_code&sq. The lookup kept failing with
> record not found.  It even failed with just the master_code.
>
> When I check the second file using the master_code, the record came up.
>
> Each time I tried to get this lookup to work, it failed.  I created an @key
> routine in a test file using the same lookup code and it succeeded.
>
> I finally gave up with this routine and changed the lookup to a browse in
> descending order.  There are 2 records in the second file matching the
> master_code.
[...]
> *** 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
[...]

What is the exact lookup statement?  What is the exact value of the key used 
in that lookup?  How, exactly, did you "check the second file using the 
master_code"?

What is the exact lookup statement in your test file?  What is the exact 
value of the key used in that lookup?


-- 
Kenneth Brody


More information about the Filepro-list mailing list