SF.net SVN: ledger-smb:[6208] trunk/sql/modules/Business_Unit.sql

[..hidden..]

Revision: 6208
          http://sourceforge.net/p/ledger-smb/code/6208
Author:   tshvr
Date:     2013-10-31 14:12:16 +0000 (Thu, 31 Oct 2013)
Log Message:
-----------
delete should work with OLD values

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

Modified: trunk/sql/modules/Business_Unit.sql
===================================================================
--- trunk/sql/modules/Business_Unit.sql	2013-10-31 13:25:49 UTC (rev 6207)
+++ trunk/sql/modules/Business_Unit.sql	2013-10-31 14:12:16 UTC (rev 6208)
@@ -196,8 +196,8 @@
                 AND credit_id = new.id;
       END IF;
   ELSIF TG_OP = 'DELETE'THEN
-      DELETE FROM business_unit WHERE class_id = 7 - NEW.entity_class
-                  AND credit_id = old_id;
+      DELETE FROM business_unit WHERE class_id = 7 - OLD.entity_class
+                  AND credit_id = OLD.id;
       RETURN OLD;
   END IF;
   RETURN NEW;

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


------------------------------------------------------------------------------
Android is increasing in popularity, but the open development platform that
developers love is also attractive to malware creators. Download this white
paper to learn more about secure code signing practices that can help keep
Android apps secure.
http://pubads.g.doubleclick.net/gampad/clk?id=65839951&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits