Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Clearing a filter
Message
From
23/09/1996 07:14:16
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00008268
Message ID:
00008431
Views:
28
>>How can I clear a filter I have set programmatically to a data environment? I use, for example,
>>
>>thisform.dataenvironment.cursor1.Filter = 'State = "CO"'
>>
>>to set a filter on the cursor. If I issue either
>>
>>thisform.dataenvironment.cursor1.Filter = ''
>>or
>>thisform.dataenvironment.cursor1.Filter
>>
>>both give me an error. I am looking for the new equivalent of SET FILTER TO.
>>
>>Thanks so much.
>
>how about thisform.dataenvironment.cursor1.filter = .t.
>
>kludgey, but it should work. of course, what you were doing should work too...

I had tried setting it to .t.; no go.

I ended up using

thisform.dataenvironment.cursor1.filter = 'state = state'

which is always true, but that doesn't seem the most elegant solution. I don't want to close and reopen the tables. Issuing SET FILTER TO will work if the cursor I want to clear happens to be the current cursor, but I have several tables open at once and want to cover all of the bases.
Tina Robichaux
Interland, Inc.
www.interland.net
Previous
Reply
Map
View

Click here to load this message in the networking platform