>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.

Claude

Do you mean "csitecode = gcsitecode" is the filter property on the table in the PEM in the DE?
Hmmm, not sure that the DE would actually "know" the variable yet on opening the tables, unless, as the name suggests. it's a global or passed as a param.

Notwithstanding, it can't hurt to include the filter in the Scan.

BTW it's SCAN FOR a.field != b.field AND a.csitecode = b.sitecode

HTH

Terry