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

[..hidden..]

Revision: 3068
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3068&view=rev
Author:   aurynn_cmd
Date:     2010-09-22 23:37:09 +0000 (Wed, 22 Sep 2010)

Log Message:
-----------
Adding the correct menu.sql

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

Modified: addons/1.3/enhanced_tb/trunk/sql/modules/enhanced_tb/menu.sql
===================================================================
--- addons/1.3/enhanced_tb/trunk/sql/modules/enhanced_tb/menu.sql	2010-09-22 23:13:07 UTC (rev 3067)
+++ addons/1.3/enhanced_tb/trunk/sql/modules/enhanced_tb/menu.sql	2010-09-22 23:37:09 UTC (rev 3068)
@@ -51,14 +51,18 @@
         INSERT INTO menu_attribute (node_id, attribute, value)
              VALUES (v_reports_id, 'action', 'reports');
         
-        INSERT INTO menu_attribute (node_id, attribute_value)
+        INSERT INTO menu_attribute (node_id, attribute, value)
              VALUES (v_reports_id, 'module', 'trial_balance.pl');
+             
+        RETURN 1;
         
     END;
 $body$ LANGUAGE PLPGSQL;
 
+SELECT * FROM enhanced_trial_balance_menu (); 
+
 DROP FUNCTION enhanced_trial_balance_menu ();
 
 SELECT 'Commit if 2 records.';
 
-SELECT * FROM menu_attribute WHERE node_id = (SELECT c.id FROM menu_node p, menu_node c WHERE p.id = c.parent AND p.label = 'Trial Balance');
+SELECT ma.* FROM menu_attribute ma, menu_node p, menu_node c WHERE ma.node_id = c.id AND (p.id = c.parent AND p.label = 'Trial Balance') group by ma.id, ma.node_id, ma.attribute, ma.value;
\ No newline at end of file


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