fixed bug 21601 Change validation with null values in order to work in oracle
authorNaiara Martinez <naiara.martinez@openbravo.com>
Mon, 10 Sep 2012 17:55:14 +0200
changeset 17945 113cc988cb72
parent 17944 20032d5f55d3
child 17946 ba1f0e76db04
fixed bug 21601 Change validation with null values in order to work in oracle
src-db/database/model/functions/C_CHANGEPROJECTSTATUSTOORDER.xml
--- a/src-db/database/model/functions/C_CHANGEPROJECTSTATUSTOORDER.xml	Tue Sep 11 12:25:54 2012 +0200
+++ b/src-db/database/model/functions/C_CHANGEPROJECTSTATUSTOORDER.xml	Mon Sep 10 17:55:14 2012 +0200
@@ -120,7 +120,7 @@
             RAISE_APPLICATION_ERROR(-20000, '@ProjectSalesRepNotFound@');
           END IF;
           /*Added in order to work with Multiphase Project*/
-          IF Cur_SO.PROJECTCATEGORY<>'S' THEN
+          IF (Cur_SO.PROJECTCATEGORY is null OR Cur_SO.PROJECTCATEGORY<>'S') THEN
             SELECT COUNT(*)
             INTO v_TotalLines
             FROM C_PROJECTLINE