details: https://code.openbravo.com/erp/devel/pi/rev/e7005c8d49f3
changeset: 17794:e7005c8d49f3
user: David Miguelez <david.miguelez <at> openbravo.com>
date: Wed Aug 29 09:51:31 2012 +0200
summary: Related to Issue 21390: Fixes length of variable.
diffstat:
src-db/database/model/triggers/M_INOUTLINE_TRG.xml | 6 +++---
1 files changed, 3 insertions(+), 3 deletions(-)
diffs (26 lines):
diff -r 0f98157d9e2b -r e7005c8d49f3
src-db/database/model/triggers/M_INOUTLINE_TRG.xml
--- a/src-db/database/model/triggers/M_INOUTLINE_TRG.xml Wed Aug 29
09:11:25 2012 +0200
+++ b/src-db/database/model/triggers/M_INOUTLINE_TRG.xml Wed Aug 29
09:51:31 2012 +0200
@@ -21,7 +21,7 @@
v_ISSOTRX CHAR(1);
v_QTYVARIABLE CHAR(1);
v_OrderProduct VARCHAR2(32);
- v_IsUpdateAndNewIsDifferentProduct BOOLEAN;
+ v_IsUpdateDifferentProduct BOOLEAN;
/******************************************************************************
* The contents of this file are subject to the Compiere License Version 1.1
* ("License"); You may not use this file except in compliance with the License
@@ -167,11 +167,11 @@
END IF;
IF (UPDATING) THEN
- v_IsUpdateAndNewIsDifferentProduct = COALESCE(:OLD.m_product_id, '0') <>
COALESCE(:NEW.m_product_id, '0');
+ v_IsUpdateDifferentProduct := COALESCE(:OLD.m_product_id, '0') <>
COALESCE(:NEW.m_product_id, '0');
END IF;
-- Do not allow different product than the one in the related orderline.
- IF (INSERTING OR v_IsUpdateAndNewIsDifferentProduct) THEN
+ IF (INSERTING OR v_IsUpdateDifferentProduct) THEN
IF (:new.C_OrderLine_ID is not null) THEN
SELECT m_product_id INTO v_OrderProduct FROM C_OrderLine WHERE
C_OrderLine_ID = :new.C_OrderLine_ID;
IF (v_OrderProduct <> :new.M_Product_ID) THEN
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
