ADO Filter Property 1

[Deadline]

Hi,
How to say whether the ADO filter property has had an effect on the Underlying RecordSet ?

I mean, what will be the result of applying filter, if there aren't any records satisfying the Filter Criterion ?
How should I check it ?


RR

 

[Swany]

Your recordset will be empty if no records match your filter criterion.

 

[Deadline]

Swany,

Thank you very much.

So, SHould I use rs.EOF or Rs.RecordCount or IsEmpty(rs) to check ?


RR

 

[jmarler]

the best way to check to see if a recordset is empty is the following check . . .


(rs.BOF AND rs.EOF)

If the record set is both at the beginning of file AND the end of file, then it is empty. - Jeff Marler B-)