title: How do I access the result of a Select count(*) using an SQLQuery component in Delphi
body: <p>I am using Delphi RAD Studio 9 and Firebird 2.5</p>
  
  <p>I want to use the count of the number of rows that fit a certain condition.
  When I put </p>
  
  <pre><code>Select count(*) from VRDB where Lname - 'SMITH'
  </code></pre>
  
  <p>into the the SQL property , upon opening SQLQuert1, I get the error message</p>
  
  <blockquote>
    <p>SQLQuery1: Unable to determine field names for %s.</p>
  </blockquote>
  
  <p>I assume this means  Firebird or Delphi doesn't know what to do with the result.</p>
  
  <p>How do I trap the result of the query? (My query statements work fine using isql.)</p>