lookup problem

Richard Kreiss rkreiss at verizon.net
Tue Aug 3 13:35:21 PDT 2010


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.  

 

@bk = "s"

Rn=sales(@rn);GOTO get_sjn

 

When <s> is pressed, I get an error message 

 

 

*** 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

 

 

Field not found.

Lookup has not been performed.

 

The odd thing is this only happened with dclerk 5.6.10 windows not with
rclerk 5.6.10.

 

Has anyone else encountered this problem?

 

Richard Kreiss

GCC Consulting

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20100803/abcb1002/attachment.html 


More information about the Filepro-list mailing list