Error when doing a lookup from a qualified file?

[Jean-Pierre A. Radley]

Bob Simcoe propounded (on Fri, Apr 04, 2014 at 01:37:19PM -0400):
| I'm sitting in the qualified file trying to copy the record I'm on to a normal file.
| I'm not coping to a qualified file.

Then do what Richard told you.

filePro assumes a lookup is to a file with the same qualifier (or
lack thereof) as the one you are coming from.

Otherwise, use filename@ or filename at other to lookup to something else.

| 
| Thank you
| Bob Simcoe
| CFO
| Mid-City Office Equipment Inc. 
| A Women Business Enterprise
| P. 716.832.0138 x201
| C. 716.725.8311
| F. 716.832.0892
| Follow us on Facebook
| 
| For a Better Day at the Office
| 
| 
| > -----Original Message-----
| > From: Richard Kreiss [mailto:rkreiss at gccconsulting.net]
| > Sent: Friday, April 04, 2014 12:15 PM
| > To: Bob Simcoe; filepro-list at lists.celestial.com
| > Subject: RE: Error when doing a lookup from a qualified file?
| > 
| > Top post:
| > 
| > Are you copying to another file with the same qualifier?
| > 
| > If not change the file name to:
| > 
| > lookup filename@  k=41   i=b -nx
| > 
| > The @ sign tell your program to post to the unqualified file.
| > 
| > 
| > Richard Kreiss
| > GCC Consulting
| > 
| > Office: 410-653-2813
| > 
| > 
| > 
| > > -----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 Bob Simcoe
| > > Sent: Friday, April 04, 2014 11:20 AM
| > > To: filepro-list at lists.celestial.com
| > > Subject: Error when doing a lookup from a qualified file?
| > >
| > > 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
| > >
| > > -------------- next part -------------- An HTML attachment was
| > > scrubbed...
| > > URL: http://mailman.celestial.com/pipermail/filepro-
| > > list/attachments/20140404/e6eee658/attachment.html
| > > _______________________________________________
| > > Filepro-list mailing list
| > > Filepro-list at lists.celestial.com
| > > Subscribe/Unsubscribe/Subscription Changes
| > > http://mailman.celestial.com/mailman/listinfo/filepro-list
| _______________________________________________
| Filepro-list mailing list
| Filepro-list at lists.celestial.com
| Subscribe/Unsubscribe/Subscription Changes
| http://mailman.celestial.com/mailman/listinfo/filepro-list

-- 
JP