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