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

[..hidden..]

Revision: 1437
          http://svn.sourceforge.net/ledger-smb/?rev=1437&view=rev
Author:   aurynn_cmd
Date:     2007-07-24 13:29:24 -0700 (Tue, 24 Jul 2007)

Log Message:
-----------
Adds the missing SELECT INTO statements for the correct_bank_charge and correct_unaccounted_charge functions

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

Modified: trunk/sql/modules/Reconciliaton.sql
===================================================================
--- trunk/sql/modules/Reconciliaton.sql	2007-07-24 18:18:50 UTC (rev 1436)
+++ trunk/sql/modules/Reconciliaton.sql	2007-07-24 20:29:24 UTC (rev 1437)
@@ -137,6 +137,8 @@
         pending_entry pending_reports;
     BEGIN
     
+        select into pending_entry from pending_reports where report_id = in_report_id and id = in_id;
+    
         IF NOT FOUND THEN
              -- Raise an exception.
              RAISE EXCEPTION "Cannot find entry with ID % in report %.", in_id, in_report_id;
@@ -164,6 +166,8 @@
         note TEXT;
     BEGIN
     
+        select into pending_entry from pending_reports where report_id = in_report_id and id = in_id;
+    
         IF NOT FOUND THEN
              -- Raise an exception.
              RAISE EXCEPTION "Cannot find entry with ID % in report %.", in_id, in_report_id;


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