Hi, P

You have said:"some sort of integer as an output parameter", but I want to 
return data from SPROC as a recordset (i.e. SELECT * FROM T1).
For simplicity assume this is My_Sp's code:
   DELETE FROM T1
   SELECT * FROM T1
and the first line makes an error.


-----Original Message-----
> Mansoor

If no records are returned it won't necessarily throw an error.

I would get your SPROC to return some sort of integer as an output 
parameter
telling you
whether the SQL statement returned rows or not. 

Is this what you wanted to achieve or not?

P