[RBG7-L] - Unable to suppress error messages?

[Dennis Fleming]

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