details: /erp/devel/main/rev/840c40e82c78
changeset: 7934:840c40e82c78
user: David Alsasua <david.alsasua <at> openbravo.com>
date: Tue Jul 20 13:41:49 2010 +0200
summary: Fixes issue 13654
Added coalesce to avoid unwanted document cancellations
diffstat:
src/org/openbravo/erpCommon/ad_forms/DocPayment_data.xsql | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r 8bbb4af47cd2 -r 840c40e82c78
src/org/openbravo/erpCommon/ad_forms/DocPayment_data.xsql
--- a/src/org/openbravo/erpCommon/ad_forms/DocPayment_data.xsql Mon Jul 19
18:25:56 2010 +0200
+++ b/src/org/openbravo/erpCommon/ad_forms/DocPayment_data.xsql Tue Jul 20
13:41:49 2010 +0200
@@ -182,7 +182,7 @@
<SqlMethodComment></SqlMethodComment>
<Sql>
<![CDATA[
- SELECT DP.ISMANUAL, DP.ISDIRECTPOSTING
+ SELECT COALESCE(DP.ISMANUAL,'N') AS ISMANUAL,
COALESCE(DP.ISDIRECTPOSTING,'N') AS ISDIRECTPOSTING
FROM C_SETTLEMENT S LEFT JOIN C_DEBT_PAYMENT DP
ON DP.C_SETTLEMENT_GENERATE_ID = S.C_SETTLEMENT_ID
WHERE S.C_SETTLEMENT_ID = ?
------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
