SET ERROR MESSAGE 2738 OFF
or
SET ERROR MES OFF
doesn't suppress that message.
Thanks,
Dennis
*****
At 12:44 AM 6/6/2005, you wrote:
Dennis:
Try the following:
SET ERROR MESSAGE 2738 OFF
INSERT INTO vref pr_nbr vn_id vn_unitp vn_ltrns VALUES +
.prnbr, .vnid, .unitp, .trdate
SET ERROR MESSAGE 2738 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]]On 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
Dennis Fleming
IISCO
Phone: 570 775-7593
Mobile: 570 351-5290
