Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can you SET FILTER within a SET FILTER?
Message
 
To
13/05/1998 15:44:56
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00099163
Message ID:
00099192
Views:
30
>>>I want to set filter and then set filter again using the previous filter. Can I do that?
>>
>>Yes you can store filter expression and then use it again:
>>set filter to id=123
>>cFilter= filter()
>>set filter to
>>*** no filter now
>>set filter to &cFilter.
>>*** filter restored
>---
>Hi Edward
>can you - set filter to id=123
>and then in that filter,
>can you set filter to name = 'mary'.
>your records would look like this.
>id name
>123 mary
>123 mary
>123 mary
>
>inotherwords, can you set filter within a set filter?

Simply concatenate the old filter and the new:
SET FILTER TO id = 123
lcold = FILTER()
SET FILTER TO Name = 'Mary'
lcnewfilter = FILTER() + ' AND ' + lcold
SET FILTER TO &lcnewfilter
hth,
George

Ubi caritas et amor, deus ibi est
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform