Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I SET FILTER TO and INDEX ON using that same fil
Message
From
11/06/1999 01:49:10
 
 
To
10/06/1999 23:43:17
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00228250
Message ID:
00228650
Views:
19
>>>How do I SET FILTER TO and INDEX ON myfld to temp using that same filter?
>>>I want to do a SET FILTER TO myfld = myvar.
>>>After I SET FILTER, I want to INDEX on one of the
>>>Fld values. When I do that and try to browse, it locks up. Can someone tell me what I am doing wrong? thanks...
>>
>>If you want an index that uses a filter, use the following syntax.
>>
>>INDEX ON CHAR1 TAG CHAR1 FOR CHAR1="somevalue"
>-------
>Hey Erik,
>It works great!.. thanks.. Does this mean I do not have to use
>SET FILTER?

I guess. I don't ever use filtered indexes...


and .. how do I release the INDEX.. I use to release
>by SET FILTER TO... ... :)

You just set the order to something else, or

SET ORDER TO

to set it to nothing.
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform