>i am writing an application that uses sql selects to check the database, but if the select returns a blank recordset i get an error. i was trying to write code to check if the recordset is empty but cannot quite get it, can anyone give me a hand?
>cheers
>~M
Use the recordset's EOF property to detect an empty recordset.
if oRec.EOF then
end if
Michael McLain