select with no record returned

[elly00]

Hi

I've done a select in a sql table..like (select myart from listarticle)
The problem is that the select can return no records (if myarticle is not presenr in the table)
In this case I receive a sql error

So is there a way to check if the select doesn't return a recordset?

Thanks

 

[Andrzejek]

If you show here your code, I'm sure somebody will tell you what to change/add to detect the empty recordset returned.

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson