Openbravo开发-开发篇 为字段填加触发器
也在数据库端实现，必须填写正确的前缀。提供软开关（IF AD_isTriggerEnabled()='N），可以停掉或打开所有的触发器
CREATE OR REPLACE FUNCTION ht_salary_trg()
RETURNS TRIGGER AS
$BODY$ DECLARE
DECLARE
v_IsEmployee CHAR(1);
BEGIN
IF AD_isTriggerEnabled()='N' THEN IF TG_OP = 'DELETE' THEN RETURN OLD; ELSE RETURN NEW; END IF;
END IF;
SELECT IsEmployee
INTO v_IsEmployee
FROM C_BPartner
WHERE C_BPartner_ID = NEW.C_BPartner_ID;
IF v_IsEmployee = 'N' THEN
RAISE EXCEPTION '%', 'Partner is not employee';
END IF;
IF TG_OP = 'DELETE' THEN RETURN OLD; ELSE RETURN NEW; END IF;
END;
$BODY$ LANGUAGE plpgsql;
CREATE TRIGGER ht_salary_trg AFTER INSERT OR UPDATE ON ht_salary
FOR EACH ROW EXECUTE PROCEDURE ht_salary_trg();
需要导出数据库
ant export.database
页:
[1]