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
