title: SQL query updates then revertes changes
body: <p>I'm currently baffled by the one problem. I can insert and delete records from my table but I can't update certain fields. It does update it temporarily before reverting changes 0.5 seconds later, I physically see the change. Btw this is done in Delphi 7:</p>
  
  <pre><code>CloseDatabase;     // Closes my database first to prevent an error from accessing one that is already open
  OpenDatabase;      // Dynamically opens the database
  ActivateEdits;
  
  if dbeEnglish.Enabled then
  begin
    qryDictionary.SQL.Text := 'Update [word list] set [english] = "'+dbeEnglish.Text+'" where  ([afrikaans] = "'+dbeAfrikaans.Text+'") and ([english] = "'+sEnglishBefore+'")';
    qryDictionary.ExecSQL;
  end
  else
  begin
    qryDictionary.SQL.Text := 'Update [word list] set [afrikaans] = "'+dbeAfrikaans.Text+'" where ([english] = "'+dbeEnglish.Text+'") and ([afrikaans] = "'+sAfrikaansBefore+'")';
    qryDictionary.ExecSQL;
  end;
  
  SelectAll;          // SQL to select * from [word list]  as well as set the column widths
  bEngOnce := False;  // variable i used to prevent both dbe (data base edits) from being edited
  bAfrOnce := False;
  </code></pre>
  
  <p>Am I updating wrong or missing something in OI?  It does update just doesn't make it permanent.</p>
  
  <p>Forgot to mention:  The table word list has 3 fields: an auto number field called ID, english and afrikaans.  Could the auto number be causing a problem to update?</p>