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

[..hidden..]

Revision: 2199
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2199&view=rev
Author:   einhverfr
Date:     2008-07-09 07:47:33 -0700 (Wed, 09 Jul 2008)

Log Message:
-----------
Correctig bug in exchangerate function

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

Modified: trunk/sql/modules/Payment.sql
===================================================================
--- trunk/sql/modules/Payment.sql	2008-07-08 20:12:26 UTC (rev 2198)
+++ trunk/sql/modules/Payment.sql	2008-07-09 14:47:33 UTC (rev 2199)
@@ -710,11 +710,11 @@
 
     BEGIN 
         IF in_account_class = 1 THEN
-          SELECT INTO out_exrate buy 
+          SELECT buy INTO out_exrate 
           FROM exchangerate
           WHERE transdate = in_date AND curr = in_currency;
         ELSE 
-          SELECT INTO out_exrate sell 
+          SELECT sell INTO out_exrate 
           FROM exchangerate
           WHERE transdate = in_date AND curr = in_currency;   
         END IF;


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