not foobar lookup problem

Kenneth Brody kenbrody at bestweb.net
Thu Nov 20 07:50:11 PST 2008


Quoting RKreiss1 (Thu, 20 Nov 2008 10:33:34 -0500):

> Ken,
>
> You are correct.  There is reference to sales = sales_journal in this input
> table.

And what does that have to do with "foo"?

>
> Richard
>
>> -----Original Message-----
>> From: Kenneth Brody [mailto:kenbrody at bestweb.net]
>> Sent: Thursday, November 20, 2008 9:31 AM
>> To: rkreiss1 at comcast.net
>> Cc: 'filePro'
>> Subject: Re: not foobar lookup problem
>>
>> 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
>
>
>



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


More information about the Filepro-list mailing list