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

[..hidden..]

Revision: 2465
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2465&view=rev
Author:   einhverfr
Date:     2009-02-27 00:29:53 +0000 (Fri, 27 Feb 2009)

Log Message:
-----------
Changing sorting on recon report to go by source first, then date

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

Modified: trunk/sql/modules/Reconciliaton.sql
===================================================================
--- trunk/sql/modules/Reconciliaton.sql	2009-02-26 18:55:01 UTC (rev 2464)
+++ trunk/sql/modules/Reconciliaton.sql	2009-02-27 00:29:53 UTC (rev 2465)
@@ -283,7 +283,7 @@
     BEGIN    
         FOR row IN 
 		select * from cr_report_line where report_id = in_report_id 
-		order by post_date
+		order by scn, post_date
 	LOOP
         
             RETURN NEXT row;


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