details: https://code.openbravo.com/erp/devel/pi/rev/aae254b2941b
changeset: 20231:aae254b2941b
user: Jon AlegrÃa <jon.alegria <at> openbravo.com>
date: Mon Apr 29 18:10:06 2013 +0200
summary: Fixes issue 0023629: currency order lines does not update its value
regarding
currency order header
diffstat:
src-db/database/model/triggers/C_ORDER_CHK_RESTRINCTIONS_TRG.xml | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r fe9816e90756 -r aae254b2941b
src-db/database/model/triggers/C_ORDER_CHK_RESTRINCTIONS_TRG.xml
--- a/src-db/database/model/triggers/C_ORDER_CHK_RESTRINCTIONS_TRG.xml Mon Apr
29 17:01:03 2013 +0200
+++ b/src-db/database/model/triggers/C_ORDER_CHK_RESTRINCTIONS_TRG.xml Mon Apr
29 18:10:06 2013 +0200
@@ -57,7 +57,7 @@
OR(COALESCE(:OLD.A_ASSET_ID, '0') <> COALESCE(:NEW.A_ASSET_ID, '0'))))
THEN
RAISE_APPLICATION_ERROR(-20000, '@20501@') ;
END IF;
- IF (COALESCE(:OLD.C_BPartner_ID, '0')!=COALESCE(:NEW.C_BPartner_ID, '0'))
OR (COALESCE(:OLD.M_PriceList_ID,'0') != COALESCE(:NEW.M_PriceList_ID,'0'))
THEN
+ IF (COALESCE(:OLD.C_BPartner_ID, '0')!=COALESCE(:NEW.C_BPartner_ID, '0'))
OR (COALESCE(:OLD.M_PriceList_ID,'0') != COALESCE(:NEW.M_PriceList_ID,'0')) OR
(COALESCE(:old.C_Currency_ID, '0') != COALESCE(:NEW.C_Currency_ID, '0')) THEN
SELECT COUNT(*)
INTO v_n
FROM C_ORDERLINE
------------------------------------------------------------------------------
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_apr
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
