http://logicwiki.co.uk/index.php?action=history&feed=atom&title=Concurrency_Exception 2026-10-28T03:51:15Z Revision history for this page on the wiki MediaWiki 1.26.2 http://logicwiki.co.uk/index.php?title=Concurrency_Exception&diff=435&oldid=prev 2016-05-09T13:27:35Z

<p>1 revision imported</p> <table class='diff diff-contentalign-left'> <tr style='vertical-align: top;' lang='en'> <td colspan='1' style="background-color: white; color:black; text-align: center;">← Older revision</td> <td colspan='1' style="background-color: white; color:black; text-align: center;">Revision as of 13:27, 9 May 2016</td> </tr><tr><td colspan='2' style='text-align: center;' lang='en'><div class="mw-diff-empty">(No difference)</div> </td></tr></table>

Dt1nh6 http://logicwiki.co.uk/index.php?title=Concurrency_Exception&diff=434&oldid=prev 2015-03-03T15:46:33Z

<p></p> <p><b>New page</b></p><div>[[Category:Tips]]<br /> [[Category:Errors]]<br /> <br /> if you receive this exception check stored procedures. in this case the nulls at the last line were missing. <br /> <br /> &lt;pre class=&quot;brush:sql;&quot;&gt;<br /> USE [Aviva_Dev]<br /> GO<br /> /****** Object: StoredProcedure [dbo].[isp_EmpBankUpdateCommand] Script Date: 20/02/2015 15:54:44 ******/<br /> SET ANSI_NULLS ON<br /> GO<br /> SET QUOTED_IDENTIFIER ON<br /> GO<br /> ALTER PROCEDURE [dbo].[isp_EmpBankUpdateCommand]<br /> (<br /> @EmployeeID int,<br /> @Sequence int,<br /> @RecordID int,<br /> @SortCode varchar(50),<br /> @AccountNo varchar(50),<br /> @AccountName varchar(50),<br /> @AccountTypeID int,<br /> @AccountRollNo varchar(50),<br /> @PercentAmount float,<br /> @Original_EmployeeID int,<br /> @Original_Sequence int,<br /> @Original_RecordID int,<br /> @Original_AccountName varchar(50),<br /> @Original_AccountNo varchar(50),<br /> @Original_AccountRollNo varchar(50),<br /> @Original_AccountTypeID int,<br /> @Original_PercentAmount float,<br /> @Original_SortCode varchar(50)<br /> )<br /> AS<br /> SET NOCOUNT OFF;<br /> <br /> UPDATE isEmployeeBank SET EmployeeID = @EmployeeID, RecordID = @RecordID, SortCode = @SortCode, <br /> AccountNo = @AccountNo, AccountName = @AccountName, AccountTypeID = @AccountTypeID, <br /> AccountRollNo = @AccountRollNo, PercentAmount = @PercentAmount, Sequence = @Sequence <br /> <br /> WHERE (EmployeeID = @Original_EmployeeID) AND (RecordID = @Original_RecordID) <br /> AND (Sequence = @Original_Sequence) <br /> AND (AccountName = @Original_AccountName OR @Original_AccountName IS NULL) <br /> AND (AccountNo = @Original_AccountNo OR @Original_AccountNo IS NULL) <br /> AND (AccountRollNo = @Original_AccountRollNo OR @Original_AccountRollNo IS NULL) <br /> AND (AccountTypeID = @Original_AccountTypeID OR @Original_AccountTypeID IS NULL) <br /> AND (PercentAmount = @Original_PercentAmount OR @Original_PercentAmount IS NULL) <br /> AND (SortCode = @Original_SortCode OR @Original_SortCode IS NULL)<br /> <br /> &lt;/pre&gt;</div>

Macrop