summaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authoreinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-02-27 21:17:35 +0000
committereinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-02-27 21:17:35 +0000
commit15ebe1a6d5c5df967745787749d23d2ff1f367fe (patch)
tree64ff6ff126922eb261b6ecf5d54c7021584add0e /sql
parenteda9e2f22202c3e6639fb34991a3884e48592ef8 (diff)
Committing customer/vendor address save fix
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2093 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'sql')
-rw-r--r--sql/modules/Company.sql9
1 files changed, 4 insertions, 5 deletions
diff --git a/sql/modules/Company.sql b/sql/modules/Company.sql
index feddd8e0..faffe92e 100644
--- a/sql/modules/Company.sql
+++ b/sql/modules/Company.sql
@@ -396,17 +396,16 @@ CREATE OR REPLACE FUNCTION company__next_id() returns bigint as $$
$$ language 'sql';
CREATE OR REPLACE FUNCTION company__location_save (
- in_company_id int,
+ in_entity_id int, in_location_id int,
in_location_class int, in_line_one text, in_line_two text,
- in_city_province TEXT, in_mail_code text, in_country_code int,
+ in_city TEXT, in_state TEXT, in_mail_code text, in_country_code int,
in_created date
) returns int AS $$
BEGIN
return _entity_location_save(
- in_company_id,
+ in_entity_id, in_location_id,
in_location_class, in_line_one, in_line_two,
- in_city_province , in_mail_code, in_country_code,
- in_created);
+ '', in_city , in_state, in_mail_code, in_country_code);
END;
$$ language 'plpgsql';