recordset no records?

[ozpeppers]

Hi

How do determine if a sql query generated any records? This is to stop an error "No current record" because no records were generated.

ie

mySql = Select * from staff;

RS.Open mySQL, Conn, adOpenDynamic, adLockOptimistic, adCmdUnknown

RS.movefirst - error occurs

Cheers

Mark

 

[woyler]

if not rs.eof then
'we have records
else
'no records returned
end if

 

[ozpeppers]

That easy hey

Cheers Mate