details: https://code.openbravo.com/erp/stable/2.50/rev/56a1306e07a0
changeset: 9909:56a1306e07a0
user: Ioritz Cia <ioritz.cia <at> openbravo.com>
date: Thu Jan 24 13:16:12 2013 +0100
summary: Fixes issue 22669: Value too long in m_generate_average_costs.
diffstat:
src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml | 30 ++++++++++--
1 files changed, 25 insertions(+), 5 deletions(-)
diffs (68 lines):
diff -r ee6b62b166d7 -r 56a1306e07a0
src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml
--- a/src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml Wed Jan
02 10:14:19 2013 +0100
+++ b/src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml Thu Jan
24 13:16:12 2013 +0100
@@ -164,7 +164,11 @@
ELSE
v_CheckResultStr := v_CheckResultStr || ', ';
END IF;
- v_CheckResultStr := v_CheckResultStr || Cur_Docs.DOCUMENTNO;
+ IF (COALESCE(LENGTH(v_CheckResultStr),0) > 1900) THEN
+ v_CheckResultStr:=SUBSTR(v_CheckResultStr,1,1900) || '(...)';
+ ELSE
+ v_CheckResultStr := v_CheckResultStr || Cur_Docs.DOCUMENTNO;
+ END IF;
END LOOP;
v_CheckResultStr:=v_CheckResultStr || '.';
END IF;
@@ -189,7 +193,11 @@
ELSE
v_CheckResultStr := v_CheckResultStr || ', ';
END IF;
- v_CheckResultStr := v_CheckResultStr || Cur_Docs.INVENTORY ||
'(@Warehouse@ ' || Cur_Docs.WAREHOUSE || ')';
+ IF (COALESCE(LENGTH(v_CheckResultStr),0) > 1900) THEN
+ v_CheckResultStr:=SUBSTR(v_CheckResultStr,1,1900) || '(...)';
+ ELSE
+ v_CheckResultStr := v_CheckResultStr || Cur_Docs.INVENTORY ||
'(@Warehouse@ ' || Cur_Docs.WAREHOUSE || ')';
+ END IF;
END LOOP;
v_CheckResultStr:=v_CheckResultStr || '.';
END IF;
@@ -213,7 +221,11 @@
ELSE
v_CheckResultStr := v_CheckResultStr || ', ';
END IF;
- v_CheckResultStr := v_CheckResultStr || Cur_Docs.DOCUMENTNO;
+ IF (COALESCE(LENGTH(v_CheckResultStr),0) > 1900) THEN
+ v_CheckResultStr:=SUBSTR(v_CheckResultStr,1,1900) || '(...)';
+ ELSE
+ v_CheckResultStr := v_CheckResultStr || Cur_Docs.DOCUMENTNO;
+ END IF;
END LOOP;
v_CheckResultStr:=v_CheckResultStr || '.';
END IF;
@@ -238,7 +250,11 @@
ELSE
v_CheckResultStr := v_CheckResultStr || ', ';
END IF;
- v_CheckResultStr := v_CheckResultStr || Cur_Docs.DOCUMENTNO;
+ IF (COALESCE(LENGTH(v_CheckResultStr),0) > 1900) THEN
+ v_CheckResultStr:=SUBSTR(v_CheckResultStr,1,1900) || '(...)';
+ ELSE
+ v_CheckResultStr := v_CheckResultStr || Cur_Docs.DOCUMENTNO;
+ END IF;
END LOOP;
v_CheckResultStr:=v_CheckResultStr || '.';
END IF;
@@ -267,7 +283,11 @@
ELSE
v_CheckResultStr := v_CheckResultStr || ', ';
END IF;
- v_CheckResultStr := v_CheckResultStr || Cur_Docs.DATEINVOICED || ' ('
|| '@Invoice@ @SOS_DOCUMENTNO@' || Cur_Docs.DOCUMENTNO || ')';
+ IF (COALESCE(LENGTH(v_CheckResultStr),0) > 1900) THEN
+ v_CheckResultStr:=SUBSTR(v_CheckResultStr,1,1900) || '(...)';
+ ELSE
+ v_CheckResultStr := v_CheckResultStr || Cur_Docs.DATEINVOICED || '
(' || '@Invoice@ @SOS_DOCUMENTNO@' || Cur_Docs.DOCUMENTNO || ')';
+ END IF;
END LOOP;
v_CheckResultStr:=v_CheckResultStr || '.';
END IF;
------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnnow-d2d
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
