lookup field

Richard Kreiss rkreiss at verizon.net
Wed Mar 16 09:35:28 PDT 2011



-----Original Message-----
From: filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com
[mailto:filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com] On
Behalf Of Kenneth Brody
Sent: Wednesday, March 16, 2011 10:15 AM
To: Ken Cole
Cc: Filepro 2 List
Subject: Re: lookup field

On 3/14/2011 5:14 PM, Ken Cole wrote:
> Or the variable is carrying it's value over from one record to the 
> next!

I thought of that, but I consider that part of #1.  But, until we hear back
from Richard, we can only guess.

The program is now working correctly with using mid.  I also moved the
lookup to the auto processing table in the one program where I could do
this.
This insured that the lookup actually took place.  This is one program where
I cannot run the program using the debugger without a major rewrite to avoid
the primary purpose of the program.  Moving the lookup to auto processing
insured that the variable was set for each record processed.

As for the other program using this routine, I did run the debugger and was
able to test that the variable was set properly.

Richard


[...]
>> Again, the single line of code you posted will only set IsNewYork to 
>> "Y" if the first 2 characters of foobar(34) are "ny".
>>
>> So, the possibilities I see are:
>>
>> 1) Something else in your code can also set IsNewYork.
>>
>> 2) The code to create the new record can be executed even if 
>> IsNewYork is not "Y".
>>
>> 3) You are mistaken in your belief that any records are being 
>> erroneously created in the first place.
[...]

--
Kenneth Brody
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes
http://mailman.celestial.com/mailman/listinfo/filepro-list



More information about the Filepro-list mailing list