details: /erp/devel/pi/rev/cbe25f0abf2c
changeset: 6466:cbe25f0abf2c
user: Asier Lostalé <asier.lostale <at> openbravo.com>
date: Fri Feb 19 14:16:19 2010 +0100
summary: fixed erp_devel_pi-full-pgsql - Build # 783
diffstat:
src-db/database/model/triggers/AD_TABLE_MOD_TRG.xml | 5 +++--
1 files changed, 3 insertions(+), 2 deletions(-)
diffs (22 lines):
diff -r e2616479f44e -r cbe25f0abf2c
src-db/database/model/triggers/AD_TABLE_MOD_TRG.xml
--- a/src-db/database/model/triggers/AD_TABLE_MOD_TRG.xml Fri Feb 19
13:45:50 2010 +0100
+++ b/src-db/database/model/triggers/AD_TABLE_MOD_TRG.xml Fri Feb 19
14:16:19 2010 +0100
@@ -99,8 +99,8 @@
--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
+ IF (UPDATING) THEN
+ IF (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
@@ -124,6 +124,7 @@
COALESCE(:NEW.ACCTCLASSNAME ,'.') = COALESCE(:OLD.ACCTCLASSNAME
,'.') AND
:NEW.ISFULLYAUDITED != :OLD.ISFULLYAUDITED) THEN
:NEW.UPDATED := :OLD.UPDATED;
+ END IF;
END IF;
END AD_TABLE_MOD_TRG
]]></body>
------------------------------------------------------------------------------
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
