title: TSQLQuery not returning right amount of records
body: <p>I have a table called <code>Artist</code> which currently contains four records and a <code>TSQLQuery</code> that contains the following statement:</p>
  
  <pre><code>SELECT name
  FROM Artist
  </code></pre>
  
  <p>The table Artist also contains the following records:</p>
  
  <pre><code>id          name
  1           Artist 1
  2           Artist 2
  3           Artist 3
  4           Artist 4
  </code></pre>
  
  <hr>
  
  <p><strong>Current method of record retrieval:</strong></p>
  
  <pre><code>Query1.Open;
  for i := 0 to qArtist.FieldCount -1 do
      with cbArtist.ListBox.ListItems[i] do
          Text := qArtist.Fields[i].AsString;
  </code></pre>
  
  <p><strong>Previous method of record retrieval:</strong></p>
  
  <p>Data bind <code>Query1</code> to <code>ComboBox1</code>.</p>
  
  <hr>
  
  <p>With the "previous" method, <code>ComboBox1</code> would display all the expected records from the <code>Artist</code> table. However, when I try to use "current" method <code>Query1</code> is only selecting the very first record from the <code>Artist</code> table despite there being three other existing values. I have tried the "current" method across other queries and they also returned only the first value of the table.</p>
  
  <p>The reason I am going for this new approach is because I feel that I am very limited in what I can do if I continue to the "previous" / data bind method, but that is besides the point.</p>
  
  <p>So how can I fix this problem? i.e. the problem of the query only selecting the very first record from the table.</p>