details: https://code.openbravo.com/erp/devel/pi/rev/5ccb08d7767d
changeset: 22342:5ccb08d7767d
user: Atul Gaware <atul.gaware <at> openbravo.com>
date: Tue Mar 04 20:56:47 2014 +0530
summary: Related to Issue 24866: value='Y' replaced by to_char('Y') in xsql
diffstat:
modules/org.openbravo.advpaymentmngt/build/classes/org/openbravo/advpaymentmngt/modulescript/UpdateCustomerBalanceData.class
| 0
modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/org/openbravo/advpaymentmngt/modulescript/UpdateCustomerBalance_data.xsql
| 4 ++--
modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/src/org/openbravo/advpaymentmngt/modulescript/UpdateCustomerBalanceData.java
| 4 ++--
3 files changed, 4 insertions(+), 4 deletions(-)
diffs (44 lines):
diff -r e878aac6159c -r 5ccb08d7767d
modules/org.openbravo.advpaymentmngt/build/classes/org/openbravo/advpaymentmngt/modulescript/UpdateCustomerBalanceData.class
Binary file
modules/org.openbravo.advpaymentmngt/build/classes/org/openbravo/advpaymentmngt/modulescript/UpdateCustomerBalanceData.class
has changed
diff -r e878aac6159c -r 5ccb08d7767d
modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/org/openbravo/advpaymentmngt/modulescript/UpdateCustomerBalance_data.xsql
---
a/modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/org/openbravo/advpaymentmngt/modulescript/UpdateCustomerBalance_data.xsql
Tue Mar 04 13:50:41 2014 +0100
+++
b/modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/org/openbravo/advpaymentmngt/modulescript/UpdateCustomerBalance_data.xsql
Tue Mar 04 20:56:47 2014 +0530
@@ -33,7 +33,7 @@
<![CDATA[
SELECT count(*) as existpreference
FROM ad_preference
- WHERE attribute = 'IsCustomerBalanceRestored' AND value='Y'
+ WHERE attribute = 'IsCustomerBalanceRestored' AND to_char(value)='Y'
]]>
</Sql>
</SqlMethod>
@@ -42,7 +42,7 @@
<Sql>
<![CDATA[
DELETE FROM ad_preference
- WHERE attribute = 'IsCustomerBalanceRestored' AND value='Y'
+ WHERE attribute = 'IsCustomerBalanceRestored' AND to_char(value)='Y'
]]>
</Sql>
</SqlMethod>
diff -r e878aac6159c -r 5ccb08d7767d
modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/src/org/openbravo/advpaymentmngt/modulescript/UpdateCustomerBalanceData.java
---
a/modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/src/org/openbravo/advpaymentmngt/modulescript/UpdateCustomerBalanceData.java
Tue Mar 04 13:50:41 2014 +0100
+++
b/modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/src/org/openbravo/advpaymentmngt/modulescript/UpdateCustomerBalanceData.java
Tue Mar 04 20:56:47 2014 +0530
@@ -131,7 +131,7 @@
strSql = strSql +
" SELECT count(*) as existpreference" +
" FROM ad_preference" +
- " WHERE attribute = 'IsCustomerBalanceRestored' AND value='Y'
";
+ " WHERE attribute = 'IsCustomerBalanceRestored' AND
to_char(value)='Y' ";
ResultSet result;
boolean boolReturn = false;
@@ -165,7 +165,7 @@
String strSql = "";
strSql = strSql +
" DELETE FROM ad_preference" +
- " WHERE attribute = 'IsCustomerBalanceRestored' AND value='Y'
";
+ " WHERE attribute = 'IsCustomerBalanceRestored' AND
to_char(value)='Y' ";
int updateCount = 0;
PreparedStatement st = null;
------------------------------------------------------------------------------
Subversion Kills Productivity. Get off Subversion & Make the Move to Perforce.
With Perforce, you get hassle-free workflows. Merge that actually works.
Faster operations. Version large binaries. Built-in WAN optimization and the
freedom to use Git, Perforce or both. Make the move to Perforce.
http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
