title: Update after a table field change
body: <p>I have a problem with a old Delphi system, this system insert data into a SQL Server table.</p>
  
  <p>After 10 years change a field of the table from 100 to 255 chars long.</p>
  
  <p>The system select all the registris of the table, and put them on an other table after a transformation. That works fine.</p>
  
  <p>The problems are when the system update a field.</p>
  
  <p>That show me the error </p>
  
  <blockquote>
    <p>EDBEngineError with message 'Couldn't perform the edit because another user changed the record.</p>
  </blockquote>
  
  <pre><code>sConsulta:='SELECT * FROM cuentas WHERE (WALL= 2) AND (SEND_DATE = '01/01/1970')';
  m_oQryLeg.Close;
  m_oQryLeg.SQL.Clear;
  m_oQryLeg.SQL.Add(sConsulta);
  m_oQryLeg.Open;
  m_oTblNov.Close;
  m_oTblNov.TableName:='des_table';
  m_oTblNov.Open;
  
  with m_oTblNov do
  begin
    while (not m_oQryLeg.EOF) do
    begin
      Insert;
      FieldbyName('COD_HOME').AsString:= m_oQryLeg.FieldByName('USR_HOME').AsString;
      (...)
      Post;
  
      m_oQryLeg.Edit;
      m_oQryLeg.FieldByName('SEND_DATE').AsDateTime:= Date; //&lt;-- HERE THE ERROR
      m_oQryLeg.Post;
  
      m_oQryLeg.First;
      m_oQryLeg.MoveBy(i);
      inc(i);
    end;    
  end;
  m_oTblNov.Close;
  m_oQryLeg.Close;
  </code></pre>
  
  <p>UpdateMode: upWhereAll</p>
  
  <p>cuentas table:</p>
  
  <ul>
  <li>NUM_SOL      nvarchar    6   *PK</li>
  <li>WALL     tinyint     1</li>
  <li>SEND_DATE    smalldatetime   4    </li>
  <li>OBS_CRED     nvarchar    255 </li>
  <li>FLCC     real        4   </li>
  <li>STREET       nvarchar    30</li>
  </ul>