details:   /erp/devel/pi/rev/af85d0df177c
changeset: 12074:af85d0df177c
user:      Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
date:      Tue May 10 10:08:35 2011 +0200
summary:   Fixes bug 17076: G/L Item. When a tax is defined as default

diffstat:

 src-db/database/model/triggers/C_GLITEM_TRG.xml |  34 +++++++++++++++++++++++++
 1 files changed, 34 insertions(+), 0 deletions(-)

diffs (38 lines):

diff -r d5af22c77778 -r af85d0df177c 
src-db/database/model/triggers/C_GLITEM_TRG.xml
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/src-db/database/model/triggers/C_GLITEM_TRG.xml   Tue May 10 10:08:35 
2011 +0200
@@ -0,0 +1,34 @@
+<?xml version="1.0"?>
+  <database name="TRIGGER C_GLITEM_TRG">
+    <trigger name="C_GLITEM_TRG" table="C_GLITEM" 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) 2001-2009 Openbravo SLU
+    * All Rights Reserved.
+    * Contributor(s):  ______________________________________.
+    ************************************************************************/
+        
+BEGIN
+    
+    IF AD_isTriggerEnabled()='N' THEN RETURN;
+    END IF;
+
+    IF INSERTING THEN
+     :NEW.C_TAX_ID := NULL;
+    END IF;
+
+END C_GLITEM_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

Reply via email to