达梦数据库触发器begin报错

Question

达梦数据库就建立了如下触发器
S0
CREATE
TRIGGER HLHTMD QY ORG BEFORE UPDATE
OF STATE ON
IPSBTQY FOR EACH ROW
WHEN(NEW.STATE = 2)
BEGIN
IF EXISTS (
SELECT*
FROM
MD QY ORG
WHERE
CODE = NEW.CODE)
BEGIN --------报错位置

Answer 1

试试这段脚本

CREATE TRIGGER HLHTMD_QY_ORG_BEFORE_UPDATE_STATE
BEFORE UPDATE OF STATE ON IPSBTQY
REFERENCING NEW AS new
FOR EACH ROW
WHEN (new.STATE = 2)
BEGIN
    IF EXISTS (
        SELECT *
        FROM MD_QY_ORG
        WHERE CODE = new.CODE) THEN
        -- 触发器逻辑
    END IF;
END;