From 415b287555b84bee01d2acbf4e7c6434e1cdba7f Mon Sep 17 00:00:00 2001 From: einhverfr Date: Wed, 25 Jun 2008 18:19:28 +0000 Subject: Correcting issue on Vendor screen. Displaying wrong account info when selecting entity from vendor report. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2172 4979c152-3d1c-0410-bac9-87ea11338e46 --- sql/modules/Company.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'sql') diff --git a/sql/modules/Company.sql b/sql/modules/Company.sql index b7f5e640..b5dd76cc 100644 --- a/sql/modules/Company.sql +++ b/sql/modules/Company.sql @@ -220,11 +220,11 @@ BEGIN END; $$ LANGUAGE PLPGSQL; -CREATE OR REPLACE FUNCTION company_retrieve (in_id int) RETURNS company AS +CREATE OR REPLACE FUNCTION company_retrieve (in_entity_id int) RETURNS company AS $$ DECLARE t_company company; BEGIN - SELECT * INTO t_company FROM company WHERE id = in_id; + SELECT * INTO t_company FROM company WHERE entity_id = in_entity_id; RETURN t_company; END; $$ language plpgsql; -- cgit v1.2.3