Error Handling

  • Thread starter Thread starter Roy Goldhammer
  • Start date Start date
R

Roy Goldhammer

Hello there

I have problem of using transaction on store procedure

When i running SQL store prosedure on access vb i get all there error
messages on access so i can know if the action done or not done.

Now when i started using transactions on the store procedures i don't get
the errors in access

What on the store procedure can cause this?

any help would be useful
 
If you're using explicit transactions in your stored procedures (BEGIN
TRANSACTION...) then you'll need to handle errors inside of the stored
procedure by trapping @@ERROR and return the information explicitly to
the client application as either output parameters or a result set.
Bear in mind that some things you might consider errors (like failure
to add a row) are not considered errors by the server, so you'll also
need to trap @@ROWCOUNT after certain operations. See SQL Server Books
Online for more information, or get a good book on writing T-SQL --
there's lots of them out there.

-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446
 
Back
Top