Lookup Filed not found error

WILLIAM LUCCA wlucca at prodigy.net
Tue Sep 25 09:56:44 PDT 2018


If you are sure the lookup is fine and "defile" has not been closed in the meantime, then without further information, I only have one other thought.  If you open the same file under 2 different aliases, then close either one of them, it closes the file and the lookup would fail, even if it uses a different alias.  Could that be the case here.  
If not, I suggest putting on the debugger right before the lookup line and then making sure the lookup works and stays open until you hit the line of code that is giving the error.
Bill Lucca
 

    On Tuesday, September 25, 2018 12:29 PM, Richard Kreiss via Filepro-list <filepro-list at lists.celestial.com> wrote:
 

 Have a process which does a lookup and test it starting with line 79 in my processing table. The program then does a GOSUB and copies the original record to a backup and then does a return.  The program then checks to see if some variable have been set.  Then tests to see if there is a dummy variable ln ne defile(3).  This is where I get the field not found error.

I know the lookup is valid as it has been tested previously and has been able to copy out the record looked up to a qualifier.  I don't know why defile(the alias) is failing the lookup.  Any suggestions as to why this code is failing.

I can repeat the lookup again but that would just be a work around for the issue.


Richard Kreiss
GCC Consulting


-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 15341 bytes
Desc: not available
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20180925/73221326/attachment.bin>
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes
http://mailman.celestial.com/mailman/listinfo/filepro-list


   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20180925/0654f51b/attachment.html>


More information about the Filepro-list mailing list