SF.net SVN: ledger-smb:[4917] addons/1.3/enhanced_tb/trunk/sql/modules/ enhanced_tb/menu2.sql

[..hidden..]

Revision: 4917
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4917&view=rev
Author:   einhverfr
Date:     2012-06-18 14:20:36 +0000 (Mon, 18 Jun 2012)
Log Message:
-----------
Correcting ehanced_tb menu 2

Modified Paths:
--------------
    addons/1.3/enhanced_tb/trunk/sql/modules/enhanced_tb/menu2.sql

Modified: addons/1.3/enhanced_tb/trunk/sql/modules/enhanced_tb/menu2.sql
===================================================================
--- addons/1.3/enhanced_tb/trunk/sql/modules/enhanced_tb/menu2.sql	2012-06-18 13:52:40 UTC (rev 4916)
+++ addons/1.3/enhanced_tb/trunk/sql/modules/enhanced_tb/menu2.sql	2012-06-18 14:20:36 UTC (rev 4917)
@@ -12,11 +12,9 @@
         v_reports_id int;
     BEGIN
     
-        SELECT max(id) + 1 
-          INTO v_tb_node 
-          FROM menu_node;
-       
-        DELETE FROM menu_attribute WHERE node_id = v_tb_node;
+        SELECT menu_insert(109, 9, 'Trial  Balance') 
+          INTO v_tb_node; 
+
         INSERT INTO menu_attribute (node_id, attribute, value ) 
              VALUES (v_tb_node, 'menu', 1)
              RETURNING id INTO v_tb_attr_node;

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