details: https://code.openbravo.com/erp/devel/pi/rev/291741e7259e
changeset: 20460:291741e7259e
user: Ioritz Cia <ioritz.cia <at> openbravo.com>
date: Wed May 22 17:22:04 2013 +0200
summary: Fixes issue 23815: When updating a subaccount the system is
activating
all the valid combinations associated.
diffstat:
src-db/database/model/triggers/C_ELEMENTVALUE_TRG.xml | 5 ++++-
1 files changed, 4 insertions(+), 1 deletions(-)
diffs (15 lines):
diff -r eac5354af6e4 -r 291741e7259e
src-db/database/model/triggers/C_ELEMENTVALUE_TRG.xml
--- a/src-db/database/model/triggers/C_ELEMENTVALUE_TRG.xml Thu May 23
15:15:41 2013 +0530
+++ b/src-db/database/model/triggers/C_ELEMENTVALUE_TRG.xml Wed May 22
17:22:04 2013 +0200
@@ -159,7 +159,10 @@
if(v_Count>0) THEN
UPDATE C_ValidCombination
SET Updated=now(), isactive = 'Y'
- WHERE Account_ID=:new.C_ElementValue_ID;
+ WHERE Account_ID=:new.C_ElementValue_ID
+ AND C_AcctSchema_ID in (SELECT C_AcctSchema_ID
+ FROM C_AcctSchema
+ WHERE isactive = 'Y');
ELSE
FOR cur_AcctSchema IN
(SELECT C_AcctSchema_ID
------------------------------------------------------------------------------
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_may
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
