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

[..hidden..]

Revision: 2537
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2537&view=rev
Author:   einhverfr
Date:     2009-03-26 16:16:58 +0000 (Thu, 26 Mar 2009)

Log Message:
-----------
More recon matching fixes

Modified Paths:
--------------
    trunk/sql/modules/Reconciliation.sql
    trunk/sql/modules/test/Reconciliation.sql

Modified: trunk/sql/modules/Reconciliation.sql
===================================================================
--- trunk/sql/modules/Reconciliation.sql	2009-03-26 15:51:44 UTC (rev 2536)
+++ trunk/sql/modules/Reconciliation.sql	2009-03-26 16:16:58 UTC (rev 2537)
@@ -297,7 +297,8 @@
 		ELSE -- more than one match
 			SELECT min(id) INTO lid FROM cr_report_line
 			WHERE report_id = in_report_id AND our_balance = in_amount
-                        	AND their_balance = 0 and post_date = in_date;
+                        	AND their_balance = 0 and post_date = in_date
+			LIMIT 1;
 
 			UPDATE cr_report_line SET their_balance = in_amount,
 					trans_type = in_type,

Modified: trunk/sql/modules/test/Reconciliation.sql
===================================================================
--- trunk/sql/modules/test/Reconciliation.sql	2009-03-26 15:51:44 UTC (rev 2536)
+++ trunk/sql/modules/test/Reconciliation.sql	2009-03-26 16:16:58 UTC (rev 2537)
@@ -110,8 +110,6 @@
 INSERT INTO test_result(test_name, success)
 SELECT 'Cleared balance post-approval is 130', reconciliation__get_cleared_balance(-201) = 130;
 
-
-
 SELECT * FROM test_result;
 
 SELECT (select count(*) from test_result where success is true) 


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