not foobar lookup problem

[Kenneth Brody]

Quoting RKreiss1 (Wed, 19 Nov 2008 18:19:57 -0500):

> 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.

I think it's more likely that you have "foo" used for some other purpose
in the input table besides the lookup alias.  Lookup aliases in one prc
will not affect references to the same alias in another prc.

Check the rest of the input table for other references to "foo".

-- 
KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com