title: Using multiple SQL queries
body: <p>I  have done some searching and can't find a definitive answer to this one.</p>
  
  <p>I am just getting into SQL so be gentle. Using D5, TNTUnicode, Zeos and SQLite3</p>
  
  <p>I have a DBGrid with all the Account names in the tblAccounts showing.
  I have a DBGrid with all the Folders in the tblFolders showing.</p>
  
  <p>In the OnCellClick of the Accounts grid I have an SQL query</p>
  
  <pre><code>qryFolders.Close;
  qryFolders.SQL.Clear;  // Not really needed as I am assigning the Text next - but :)
  qryFolders.SQL.Text:=
    'SELECT Folder FROM tblFolders WHERE UPPER(Account)="FIRSTTRADER"'
  qryFolders.ExecSQL;
  tblFolders.Refresh;
  </code></pre>
  
  <p>In my application, nothing happens, I still have the full list of Folders visible.</p>
  
  <p>In the SQL-Expert desktop <strong>that line works fine</strong> and displays only the two Folders associated with that Account. In that app it keeps displaying the full list of Folders</p>
  
  <p>If I step through the OnCellClick it shows the correct Text etc.</p>
  
  <p>Where am I going wrong?</p>
  
  <p>Thanks</p>