-
SQL Error Messages
Is there a way to return the SQL Native error to a Visual Basic program?
-
SQL Error Messages (reply)
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?
-
SQL Error Messages (reply)
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?
-
SQL Error Messages (reply)
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|