Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Scan and filtering in data environment
Message
 
 
To
05/07/2006 09:46:54
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01133807
Message ID:
01133811
Views:
11
The SCAN command respects filters set on a table. However it'll not work they way you posted because it's missing FOR clause.

>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
>
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform