Article Details
Id:10881
Product:finPOWER Connect
Type:NEW
Version:1.06.07
Opened:04/02/2013
Closed:04/02/2013
Released:27/03/2013
Job: J011058

Securities Register Add-On; Deleting a Client when Client is an Owner on a Security item needs better error message

When trying to delete a Client that is set as the Owner on a Security Item causes the following message to be displayed:

ERROR MESSAGE
=============
Failed to delete Client.

Failed to execute SQL.

The DELETE statement conflicted with the REFERENCE constraint "RI_ClientSecurityStmtIt_1". The conflict occurred in database "finPOWERConnect", table "dbo.SecurityStmtItem", column 'OwnerClientPk'.
The statement has been terminated.


This is now handled in the business layer and the following message will be displayed:

ERROR MESSAGE
=============
Failed to delete Client.

This Client is used as the 'Owner' Client by one or more Security Statement Items.