How do I see the result of calling a stored procedure in VB6 ?

Hello
I'm calling a stored procedure in VB6 using the "execute" command of
rdoquery.
Does anyone know how to check whether or not the execute command was
succesfull or not. Not on the level of whether any rows were updated or
selected but whether any Sql errors occured. VB picks up on any errors
but I want to be able to identify them on the application level and deal
with them myself.
I already tried the "rowsaffected" property but that isn't what I need.
Any ideas anyone ?

David Greenberg

Re: How do I see the result of calling a stored procedure in VB6 ?

David Greenberg (davidgr@iba.org.il) writes:
> I'm calling a stored procedure in VB6 using the "execute" command of
> rdoquery.
> Does anyone know how to check whether or not the execute command was
> succesfull or not. Not on the level of whether any rows were updated or
> selected but whether any Sql errors occured. VB picks up on any errors
> but I want to be able to identify them on the application level and deal
> with them myself.
> I already tried the "rowsaffected" property but that isn't what I need.
> Any ideas anyone ?

We used have a lot RDO in our system, but it must be four years at least
since we wiped out all of it, and went ADO.

I guess there is an Errors collection, and hopefully there is an
Error.Number there you can look at. Actually, when I think of it there.
I seem to recall that we had code that look an some individual errors.

I hope that you have been able to get hold of the documentation for
RDO, because else this venture into the past is not going to be fun at all.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx