Post reply

Clear Errors

  • March 31, 2003 at 6:05 am

    #159286

    Can I clear errors when i am in the sp.

    because i want to run another sp if first statement retrned with error.

  • March 31, 2003 at 6:20 am

    #452554

    You can use @@error to determine if there is an error:

    if @@error <> 0 begin

    /* execute other statements and procedures in here */

    end

    Jeremy

  • March 31, 2003 at 7:44 am

    #452557

    thanks Jeremy Kemp.

    still it give me runtime error on vb app. (i execute the sp from vb, by giving "exec sp_kkk" )

    i want to clear errors from sp and execute another statment in sp to return some data.

  • March 31, 2003 at 7:57 am

    #452559

    My VB isn't great but if you use OnError to trap the error, you can then include some specific error handling in VB to check for errors (Err.Number). You'll probably find that a certain set of 'errors' reported by SQL Server are not reportable errors and you can ignore them in your VB code.

    I have always found that SQL Server always returns an error if there is an error in executing an SP and it is up to the client app to determine what to do with that error.

    Jeremy

  • March 31, 2003 at 7:57 am

    #452558

    My VB isn't great but if you use OnError to trap the error, you can then include some specific error handling in VB to check for errors (Err.Number). You'll probably find that a certain set of 'errors' reported by SQL Server are not reportable errors and you can ignore them in your VB code.

    I have always found that SQL Server always returns an error if there is an error in executing an SP and it is up to the client app to determine what to do with that error.

    Jeremy

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply