details: /erp/devel/pi/rev/57b7573ffd3b
changeset: 12193:57b7573ffd3b
user: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
date: Tue May 17 13:05:46 2011 +0200
summary: Fixed issue 17154.Added trigger on c_invoice to initialize process
invoice column on inserts.
diffstat:
modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_C_INVOICE_TRG.xml
| 31 ++++++++++
1 files changed, 31 insertions(+), 0 deletions(-)
diffs (35 lines):
diff -r a1c0a54ee093 -r 57b7573ffd3b
modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_C_INVOICE_TRG.xml
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++
b/modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_C_INVOICE_TRG.xml
Tue May 17 13:05:46 2011 +0200
@@ -0,0 +1,31 @@
+<?xml version="1.0"?>
+ <database name="TRIGGER APRM_C_INVOICE_TRG">
+ <trigger name="APRM_C_INVOICE_TRG" table="C_INVOICE" fires="before"
insert="true" update="false" delete="false" foreach="row">
+ <body><![CDATA[
+/*************************************************************************
+* The contents of this file are subject to the Openbravo Public License
+* Version 1.1 (the "License"), being the Mozilla Public License
+* Version 1.1 with a permitted attribution clause; you may not use this
+* file except in compliance with the License. You may obtain a copy of
+* the License at http://www.openbravo.com/legal/license.html
+* Software distributed under the License is distributed on an "AS IS"
+* basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
+* License for the specific language governing rights and limitations
+* under the License.
+* The Original Code is Openbravo ERP.
+* The Initial Developer of the Original Code is Openbravo SLU
+* All portions are Copyright (C) 2011 Openbravo SLU
+* All Rights Reserved.
+* Contributor(s): ______________________________________.
+************************************************************************/
+BEGIN
+ IF AD_isTriggerEnabled()='N' THEN RETURN;
+ END IF;
+
+ IF (:NEW.EM_APRM_PROCESSINVOICE IS NULL) THEN
+ :NEW.EM_APRM_PROCESSINVOICE := :NEW.DOCACTION;
+ END IF;
+END APRM_C_INVOICE_TRG
+]]></body>
+ </trigger>
+ </database>
------------------------------------------------------------------------------
Achieve unprecedented app performance and reliability
What every C/C++ and Fortran developer should know.
Learn how Intel has extended the reach of its next-generation tools
to help boost performance applications - inlcuding clusters.
http://p.sf.net/sfu/intel-dev2devmay
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
