Lookup Question
Art Moore
cowboy at pcanswersinc.com
Thu Mar 2 20:33:49 PST 2006
I hope my question isn't too simple making every pass it by.
I am using filePro 5.0.05 on an XP system.
I am trying to do a lookup that I know should be water off a ducks back,
but.... I want the lookup to read a field in the current file (ACTIVITY)
and match it to a corresponding field in a MASTER file. If there is a match
then data from the ACTIVITY file along with data from the MASTER file is
written to a third FINAL file. I have made the lookup work but it always
ended with an error message because I know I am not ending things properly.
But, it worked and in my application I was able to live with the error
message.
But, now I would like the lookup to do a SHOW when the ACTIVITY file has a
number that does not show up in the MASTER file. The SHOW should stop and
display the number that is not found in the MASTER file and then when I hit
enter continue on.
I guess it would be nice that when the file finishes if it would not end up
with the error message also.
I am using the following code:
then: LOOKUP mas=MASTER k=6 i=A -nx
if: mas(1) ne 6
then: GOSUB nonum;END (this was just END before and worked but gave the
error message) now nothing happens
if: mas(1) eq 6
then: assigns variables to fields in current file and variables to fields
in MASTER file
if:
then: writes variables to fields in the FINAL file
if:
then: WRITE;END
nonum
if:
then: SHOW "@THIS NUMBER MISSING: " 6; RETURN
THANK YOU IN ADVANCE.
Art
More information about the Filepro-list
mailing list