SF.net SVN: ledger-smb:[2623] trunk/sql/modules/TaxForm.sql

[..hidden..]

Revision: 2623
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2623&view=rev
Author:   einhverfr
Date:     2009-06-04 16:57:30 +0000 (Thu, 04 Jun 2009)

Log Message:
-----------
Adding TaxForm.sql

Added Paths:
-----------
    trunk/sql/modules/TaxForm.sql

Added: trunk/sql/modules/TaxForm.sql
===================================================================
--- trunk/sql/modules/TaxForm.sql	                        (rev 0)
+++ trunk/sql/modules/TaxForm.sql	2009-06-04 16:57:30 UTC (rev 2623)
@@ -0,0 +1,10 @@
+CREATE OR REPLACE FUNCTION tax_form__save(in_country_id int, in_form_name text)
+RETURNS int AS
+$$
+BEGIN
+	insert into country_tax_form(country_id,form_name) 
+	values (in_country_id, in_form_name);
+
+	RETURN currval('country_tax_form_id_seq');
+END;
+$$ LANGUAGE PLPGSQL;


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