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