problems in ADO recordset filter

[vikramshenoy]

hello,
I have applied filter to a ADO recordset (containing 2 records) which filter the recordset and gives me a single record satisfying my condition.But if i further filter the single record and if the filtering condition is not met
(i.e filter fails) then shouldn't I be getting a EOF and BOF condition as true ?

Presently I am getting the cursor pointing to the second record of the original recordset.I am confused .please help...

thanx
viks

 

[CCLINT]

A new Filter will cancel out the old Filter and use the original recordset.
So, you cannot set a filter on a filtered recordset.

If a filter returns no records, then the BOF and EOF will be set to True [/b][/i][/u][sub]*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!