PDA

View Full Version : what is the best way to test for zero recordsets?

rimian
06-23-02, 02:15
hello!

i have been doing it this way but i'm not too sure if i am doing it right:

if rs.EOF = true and rs.BOF = true then
'for nothing returned
else
'something returned
end if


thanks in advance!
rnealejr
06-24-02, 01:31
Perfect. If you are using a client-side cursor, then you can use rs.Recordcount and depending on the database used you can determine x records returned. But if you are already using a recordset object and recordcount is not available, you are correct.
rimian
06-24-02, 03:57
thanks!

i think i know what a client side cursor is. i'd like to know what else is there.

i'll work it out.

HA HA