title: Row cannot be found for Locate?
body: <p>I'm converting existing Advantage Database Server application to SQL Server 2005 using D2009, dbGo (ADO). Sometimes i experience the error <code>row cannot be found for locating</code>. I had googled it, according to results i needed to set Update Criteria property of each ADOTable and set cursor location to dynamic. I did so, but sometimes i still get same error. All of the tables has primary key so I've been using </p>
  
  <pre><code>Query.Requery(); 
  Query.Locate('ID',ID,[]); 
  </code></pre>
  
  <p>before updating record to avoid error, but there has to be better solutions. Any ideas? Or should i move on to MyDAC or Zeoslib?</p>