Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multiple Filters...how do I....?
Message
 
To
11/03/2003 12:24:43
N. Lea
Nic Cross Enterprises
Valencia, California, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00764210
Message ID:
00764330
Views:
28
The length of /set filter/ should not exceed 160 characters. So you either need to use another procedure for filtering or somehow control the filter expression. There could be numerous methods used depending on what do you want to do on filtered table:

1. Use sql select or table view
2. set relation into source table and then set filter to not eof(source_table)
3. index the source table and then set filter to indexseek(table.account,.f.,source_table,index_expression)
4. instead of /account #.../ use /NOT account$[list of numbers here]/,

etc...

>The filter string is going to be long because anyone can add as many accounts to filter as they want. the account field is character
Previous
Reply
Map
View

Click here to load this message in the networking platform