SF.net SVN: ledger-smb:[2937] addons/1.3/assets/trunk/sql/modules/Assets. sql

[..hidden..]

Revision: 2937
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2937&view=rev
Author:   einhverfr
Date:     2010-03-01 19:57:34 +0000 (Mon, 01 Mar 2010)

Log Message:
-----------
Corrected syntax error in function

Modified Paths:
--------------
    addons/1.3/assets/trunk/sql/modules/Assets.sql

Modified: addons/1.3/assets/trunk/sql/modules/Assets.sql
===================================================================
--- addons/1.3/assets/trunk/sql/modules/Assets.sql	2010-03-01 19:23:51 UTC (rev 2936)
+++ addons/1.3/assets/trunk/sql/modules/Assets.sql	2010-03-01 19:57:34 UTC (rev 2937)
@@ -73,7 +73,7 @@
 
     select true;
 $$ language sql;
-
+/*
 CREATE OR REPLACE FUNCTION asset_dep_straight_line_yr_d
 (in_asset_ids int[],  in_report_date date, in_report_id int)
 RETURNS bool AS
@@ -155,6 +155,7 @@
 
     select true;
 $$ language sql;
+*/
 
 CREATE OR REPLACE FUNCTION asset_report__generate_gl(in_report_id int, in_accum_account_id int)
 RETURNS INT AS
@@ -185,7 +186,7 @@
 	GROUP BY gl.id, r.report_date, a.exp_account_id;
 
 	INSERT INTO acc_trans (trans_id, chart_id, transdate, approved, amount)
-	SELECT gl.id, a.dep_account_id, r.report_date, true, sum(amount),
+	SELECT gl.id, a.dep_account_id, r.report_date, true, sum(amount)
 	FROM asset_report r
 	JOIN asset_report_line l ON (r.id = l.report_id)
 	JOIN asset_item a ON (l.asset_id = a.id)
@@ -502,7 +503,7 @@
 	RETURN ret_val;
 end;
 $$ language plpgsql;
-revoke execute on function asset_report__approve(int) from public;
+revoke execute on function asset_report__approve(int, int) from public;
 
 
 CREATE OR REPLACE FUNCTION asset_item__add_note(in_id int, in_subject text, in_note text)


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