lookup problem

[Richard Kreiss]

-----Original Message-----
From: filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com
[mailto:filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com] On
Behalf Of John Esak
Sent: Tuesday, August 03, 2010 4:59 PM
To: filepro-list at lists.celestial.com
Subject: RE: lookup problem

Your message is a little to scattered to understand precisely.  

Three things jump out. 

1)
You are referring to rn= here and there, and if you are looking for a key
based value in an index, you should be using k= in the lookup line.  Maybe
you have an r= by mistake because you are seeing the rn= ??  You really
should just post your code and not all the other stuff.

This is a typo

2)
Why do you put the value sales(@rn) into the dummy value RN. Why not just
use sales(@rn) in the lookup code? Maybe RN has some incorrect edit type to
hold sales(@rn). 

I use rn(len at rn),edit(@rn) later on in the program to get the specific
record from the sales file.

Pressing F6 and D show rn(8,.0)

3)
If there are two and only two records of the master record and you want a
value lower than that that doesn't exist, it of course won't be found.

Index C is sorted on the master_code and the sequence number.

The sales file being looked up to has over 366,000 records and there, at
present, can be from one record to 5 records for each master_code.  The
first, or oldest record has a sequence number of 00.

4)
Usually, errors saying 

> Field not found.
> 
> Lookup has not been performed.

Mean that the field being used for the key has not been defined.  So you use
something like k=ky and ky has no definition anywhere.

Rn is defined in this input processing table as it is used elsewhere,



Also you put...

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

Well, obviously, no one can get this... Until you change one of the
5.6.10's.

Please keep in mind, I test using dclerk put deliver tokenized tables to be
run with rclerk.

As I said, the program runs properly using rclerk but throws an error
message with dclerk.


John





> -----Original Message-----
> From: filepro-list-bounces+john=valar.com at lists.celestial.com 
> [mailto:filepro-list-bounces+john=valar.com at lists.celestial.co
> m] On Behalf Of Richard Kreiss
> Sent: Tuesday, August 03, 2010 4:35 PM
> To: filepro-list at lists.celestial.com
> Cc: fpsupport at fptech.com
> Subject: lookup problem
> 
> 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/attachment
> s/20100803/abcb1002/attachment.html 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
> 

_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
http://mailman.celestial.com/mailman/listinfo/filepro-list