not foobar lookup problem

[John Esak]

 Richard,
Your analysis doesn't seem to me to be correct.  Can you put up a precise 4
or 5 line code duplication of the problem.  I can't.  I don't see how a
lookup done in auto processing can chave any bearing on lookups done in
another table... Unless you store some of the values retrieved in some
global variable and are referring to those variables.

Maybe something else is going on?  Incidentally, how are you changing the
key for the lookup when you say it is done several times... By changing
reords, or how?

Anyway, can't see a connection between something happening on the auto table
in a lookup affecting some lookup on another table.

John


> -----Original Message-----
> From: filepro-list-bounces+john=valar.com at lists.celestial.com 
> [mailto:filepro-list-bounces+john=valar.com at lists.celestial.co
m] On Behalf Of RKreiss1
> Sent: Wednesday, November 19, 2008 6:20 PM
> To: 'filePro'
> Subject: not foobar lookup problem
> 
> 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
>   
> 
>  
> 
> 
> 
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>