SEO

#1 (**permalink**) 04-08-2008, 06:01 PM

hello,i meet a problem!
when i write a store procedure ,i want to show error msg myself,so i
use @@error to point the error. the question is how can i find which
column induce the error just like the DBMS tell me when i run a sql in
isql?
pls help me!

#2 (**permalink**) 04-08-2008, 06:01 PM

You can generally get the error message template from
master..sysmessages where error = @@error. However, there is no way to
get any of the values (table name, page number, etc) that are
substituted into the error message outside of the client program
parsing the message it received (i.e. it has to be done outside of
TSQL)

There is an open feature request for a global variable that would
contain the full text of the most recent error raised, CR 296395.

#3 (**permalink**) 04-08-2008, 06:01 PM

thanks, i must find another way to show the error message.wowo......
bret@sybase.com wrote:
> You can generally get the error message template from
> master..sysmessages where error = @@error. However, there is no way to
> get any of the values (table name, page number, etc) that are
> substituted into the error message outside of the client program
> parsing the message it received (i.e. it has to be done outside of
> TSQL)
>
> There is an open feature request for a global variable that would
> contain the full text of the most recent error raised, CR 296395.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

about error message