details: https://code.openbravo.com/erp/stable/2.50/rev/839dde1f226a
changeset: 9784:839dde1f226a
user: Javier Etxarri <javier.echarri <at> openbravo.com>
date: Mon Jan 16 18:25:28 2012 +0100
summary: issue 19214: When you change the project status to order the
aplication can fail.
TRUNC(now(),'DD')) return '2012-01-16', so the substring needs to be shorter.
diffstat:
src-db/database/model/functions/C_CHANGEPROJECTSTATUSTOORDER.xml | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diffs (21 lines):
diff -r 2d1d67ef6aa3 -r 839dde1f226a
src-db/database/model/functions/C_CHANGEPROJECTSTATUSTOORDER.xml
--- a/src-db/database/model/functions/C_CHANGEPROJECTSTATUSTOORDER.xml Mon Jan
16 17:41:09 2012 +0100
+++ b/src-db/database/model/functions/C_CHANGEPROJECTSTATUSTOORDER.xml Mon Jan
16 18:25:28 2012 +0100
@@ -205,7 +205,7 @@
(
v_PriceListVersion, v_AD_Client_ID, v_AD_Org_ID, 'Y',
now(), v_AD_User_ID, now(), v_AD_User_ID,
- (SUBSTR(Cur_SO.value || ' - ' ||v_BPName, 0, 55)|| ' - '
||TRUNC(now(), 'DD')),
+ (SUBSTR(Cur_SO.value || ' - ' ||v_BPName, 0, 47)|| ' - '
||TRUNC(now(), 'DD')),
(Cur_SO.value || ' - ' ||v_BPName|| ' - '
||TRUNC(now(), 'DD')),
v_PriceList, v_M_Discountschema_ID,
TRUNC(now(), 'DD')
@@ -305,7 +305,7 @@
(
v_PriceListVersionPO, v_AD_Client_ID, v_AD_Org_ID, 'Y',
now(), v_AD_User_ID, now(), v_AD_User_ID,
- (SUBSTR(Cur_SO.value || ' - ' ||v_SupplierName, 0, 55)|| ' -
' ||TRUNC(now(), 'DD')),
+ (SUBSTR(Cur_SO.value || ' - ' ||v_SupplierName, 0, 47)|| ' -
' ||TRUNC(now(), 'DD')),
(Cur_SO.value || ' - ' ||v_SupplierName||' - '
||TRUNC(now(), 'DD')),
v_PriceListPO, v_M_Discountschema_ID,
TRUNC(now(), 'DD')
------------------------------------------------------------------------------
RSA(R) Conference 2012
Mar 27 - Feb 2
Save $400 by Jan. 27
Register now!
http://p.sf.net/sfu/rsa-sfdev2dev2
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
