details: /erp/devel/pi/rev/0b19faf71019 changeset: 9330:0b19faf71019 user: Asier Lostalé <asier.lostale <at> openbravo.com> date: Thu Dec 23 13:16:54 2010 +0100 summary: related to issue 13687: Do not set to null sequence field when it is not shown
diffstat: src-db/database/model/triggers/AD_FIELD_TRG2.xml | 34 ----------------- src-wad/src/org/openbravo/wad/datasourceSortTab.xsqlxml | 4 +- 2 files changed, 2 insertions(+), 36 deletions(-) diffs (59 lines): diff -r 7dde21c182e6 -r 0b19faf71019 src-db/database/model/triggers/AD_FIELD_TRG2.xml --- a/src-db/database/model/triggers/AD_FIELD_TRG2.xml Thu Dec 23 12:42:02 2010 +0100 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,34 +0,0 @@ -<?xml version="1.0"?> - <database name="TRIGGER AD_FIELD_TRG2"> - <trigger name="AD_FIELD_TRG2" table="AD_FIELD" fires="before" insert="false" update="true" 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) 2010 Openbravo SLU - * All Rights Reserved. - * Contributor(s): ______________________________________. - ************************************************************************/ - -BEGIN - - IF AD_isTriggerEnabled()='N' THEN RETURN; - END IF; - - IF (:old.IsDisplayed='Y' and :new.IsDisplayed='N') THEN - :new.seqNo := null; - END IF; - -END AD_FIELD_TRG2 -]]></body> - </trigger> - </database> diff -r 7dde21c182e6 -r 0b19faf71019 src-wad/src/org/openbravo/wad/datasourceSortTab.xsqlxml --- a/src-wad/src/org/openbravo/wad/datasourceSortTab.xsqlxml Thu Dec 23 12:42:02 2010 +0100 +++ b/src-wad/src/org/openbravo/wad/datasourceSortTab.xsqlxml Thu Dec 23 13:16:54 2010 +0100 @@ -12,7 +12,7 @@ * 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 portions are Copyright (C) 2001-2010 Openbravo SLU * All Rights Reserved. * Contributor(s): ______________________________________. ************************************************************************ @@ -131,7 +131,7 @@ <SqlMethod name="updateN" type="preparedStatement" connection="true" return="rowCount" static="false"> <Sql><![CDATA[ UPDATE <PARAMETER_TMP id="table">table</PARAMETER_TMP> - SET <FIELD_TMP id="SortConditionField">fieldSort</FIELD_TMP>='N', <FIELD_TMP id="SortField">column_a</FIELD_TMP> = NULL, + SET <FIELD_TMP id="SortConditionField">fieldSort</FIELD_TMP>='N', updated = now(), updatedby = ? WHERE 1=1 <PARAMETER_TMP id="parent"> AND <PARAMETER_TMP id="keyParent">xx</PARAMETER_TMP> = ? </PARAMETER_TMP> ]]></Sql> ------------------------------------------------------------------------------ Learn how Oracle Real Application Clusters (RAC) One Node allows customers to consolidate database storage, standardize their database environment, and, should the need arise, upgrade to a full multi-node Oracle RAC database without downtime or disruption http://p.sf.net/sfu/oracle-sfdevnl _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
