details: /erp/devel/pi/rev/6b8d9ce301fd changeset: 6464:6b8d9ce301fd user: Asier Lostalé <asier.lostale <at> openbravo.com> date: Fri Feb 19 11:59:53 2010 +0100 summary: fixed issue 12361: change detected for ad_table.isfullyaudited modifications
diffstat:
src-db/database/model/triggers/AD_TABLE_MOD_TRG.xml | 31 ++++++++++++++++++++-
1 files changed, 30 insertions(+), 1 deletions(-)
diffs (48 lines):
diff -r 43b32f4982a1 -r 6b8d9ce301fd
src-db/database/model/triggers/AD_TABLE_MOD_TRG.xml
--- a/src-db/database/model/triggers/AD_TABLE_MOD_TRG.xml Fri Feb 19
10:47:51 2010 +0100
+++ b/src-db/database/model/triggers/AD_TABLE_MOD_TRG.xml Fri Feb 19
11:59:53 2010 +0100
@@ -15,7 +15,7 @@
* under the License.
* The Original Code is Openbravo ERP.
* The Initial Developer of the Original Code is Openbravo SL
-* All portions are Copyright (C) 2008-2009 Openbravo SL
+* All portions are Copyright (C) 2008-2010 Openbravo SL
* All Rights Reserved.
* Contributor(s): ______________________________________.
************************************************************************/
@@ -96,6 +96,35 @@
IF ((DELETING OR INSERTING) AND devModule='N') THEN
RAISE_APPLICATION_ERROR(-20533, 'Cannot insert/delete objects in a module
not in development.');
END IF;
+
+ --Check the only updated column is isFullyAudited. In this case maitin
updated
+ --column as it was to prevent changes detection when trying to update
database
+ IF (UPDATING AND
+ COALESCE(:NEW.ISACTIVE ,'.') = COALESCE(:OLD.ISACTIVE
,'.') AND
+ COALESCE(:NEW.NAME ,'.') = COALESCE(:OLD.NAME
,'.') AND
+ COALESCE(:NEW.DESCRIPTION ,'.') = COALESCE(:OLD.DESCRIPTION
,'.') AND
+ COALESCE(:NEW.HELP ,'.') = COALESCE(:OLD.HELP
,'.') AND
+ COALESCE(:NEW.TABLENAME ,'.') = COALESCE(:OLD.TABLENAME
,'.') AND
+ COALESCE(:NEW.CLASSNAME ,'.') = COALESCE(:OLD.CLASSNAME
,'.') AND
+ COALESCE(:NEW.ISVIEW ,'.') = COALESCE(:OLD.ISVIEW
,'.') AND
+ COALESCE(:NEW.ACCESSLEVEL ,'.') = COALESCE(:OLD.ACCESSLEVEL
,'.') AND
+ COALESCE(:NEW.AD_WINDOW_ID ,'.') = COALESCE(:OLD.AD_WINDOW_ID
,'.') AND
+ COALESCE(:NEW.ISSECURITYENABLED ,'.') =
COALESCE(:OLD.ISSECURITYENABLED ,'.') AND
+ COALESCE(:NEW.ISDELETEABLE ,'.') = COALESCE(:OLD.ISDELETEABLE
,'.') AND
+ COALESCE(:NEW.ISHIGHVOLUME ,'.') = COALESCE(:OLD.ISHIGHVOLUME
,'.') AND
+ COALESCE(:NEW.IMPORTTABLE ,'.') = COALESCE(:OLD.IMPORTTABLE
,'.') AND
+ COALESCE(:NEW.ISCHANGELOG ,'.') = COALESCE(:OLD.ISCHANGELOG
,'.') AND
+ COALESCE(:NEW.PO_WINDOW_ID ,'.') = COALESCE(:OLD.PO_WINDOW_ID
,'.') AND
+ COALESCE(:NEW.ISDEFAULTACCT ,'.') = COALESCE(:OLD.ISDEFAULTACCT
,'.') AND
+ COALESCE(:NEW.SQL_RECORD_IDENTIFIER,'.') =
COALESCE(:OLD.SQL_RECORD_IDENTIFIER,'.') AND
+ COALESCE(:NEW.DEVELOPMENTSTATUS ,'.') =
COALESCE(:OLD.DEVELOPMENTSTATUS ,'.') AND
+ COALESCE(:NEW.AD_PACKAGE_ID ,'.') = COALESCE(:OLD.AD_PACKAGE_ID
,'.') AND
+ COALESCE(:NEW.TREETYPE ,'.') = COALESCE(:OLD.TREETYPE
,'.') AND
+ COALESCE(:NEW.ACCTDATE_COLUMN_ID ,'.') =
COALESCE(:OLD.ACCTDATE_COLUMN_ID ,'.') AND
+ COALESCE(:NEW.ACCTCLASSNAME ,'.') = COALESCE(:OLD.ACCTCLASSNAME
,'.') AND
+ :NEW.ISFULLYAUDITED != :OLD.ISFULLYAUDITED) THEN
+ :NEW.UPDATED := :OLD.UPDATED;
+ END IF;
END AD_TABLE_MOD_TRG
]]></body>
</trigger>
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
