Error when doing a lookup from a qualified file?

[Boaz Bezborodko]

> Date: Fri, 4 Apr 2014 11:19:54 -0400
> From: Bob Simcoe<bob at midcityoffice.com>
> Subject: Error when doing a lookup from a qualified file?
> To:"filepro-list at lists.celestial.com"
> 	<filepro-list at lists.celestial.com>
> Message-ID:
> 	<274496002CAD404D820DC44324478C66AA0952A42D at MIDCITY-SBS.midcity.local>
> Content-Type: text/plain; charset="us-ascii"
>
> Hi
> I only have one file with qualifiers, that only holds records. I never did any input processing with this file. Recently I needed to copy selected records using input processing. Sitting on the selected record in the qualified file I use the @wlf and the copy command to copy the record to the other file. I get the error below. I tested coping to other files and I get the same error. I used the same processing in a non-qualified file record and it worked correctly. Is the some restriction running input processing with a qualified file?
>
> *** A System Error Has Occurred ***
>
> On File: S:/filepro/filename/map
>
> Input Processing
> Line Number: 9
>
> lookup filename  k=41   i=b -nx
> ^
> Invalid argument
>
> Thank you
> Bob Simcoe
> CFO
> Mid-City Office Equipment Inc.<http://www.midcityoffice.com/>
> A Women Business Enterprise
> P. 716.832.0138 x201
> C. 716.725.8311
> F. 716.832.0892
> Follow us on Facebook<http://www.facebook.com/pages/MidCity-Office-Furniture/298763689497?ref=ts>
>
> For a Better Day at the Office

If you are looking up a non-qualified file from processing in the 
qualified file then you need to to add a '@' to the end of the filename.

Try changing your lookup to :

lookup filename@  k=41   i=b -nx

Boaz


---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com