Re: Q:How to use RAISE EXCEPTION in SPL?

> Jim Gordon (jgordon@systems.DHL.COM) wrote: > : > If you use error no, I think it's -769 or something close by, the > error: > text is simply '%s', so it takes whatever message you supplied. > The: > version 6.00 manuals tell you all about using this. The number is > : > specifically set aside for custom SPL errors. > > : -745 is the number > > Now I'm getting a little confused! > > -769 is definitely wrong. Finderr says "message number not found". > > For -745, finderr says: > -745 Trigger execution has failed. > > This message is defined for general use to apply to error conditions > that you specify in a stored procedure that is a triggered action. > > But there is also -746: > -746 message-string > > This is a message for which you supply message-string. You can apply > this message to error conditions that you specify in a stored procedure > that is a triggered action. The corrective action for this error depends > on the condition that caused it. Both the condition and the message text > are defined by you, the user. > > Now which one is correct for what purpose? IMHO, the answer to the > originalposter's question should be -746. > > Regards, Richard -746 is obviously the one. I guess it's just that none of us had our manuals next to us when we replied! akent@cix.compulink.co.uk (Andy Kent) -------------------------------------