From: <ts...@us...> - 2008-06-28 03:32:49
|
Revision: 5530 http://adempiere.svn.sourceforge.net/adempiere/?rev=5530&view=rev Author: tspc Date: 2008-06-27 20:32:55 -0700 (Fri, 27 Jun 2008) Log Message: ----------- BF2004751 Import Payments - column doesn't exist Modified Paths: -------------- branches/stable/base/src/org/compiere/process/ImportPayment.java Modified: branches/stable/base/src/org/compiere/process/ImportPayment.java =================================================================== --- branches/stable/base/src/org/compiere/process/ImportPayment.java 2008-06-27 22:40:03 UTC (rev 5529) +++ branches/stable/base/src/org/compiere/process/ImportPayment.java 2008-06-28 03:32:55 UTC (rev 5530) @@ -197,7 +197,7 @@ log.info("Set Currency=" + no); // sql = new StringBuffer("UPDATE I_Payment i " - + "SET i.C_Currency_ID=(SELECT C_Currency_ID FROM C_BankAccount WHERE C_BankAccount_ID=i.C_BankAccount_ID) " + + "SET C_Currency_ID=(SELECT C_Currency_ID FROM C_BankAccount WHERE C_BankAccount_ID=i.C_BankAccount_ID) " + "WHERE i.C_Currency_ID IS NULL " + "AND i.ISO_Code IS NULL").append(clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |