diff options
| -rw-r--r-- | sql/modules/Payment.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/modules/Payment.sql b/sql/modules/Payment.sql index 87cca5ca..8f0317e5 100644 --- a/sql/modules/Payment.sql +++ b/sql/modules/Payment.sql @@ -710,11 +710,11 @@ DECLARE 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; |