title: Firedac Empty Result Set
body: <p>I am sure that I'm overlooking some simple thing here.</p>
  
  <p>With a FireDac connection, if I use a SQL query with a <code>WHERE</code> clause that, due to the content of the search parameter, would normally return an empty result set, the OPEN command returns an error instead "Cannot open / define command, which does not return result sets". Is this by design ? Every other Delphi DB connection tool I have used simply returns an empty result set with a record count of 0.</p>
  
  <p>******************************* April 16
  I believe Victoria is on the right track. I had never used Firedac before so assumed it was the behaviour as designed. However if I communicate with the same RDBMS using the MS SQL driver, I do not see this happen, so I suspect it is on the Datasnap end. </p>