All files (3.4.0.3) use rs.EOF or rs.BOF to check if a recordset is empty. I think it should be rs.EOF and rs.BOF. This doesn't cause any effects or bugs though, but...
quote:If you open a Recordset object containing no records, the BOF and EOF properties are set to True
If only BOF or EOF is true, the recordset may not be empty. If you depend on the fact that
quote:When you open a Recordset object that contains at least one record, the first record is the current record and the BOF and EOF properties are False.
then why don't you just check only rs.EOF (or rs.BOF)?
I always use "if rs.bof and rs.eof" as a test, although so far a non-empty recordset will never open with either bof or eof true. However it would be possible (unlikely though) to move the rs pointer and erroneously detect an empty recordset if you don't test for both bof and eof being true simultaneously.
quote:If you open a Recordset object containing no records, the BOF and EOF properties are set to True
If only BOF or EOF is true, the recordset may not be empty. If you depend on the fact that
quote:When you open a Recordset object that contains at least one record, the first record is the current record and the BOF and EOF properties are False.
then why don't you just check only rs.EOF (or rs.BOF)?
all depends on how you're moving through the recordset, especially if you are deleting records... that's why I asked you to explain a bit further.
Topic Locked
Posted - 18 April 2003 : 23:20:12
