No record found

eapsokha · February 27th, 2004, 12:25 AM

How can I know that there is no record found in the recordset?

Imar · February 27th, 2004, 02:58 AM

Hi there,

If you're referring to an ADODB.Recordset, you can check its EOF (End Of File) Property:

Code:

Set MyRecordset = MyConnection.Execute(MySQLStatement)
If Not MyRecordset.EOF Then
  ' Records Found
Else
  ' No Records Found
End If

HtH,

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.