title: SQLite3 and Refresh after deleting a record?
body: <p>two hours of searching and reading and I am no closer.</p>
  
  <p>Using D5, Zeos v6 SQLite I have Table with the rows displayed in a DBGrid. All fine.</p>
  
  <p>I use</p>
  
  <pre><code>DELETE FROM tblOne WHERE Acct="FirstEntry"
  </code></pre>
  
  <p>and it deletes the only row that matches. Still all fine - but the DBGrid display stays the same still showing the row just deleted.</p>
  
  <p>I read that closing and opening the TTable assigned to tblOne will refresh the display (as will tblOne.Refresh) which is fine for this test, but sometimes I will not know which Table it is, all I will have is the Table Name. There is no "OPEN", "CLOSE" or "REFRESH" command in SQLite that I can find.</p>
  
  <p>So, how can I refresh the DBGird display to show the record has been deleted?</p>
  
  <p>(edit)
  I know I can use </p>
  
  <pre><code>dbgrid1.DataSource.DataSet.Refresh;
  </code></pre>
  
  <p>but, how does one refresh a display using SQL statements? Or is it not possible?
  (edit)</p>
  
  <p>A short line of code would help to describe the process. </p>
  
  <p>Thanks</p>