>>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.