details: /erp/devel/int/rev/0b04dd591f7e changeset: 7094:0b04dd591f7e user: Asier Lostalé <asier.lostale <at> openbravo.com> date: Tue Apr 20 08:59:59 2010 +0200 summary: fixed bug 13041: In new Property configuration windows: editing a row to have selected ='Y' always fails
diffstat:
src-db/database/model/triggers/AD_PROPERTY_CONF_MOD_TRG.xml | 29 ++++--------
1 files changed, 9 insertions(+), 20 deletions(-)
diffs (46 lines):
diff -r e765cd806d02 -r 0b04dd591f7e
src-db/database/model/triggers/AD_PROPERTY_CONF_MOD_TRG.xml
--- a/src-db/database/model/triggers/AD_PROPERTY_CONF_MOD_TRG.xml Tue Apr
20 11:31:17 2010 +0530
+++ b/src-db/database/model/triggers/AD_PROPERTY_CONF_MOD_TRG.xml Tue Apr
20 08:59:59 2010 +0200
@@ -63,16 +63,10 @@
WHERE M.AD_MODULE_ID = cuerrentModuleID;
IF (UPDATING AND devTemplate=0 AND devModule='N') THEN
- IF (COALESCE(:NEW.AD_PROPERTY_CONFIGURATION_ID, '.') !=
COALESCE(:NEW.AD_PROPERTY_CONFIGURATION_ID, '.') OR
- COALESCE(:NEW.AD_CLIENT_ID , '.') !=
COALESCE(:NEW.AD_CLIENT_ID , '.') OR
- COALESCE(:NEW.AD_ORG_ID , '.') !=
COALESCE(:NEW.AD_ORG_ID , '.') OR
- COALESCE(:NEW.ISACTIVE , '.') !=
COALESCE(:NEW.ISACTIVE , '.') OR
- COALESCE(:NEW.CREATED , '.') !=
COALESCE(:NEW.CREATED , '.') OR
- COALESCE(:NEW.CREATEDBY , '.') !=
COALESCE(:NEW.CREATEDBY , '.') OR
- COALESCE(:NEW.UPDATED , '.') !=
COALESCE(:NEW.UPDATED , '.') OR
- COALESCE(:NEW.UPDATEDBY , '.') !=
COALESCE(:NEW.UPDATEDBY , '.') OR
- COALESCE(:NEW.PROPERTY , '.') !=
COALESCE(:NEW.PROPERTY , '.') OR
- COALESCE(:NEW.VALUE , '.') !=
COALESCE(:NEW.VALUE , '.') OR
+ IF (COALESCE(:NEW.AD_CLIENT_ID , '.') !=
COALESCE(:NEW.AD_CLIENT_ID , '.') OR
+ COALESCE(:NEW.AD_ORG_ID , '.') !=
COALESCE(:NEW.AD_ORG_ID , '.') OR
+ COALESCE(:NEW.ISACTIVE , '.') !=
COALESCE(:NEW.ISACTIVE , '.') OR
+ COALESCE(:NEW.PROPERTY , '.') !=
COALESCE(:NEW.PROPERTY , '.') OR
COALESCE(:NEW.AD_MODULE_ID , '.') !=
COALESCE(:NEW.AD_MODULE_ID , '.')) THEN
RAISE_APPLICATION_ERROR(-20532, '@20532@');
END IF;
@@ -85,16 +79,11 @@
--Check the only updated column is "selected". In this case maitin updated
--column as it was to prevent changes detection when trying to update
database
IF (UPDATING) THEN
- IF (COALESCE(:NEW.AD_PROPERTY_CONFIGURATION_ID, '.') =
COALESCE(:NEW.AD_PROPERTY_CONFIGURATION_ID, '.') AND
- COALESCE(:NEW.AD_CLIENT_ID , '.') =
COALESCE(:NEW.AD_CLIENT_ID , '.') AND
- COALESCE(:NEW.AD_ORG_ID , '.') =
COALESCE(:NEW.AD_ORG_ID , '.') AND
- COALESCE(:NEW.ISACTIVE , '.') =
COALESCE(:NEW.ISACTIVE , '.') AND
- COALESCE(:NEW.CREATED , '.') =
COALESCE(:NEW.CREATED , '.') AND
- COALESCE(:NEW.CREATEDBY , '.') =
COALESCE(:NEW.CREATEDBY , '.') AND
- COALESCE(:NEW.UPDATED , '.') =
COALESCE(:NEW.UPDATED , '.') AND
- COALESCE(:NEW.UPDATEDBY , '.') =
COALESCE(:NEW.UPDATEDBY , '.') AND
- COALESCE(:NEW.PROPERTY , '.') =
COALESCE(:NEW.PROPERTY , '.') AND
- COALESCE(:NEW.VALUE , '.') = COALESCE(:NEW.VALUE
, '.') AND
+ IF (COALESCE(:NEW.AD_CLIENT_ID , '.') =
COALESCE(:NEW.AD_CLIENT_ID , '.') AND
+ COALESCE(:NEW.AD_ORG_ID , '.') =
COALESCE(:NEW.AD_ORG_ID , '.') AND
+ COALESCE(:NEW.ISACTIVE , '.') =
COALESCE(:NEW.ISACTIVE , '.') AND
+ COALESCE(:NEW.PROPERTY , '.') =
COALESCE(:NEW.PROPERTY , '.') AND
+ COALESCE(:NEW.VALUE , '.') = COALESCE(:NEW.VALUE
, '.') AND
COALESCE(:NEW.AD_MODULE_ID , '.') =
COALESCE(:NEW.AD_MODULE_ID , '.') AND
:NEW.SELECTED != :OLD.SELECTED) THEN
:NEW.UPDATED := :OLD.UPDATED;
------------------------------------------------------------------------------
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
