Id: | 10907 |
Product: | finPOWER Connect |
Type: | FIX |
Version: | 1.06.07 |
Opened: | 13/02/2013 |
Closed: | 13/02/2013 |
Released: | 27/03/2013 |
Job: | J011105 |
External Parties Add-On; Deleting an Employee of an External Party may give contraint message
When trying to delete an External Party Employee that is an External User (Users & Responsibilities form, External page), the following message is displayed:
ERROR MESSAGE
=============
Failed to save External Party.
Failed to save Client.
Failed to save Client Employments.
Failed to delete one or more records from table 'ClientEmployment'.
Failed to execute SQL.
The DELETE statement conflicted with the REFERENCE constraint "RI_ClientEmploymentUser_1". The conflict occurred in database "finPOWERConnect", table "dbo.User", column 'ExternalPartyEmployeePk'.
The statement has been terminated.
The above message is from a SQL Server database, Access message is similar.
This will now give a user friendly message:
ERROR MESSAGE
===============
Failed to save External Party.
Failed to save Client.
Failed to save Client Employments.
One or more Users are using an Employee you have deleted.