[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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



Revision: 2815
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2815&view=rev
Author:   einhverfr
Date:     2009-12-10 21:45:45 +0000 (Thu, 10 Dec 2009)

Log Message:
-----------
correcting issue with deprecition utility 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	2009-12-10 21:41:33 UTC (rev 2814)
+++ addons/1.3/assets/trunk/sql/modules/Assets.sql	2009-12-10 21:45:45 UTC (rev 2815)
@@ -1,7 +1,7 @@
 CREATE OR REPLACE FUNCTION asset_dep__straight_line_base
 (in_life numeric, in_used numeric, in_basis numeric)
 returns numeric as $$
-SELECT in_life/in_used * basis;
+SELECT $1/$2 * $3;
 $$ language sql;
 
 CREATE OR REPLACE FUNCTION asset_dep__used_months


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