SQL Error Messages

[BillyD]

Is there a way to return the SQL Native error to a Visual Basic program?

[Brian Smith]

Check out using raiserror. I've used it successfuly w/ RDO and the RdoErrors object. I believe it works the same way with ADO.


------------
BillyD at 3/9/99 12:55:14 PM

Is there a way to return the SQL Native error to a Visual Basic program?

[BillyD]

I do'nt think the raise error will work (Raiseerror will
only generate errors greater than 5000). What we are
trying to do is test for record locks and duplicate keys.
We would like to use the SQL native error numbers for
this. What we want is some way to get the native SQL
error number and trap it in a VB program.

I should have been clearer on this...sorry.

Thanks

BillyD.


------------
Brian Smith at 3/9/99 1:14:12 PM

Check out using raiserror. I've used it successfuly w/ RDO and the RdoErrors object. I believe it works the same way with ADO.


------------
BillyD at 3/9/99 12:55:14 PM

Is there a way to return the SQL Native error to a Visual Basic program?

[Gregory]

maybe using 'RETURN' statment would help...?


------------
BillyD at 3/9/99 1:27:11 PM


I do'nt think the raise error will work (Raiseerror will
only generate errors greater than 5000). What we are
trying to do is test for record locks and duplicate keys.
We would like to use the SQL native error numbers for
this. What we want is some way to get the native SQL
error number and trap it in a VB program.

I should have been clearer on this...sorry.

Thanks

BillyD.


------------
Brian Smith at 3/9/99 1:14:12 PM

Check out using raiserror. I've used it successfuly w/ RDO and the RdoErrors object. I believe it works the same way with ADO.


------------
BillyD at 3/9/99 12:55:14 PM

Is there a way to return the SQL Native error to a Visual Basic program?