VFP 7 and 9
I looked in the help file and I am not sure about what happens.
In the data environment I have "csitecode = gcsitecode" for tables A and B where csitecode is a field in a table and gcsitecode is a variable that defines which site the user is at. The existing program has code like
SCAN a.field != b.field
code
ENDSCAN
my question is does the scan command honor the filters in the Data Environment or do I need to change the SCAN command to
SCAN a.field != b.field AND a.csitecode = b.sitecode
code
ENDSCAN
Any help appreociated.