Changes between Version 3 and Version 4 of DodavanjeTransakcija

Timestamp:

12/16/24 22:01:38 (4 weeks ago)

Author:

211101

Comment:

--

DodavanjeTransakcija

@@ -53 +53 @@
 {{{#!sql
 UPDATE transaction_account
-SET balance = balance - 1500 + 200
+SET balance = 
+    CASE 
+        WHEN transaction_account_id = 2 THEN balance - 1500
+        WHEN transaction_account_id = 3 THEN balance + 200
+        ELSE balance
+    END
 WHERE transaction_account_id IN (2, 3);
 }}}