not foobar lookup problem

[RKreiss1]

Just as a heads up if you run into this problem:

Added some additional functionality to  file1 having it do a lookup to
foobar using the master-code from a record in file1 which had the same phone
# as the record I am sitting on.

Lookup foo=foobar  k=mc   i=c -xn
Not foo
END
More programming

Each time the program hit the not line, the debugger showed that the line
was true even though a record existed in foobar for that master-code.

After checking this a number of times, I checked my auto.prc table.  The
auto process table checks foobar using the alias foo for the current record.

When I changed foo to fop the lookup worked just fine.

Morel of the story, if one uses auto.prc and a lookup which should work
fails in input or output process, check auto for a lookup to that file.


Richard Kreiss
GCC Consulting
rkreiss at gccconsulting.net