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

[..hidden..]

Revision: 2443
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2443&view=rev
Author:   einhverfr
Date:     2009-02-04 18:46:39 +0000 (Wed, 04 Feb 2009)

Log Message:
-----------
Correcting reconciliation module loading issue.

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

Modified: trunk/sql/modules/Reconciliaton.sql
===================================================================
--- trunk/sql/modules/Reconciliaton.sql	2009-02-04 17:39:38 UTC (rev 2442)
+++ trunk/sql/modules/Reconciliaton.sql	2009-02-04 18:46:39 UTC (rev 2443)
@@ -347,7 +347,7 @@
 				ORDER BY id ASC limit 1;
 
 				UPDATE cr_report_line
-                                SET their_balance = in_amount
+                                SET their_balance = in_amount,
 					clear_time = in_date
                                 WHERE id = lid;
 				
@@ -364,7 +364,7 @@
 			VALUES 
 			(in_report_id, t_scn, in_amount, 0, in_date);
 		ELSIF in_count = 1 THEN -- perfect match
-			UPDATE cr_report_line SET their_balance = in_amount
+			UPDATE cr_report_line SET their_balance = in_amount,
 					clear_time = in_date
 			WHERE report_id = in_report_id AND amount = in_amount
                         	AND their_balance = 0;
@@ -373,7 +373,7 @@
 			WHERE report_id = in_report_id AND amount = in_amount
                         	AND their_balance = 0;
 
-			UPDATE cr_report_line SET their_balance = in_amount
+			UPDATE cr_report_line SET their_balance = in_amount,
 					clear_time = in_date
 			WHERE id = lid;
 			


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