[dba-VB] Just a Christmas quickie Using Not Instead of = False

Paul Hartland paul.hartland at googlemail.com
Thu Dec 24 06:09:00 CST 2009


To all,

I use a lot of recordsets, and to detect they actually contain something I
have always used the following:

If myrecordset.bof=false and myrecordset.eof=false then
    do my stuff here
Else
    msgbox "empty"
End If

However my project manager prefers:
 If not myrecordset.bof and not myrecordset.eof then
    do my stuff here
Else
    msgbox "empty"
End If

Is there actually a prefered way, or is one quicker than the other, or is
there an even better way to do this ?

Thanks in advance for any comments, and a very merry christmas & happy new
year to everyone.

-- 
Paul Hartland
paul.hartland at googlemail.com



More information about the dba-VB mailing list