VB.NET

VB.NET RSS

Raise error does not triggered VB.Net Exception

Please support our VB.NET advertiser: Intel Parallel Studio Home

•

Join Date: Jul 2004

Posts: 17

Reputation: lara_ is an unknown quantity at this point

Solved Threads: 0

lara_

Offline

Newbie Poster

Raise error does not triggered VB.Net Exception

21 Days Ago

Hi,

I have a VB.Net system that connect to SQL Server through ODBC.
When I try to raiseerror from an IF...ELSE statement, it does not triggered the exception handling.

I have done some raise error testing at my side. Below is my finding:

1. RaiseError did not triggered exception:

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
       CREATE PROC xxx
       AS
         IF 1=1
           BEGIN
             raiserror (70000,15,15)
           END
       CREATE PROC xxx
       AS
         IF 1=1
           BEGIN
             raiserror (70000,15,15)
           END

2. RaiseError triggered exception:

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
       CREATE PROC xxx
       AS
         IF 1=1
           BEGIN
             raiserror (70000,15,15)
             raiserror (70000,15,15)
           END
 
 
       CREATE PROC xxx
       AS
       BEGIN
         raiserror (70000,15,15)
       END
       CREATE PROC xxx
       AS
         IF 1=1
           BEGIN
             raiserror (70000,15,15)
             raiserror (70000,15,15)
           END


       CREATE PROC xxx
       AS
       BEGIN
         raiserror (70000,15,15)
       END

Any idea why it does not work in IF...ELSE statement?

Thank you.

KC

Last edited by peter_budo; 20 Days Ago at 12:37 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks)

•

Join Date: Oct 2008

Posts: 8

Reputation: lolafuertes is an unknown quantity at this point

Solved Threads: 1

lolafuertes lolafuertes is offline

Offline

Newbie Poster

20 Days Ago

Seems related on how SQL handles the severity level.
(http://msdn.microsoft.com/en-us/library/ms178592.aspx)

•

Join Date: Jul 2004

Posts: 17

Reputation: lara_ is an unknown quantity at this point

Solved Threads: 0

lara_

Offline

Newbie Poster

20 Days Ago

The severity level I used in testing is 15. By right, more than 10 should trigger exception.

•

Join Date: Jul 2007

Posts: 300

Reputation: jireh is an unknown quantity at this point

Solved Threads: 42

jireh

Offline

Posting Whiz

19 Days Ago

try to check if it was handled by a try catch function before it reach to your designated exception error to show. Also check if the option show exception error is check/included.

A conclusion is the place where you got tired of thinking.
http://www.martin2k.co.uk/forums/index.php?showforum=4
http://www.a1vbcode.com/a1vbcode/vbforums/Forum3-1.aspx
http://www.developerfusion.co.uk/for...orum&ForumID=4

•

Join Date: Jul 2004

Posts: 17

Reputation: lara_ is an unknown quantity at this point

Solved Threads: 0

lara_

Offline

Newbie Poster

17 Days Ago

Hi Jireh, There are no try catch function in between. I catch the exception in the function that call ExecuteNonQuery.

About the "show exception" checking option, I do not know where to check it. Can you show me where can I check that?

Thanks!

KC