SF.net SVN: ledger-smb:[2610] trunk/sql/modules/Payment.sql

[..hidden..]

Revision: 2610
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2610&view=rev
Author:   einhverfr
Date:     2009-05-21 21:10:18 +0000 (Thu, 21 May 2009)

Log Message:
-----------
Correcting payment function issues

Modified Paths:
--------------
    trunk/sql/modules/Payment.sql

Modified: trunk/sql/modules/Payment.sql
===================================================================
--- trunk/sql/modules/Payment.sql	2009-05-21 20:55:32 UTC (rev 2609)
+++ trunk/sql/modules/Payment.sql	2009-05-21 21:10:18 UTC (rev 2610)
@@ -493,7 +493,7 @@
 			ELSE false END,
 		$E$ || t_voucher_id || $E$, $E$|| quote_literal(in_payment_date) 
 		||$E$ , $E$ ||COALESCE(quote_literal(in_source), 'NULL') || 
-		$E$ , $E$ || quote_literal(in_payment_class) || $E$
+		$E$ , $E$ || coalesce(quote_literal(in_payment_type), 'NULL') || $E$
 		FROM bulk_payments_in $E$;
 
 	EXECUTE $E$ 
@@ -512,7 +512,7 @@
 			ELSE false END,
 		$E$ || t_voucher_id || $E$, $E$|| quote_literal(in_payment_date) 
 		||$E$ , $E$ ||COALESCE(quote_literal(in_source), 'null') 
-		||$E$ , $E$ || quote_literal(in_payment_class) || $E$ 
+		||$E$ , $E$ || coalesce(quote_literal(in_payment_type), 'NULL') || $E$ 
 		FROM bulk_payments_in $E$;
 
 	EXECUTE $E$


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.