details: https://code.openbravo.com/erp/devel/pi/rev/d9e211f5e8bf
changeset: 19780:d9e211f5e8bf
user: Javier Etxarri <javier.echarri <at> openbravo.com>
date: Thu Feb 21 18:25:34 2013 +0100
summary: issue 22508 and fixes in-full-oracle 4546
diffstat:
src-db/database/model/triggers/M_INOUT_TRG_PROV.xml | 10 +++++-----
1 files changed, 5 insertions(+), 5 deletions(-)
diffs (26 lines):
diff -r 7bd5f6e3424a -r d9e211f5e8bf
src-db/database/model/triggers/M_INOUT_TRG_PROV.xml
--- a/src-db/database/model/triggers/M_INOUT_TRG_PROV.xml Thu Feb 21
17:47:33 2013 +0100
+++ b/src-db/database/model/triggers/M_INOUT_TRG_PROV.xml Thu Feb 21
18:25:34 2013 +0100
@@ -62,17 +62,17 @@
END IF;
- IF (:old.c_order_id is not null) THEN
- SELECT count(*)
- INTO v_count
+ If (:Old.C_Order_Id Is Not Null) Then
+ SELECT count(*)
+ Into V_Count
FROM c_orderline col
WHERE col.c_order_id = :old.c_order_id
AND col.c_orderline_id IN (
SELECT c_orderline_id
FROM m_inoutline
WHERE m_inout_id = :old.m_inout_id);
- IF (v_count = 0) THEN
- :new.c_order_id = null;
+ If (V_Count = 0) Then
+ :new.c_order_id := null;
END IF;
END IF;
END IF;
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
