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

1 files changed, 7 insertions, 1 deletions

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);