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