ï^9~˪{÷¿8ß¹ã_5÷OtÓ<?xml version="1.0"?>
<database name="TRIGGER ACCDEF_INVOICE_TRG">
<trigger name="ACCDEF_INVOICE_TRG" table="C_INVOICE" fires="before" insert="false" update="true" delete="true" foreach="row">
<body><![CDATA[
BEGIN
IF AD_isTriggerEnabled()='N' THEN RETURN;
END IF;
IF UPDATING THEN
IF(:OLD.DOCSTATUS='CO' AND (:OLD.EM_ACCDEF_TYPE IS NULL AND :NEW.EM_ACCDEF_TYPE IS NOT NULL) OR (:OLD.EM_ACCDEF_TYPE IS NOT NULL AND :NEW.EM_ACCDEF_TYPE IS NULL
)
) THEN
RAISE_APPLICATION_ERROR(-20501, 'Document processed/posted');
END IF;
END IF;
IF(DELETING) THEN
IF(:OLD.DOCSTATUS='CO') THEN
RAISE_APPLICATION_ERROR(-20501, 'Document processed/posted');
END IF;
END IF;
END ACCDEF_INVOICE_TRG
]]></body>
</trigger>
</database>------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
Openbravo-development mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-development
