Concurrency Exception

From Logic Wiki
Jump to: navigation, search


if you receive this exception check stored procedures. in this case the nulls at the last line were missing.

USE [Aviva_Dev]
GO
/****** Object:  StoredProcedure [dbo].[isp_EmpBankUpdateCommand]    Script Date: 20/02/2015 15:54:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[isp_EmpBankUpdateCommand]
(
       @EmployeeID int,
       @Sequence int,
       @RecordID int,
       @SortCode varchar(50),
       @AccountNo varchar(50),
       @AccountName varchar(50),
       @AccountTypeID int,
       @AccountRollNo varchar(50),
       @PercentAmount float,
       @Original_EmployeeID int,
       @Original_Sequence int,
       @Original_RecordID int,
       @Original_AccountName varchar(50),
       @Original_AccountNo varchar(50),
       @Original_AccountRollNo varchar(50),
       @Original_AccountTypeID int,
       @Original_PercentAmount float,
       @Original_SortCode varchar(50)
)
AS
       SET NOCOUNT OFF;

UPDATE isEmployeeBank SET EmployeeID = @EmployeeID, RecordID = @RecordID, SortCode = @SortCode, 
AccountNo = @AccountNo, AccountName = @AccountName, AccountTypeID = @AccountTypeID, 
AccountRollNo = @AccountRollNo, PercentAmount = @PercentAmount, Sequence = @Sequence  

WHERE (EmployeeID = @Original_EmployeeID) AND (RecordID = @Original_RecordID) 
AND (Sequence = @Original_Sequence) 
AND (AccountName = @Original_AccountName OR @Original_AccountName IS NULL) 
AND (AccountNo = @Original_AccountNo OR @Original_AccountNo IS NULL) 
AND (AccountRollNo = @Original_AccountRollNo OR @Original_AccountRollNo IS NULL) 
AND (AccountTypeID = @Original_AccountTypeID OR @Original_AccountTypeID IS NULL) 
AND (PercentAmount = @Original_PercentAmount OR @Original_PercentAmount IS NULL) 
AND (SortCode = @Original_SortCode OR @Original_SortCode IS NULL)