SF.net SVN: ledger-smb:[6858] trunk/sql/modules/Company.sql

[..hidden..]

Revision: 6858
          http://sourceforge.net/p/ledger-smb/code/6858
Author:   tshvr
Date:     2014-02-14 15:19:29 +0000 (Fri, 14 Feb 2014)
Log Message:
-----------
unused variables;use  t_control_code further on

Modified Paths:
--------------
    trunk/sql/modules/Company.sql

Modified: trunk/sql/modules/Company.sql
===================================================================
--- trunk/sql/modules/Company.sql	2014-02-13 20:02:06 UTC (rev 6857)
+++ trunk/sql/modules/Company.sql	2014-02-14 15:19:29 UTC (rev 6858)
@@ -708,7 +708,7 @@
     in_entity_id int, in_sic_code text,in_country_id int,
     in_sales_tax_id text, in_license_number text
 );
-
+--TODO 1.5 in_id not used in function,drop it
 CREATE OR REPLACE FUNCTION company__save (
     in_id int, in_control_code text, in_entity_class int,
     in_legal_name text, in_tax_id TEXT,
@@ -716,11 +716,11 @@
     in_sales_tax_id text, in_license_number text
 ) RETURNS company AS $$
 DECLARE t_entity_id INT;
-	t_company_id INT;
+	--t_company_id INT;--not used
 	t_control_code TEXT;
         t_retval COMPANY;
 BEGIN
-	t_company_id := in_id;
+	--t_company_id := in_id;--not used
 
 	IF in_control_code IS NULL THEN
 		t_control_code := setting_increment('company_control');
@@ -731,7 +731,7 @@
 	UPDATE entity 
 	SET name = in_legal_name, 
 		entity_class = in_entity_class,
-		control_code = in_control_code,
+		control_code = t_control_code,
                 country_id   = in_country_id
 	WHERE id = in_entity_id;
 

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


------------------------------------------------------------------------------
Android apps run on BlackBerry 10
Introducing the new BlackBerry 10.2.1 Runtime for Android apps.
Now with support for Jelly Bean, Bluetooth, Mapview and more.
Get your Android app in front of a whole new audience.  Start now.
http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits