|
|
Posted by Erland Sommarskog on 07/18/07 21:50
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/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|