Sorry, I didn't make myself clear: I didn't doubt that the error variable will still hold a value but, surely, only of the _last_ command?
If SET ERROR MESS #### ON is run won't the error variable be for that command? Regards, Alastair. ----- Original Message ----- From: "MikeB" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Monday, June 06, 2005 1:41 PM Subject: [RBG7-L] - RE: Unable to suppress error messages? > Even with: > > Set mess XXXX Off > > The error variable still holds the value of the err mess Like > > > Set error var verr > set var vHoldErr int = null > > Select somecol from someTable wher someCol = 'SomeValueNotThere' > set var vHoldErr = .verr > > > The value of vHoldErr is 2059, so you can still check for error even with the > message suppressed from the GUI. > > > > > > ----- Original Message ----- > From: "Alastair Burr" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[email protected]> > Sent: Monday, June 06, 2005 2:02 AM > Subject: [RBG7-L] - RE: Unable to suppress error messages? > > > But that won't tell Dennis if there _was_ an error so it can be corrected > elsewhere. > > That said, shouldn't the values list be inside brackets? > > Also, I have noticed that there do seem to be some error messages that it > appears cannot be turned off. It would be nice to know which ones or what > circumstances cause a "forced" message. > > Regards, > Alastair. > > ----- Original Message ----- > From: Javier Valencia > To: RBG7-L Mailing List > Sent: Monday, June 06, 2005 5:44 AM > Subject: [RBG7-L] - RE: Unable to suppress error messages? > > > Dennis: > > Try the following: > > > > SET ERROR MESSAGE 2378 OFF > INSERT INTO vref pr_nbr vn_id vn_unitp vn_ltrns VALUES + > .prnbr, .vnid, .unitp, .trdate > SET ERROR MESSAGE 2378 ON > > > > Javier, > > > > Javier Valencia, PE > > President > > Valencia Technology Group, L.L.C. > > 14315 S. Twilight Ln, Suite #14 > > Olathe, Kansas 66062-4578 > > Office (913)829-0888 > > Fax (913)649-2904 > > Cell (913)915-3137 > > ================================================ > > Attention: > > The information contained in this message and or attachments is intended > > only for the person or entity to which it is addressed and may contain > > confidential and/or privileged material. Any review, retransmission, > > dissemination or other use of, or taking of any action in reliance upon, > > this information by persons or entities other than the intended recipient > > is prohibited. If you received this in error, please contact the sender and > > delete the material from all system and destroy all copies. > > ====================================================== > > > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Dennis Fleming > Sent: Sunday, June 05, 2005 11:31 PM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Unable to suppress error messages? > > > > For the following: > > SET ERROR MESSAGES OFF > INSERT INTO vref pr_nbr vn_id vn_unitp vn_ltrns VALUES + > .prnbr, .vnid, .unitp, .trdate > SET VAR verr = .vderr > SET ERROR MESSAGES ON > > Error message (2738) still appears if the constraint to not allow a duplicate > key will occur. > > 1. Are there other error messages which can't be suppressed? > 2. Is it just constraints? > 3. In this case I can check if the combined key is already there, but this > code worked without an error in 6.5 > > Thanks, > > Dennis > ***** > > > > Dennis Fleming > IISCO > http://www.TheBestCMMS.com > Phone: 570 775-7593 > Mobile: 570 351-5290 >
