title: Update failed because it contains a derived or constant field
body: <p>There is my view from SQL Server Management Studio, column Pocket is set to 0 as default </p>
  
  <pre><code>SELECT ToolAssembly.ID, CAST(0 AS int) AS Pocket FROM dbo.ToolAssembly
  </code></pre>
  
  <p>And when I am trying to update the view in MMSD with the code:</p>
  
  <pre><code>SqlCommand command = new SqlCommand("UPDATE [mmlTooling].[dbo].vHHPocket SET Pocket = @pid Where ID = @tid", sqlCon);
  
  command.Parameters.AddWithValue("@pid", pid);
  command.Parameters.AddWithValue("@tid", tid);
  command.ExecuteNonQuery();
  </code></pre>
  
  <p>Then, the error message appeared: </p>
  
  <blockquote>
    <p>Update or insert of view or function 'mmlTooling.dbo.vHHPocket' failed
    because it contains a derived or constant field.</p>
  </blockquote>
  
  <p>What could be the causes of this problem and how to address it? </p>