Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need help using set filter to
Message
 
 
To
01/05/2000 15:24:43
Richard Williams
State of Ohio, Dept. of Development
Columbus, Ohio, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00364859
Message ID:
00364878
Views:
28
>Why can't I use this statement?
>set filter to grant_nbr=substr(grant_nbr,1,1) ="N" .or. substr(grant_nbr,3,1) ="C" .or. substr(grant_nbr,3,1)="J" .or. substr(grant_nbr,3,1)="L"
>??????????????Thanks Rick

Hi Rick,

Assuming there is a typo in substr(grant_nbr,1,1) and it should be substr(grant_nbr,3,1) you can use this statement:

set filter to inlist(substr(grant_nbr,3,1),'N','C','J')
locate

I think you know, that filters significantly slow perfomance...
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform