From 49c0b62ecacd828569849c4a05607f4161f0cbac Mon Sep 17 00:00:00 2001 From: einhverfr Date: Wed, 20 Aug 2008 21:06:06 +0000 Subject: Correcting issues with editing contact info git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2287 4979c152-3d1c-0410-bac9-87ea11338e46 --- sql/modules/Company.sql | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) (limited to 'sql') diff --git a/sql/modules/Company.sql b/sql/modules/Company.sql index 04056164..4cd0e2cd 100644 --- a/sql/modules/Company.sql +++ b/sql/modules/Company.sql @@ -713,11 +713,17 @@ END; $$ language plpgsql; CREATE OR REPLACE FUNCTION eca__save_contact -(in_credit_id int, in_contact_class int, in_description text, in_contact text) +(in_credit_id int, in_contact_class int, in_description text, in_contact text, +in_old_contact text, in_old_contact_class int) RETURNS INT AS $$ DECLARE out_id int; BEGIN + DELETE FROM eca_to_contact + WHERE credit_id = in_credit_id + AND contact = in_old_contact + AND contact_class_id = in_old_contact_class; + INSERT INTO eca_to_contact(credit_id, contact_class_id, description, contact) VALUES (in_credit_id, in_contact_class, in_description, in_contact); -- cgit v1.2.3