vb5-rdo

Dear Experts,

Can you please  tell me how to detect there is no records in database by using RDO method ?
thanks


SWP
SWPAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
usermilesConnect With a Mentor Commented:
rstObject.movefirst
   If rstObject.EOF = True Then    
      MsgBox "No Records were found"
   End If

If you use the rst.EOF command in the above example, this will set the resultset to the first record , and the If statement tests to see if you are at the end of the file.
0
 
VerolandCommented:
If you want to check a resultset it is easier if you use if RS.rowcount = 0.
usermiles example with give a error if there is no record in the table.
0
 
manish77Commented:
I agree with veroland. The best way is to check the count property
0
 
jharriCommented:
Depending on the datasource and the ODBC driver in use, rowcount can be expensive.  I suggest the following:

if rst.eof and rst.bof then
    Exit Sub
Else
    'Process the records
endif

No need here to use a move method (which is what could generate the error)

0
 
SWPAuthor Commented:
UserMiles:

   thanks for ur answer, but I prefered using the following:) since the I am using the SQL Server, there are no problems in using the rowCount method, but if I am using the Acces Driver, then
jharri's method is suggested.

 If rs.rowcount=0 then
    msgbox "no record found"
end if
 
but I heard jharri said that the rowcount is expensive, why do u think so ?



SWP
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.