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