>> Handling sql errors

[Jonathan]

Hi, using Access 2003 and SQL 2005.
I currently have stored procedures that do record updates. I would like to
return custom error numbers.

The following example returns 50000 as the error number as this syntax is
used for messages. How can I adjust the raiserror to return the error number?

*** Code Example***
BEGIN TRY
....
RAISERROR ('50005',11,1)
....
END TRY

BEGIN CATCH
SELECT @@ERROR
END CATCH
***

Any ideas or suggestions appreciated

Many thanks,
Jonathan

 

[Stefan Hoffmann]

hi Jonathan,

Hi, using Access 2003 and SQL 2005.
I currently have stored procedures that do record updates. I would like to
return custom error numbers.

The following example returns 50000 as the error number as this syntax is
used for messages. How can I adjust the raiserror to return the error number?

RAISERROR ('50005',11,1)

The @@ERROR always returns 50000, if you specify a message:

http://msdn.microsoft.com/en-us/library/ms178592.aspx

Use @@ERROR_MESSAGE instead:

http://msdn.microsoft.com/en-us/library/ms179296.aspx


mfG
--> stefan <--

 

[Jonathan]

ahhh it finally clicks into place.

Thanks Stefan,

Jonathan