达梦表级触发器

 

// 达梦触发器


CREATE  OR REPLACE TRIGGER "K_BASIC"."B_BASE_ENGINEERING_CATEGORY TO B_PROJECT_INVESTMENT"
AFTER UPDATE OR INSERT
ON "K_BASIC"."B_BASE_ENGINEERING_CATEGORY"
REFERENCING OLD ROW AS "OLD" NEW ROW AS "NEW"
FOR EACH ROW
BEGIN
        UPDATE
        "K_BASIC"."B_PROJECT_INVESTMENT"
        SET
        CLASSIFY_CODE = NEW."CODE_NUM"
        WHERE
        ENGINEERING_CLASSIFY_ID = NEW."ID";
END;