I am converting an application from Paradox to Interbase. In my application,
the user runs a lot of searches on certain criteria. Every time a search is
run, I want to return a count of how many records were returned.

I know that RecordCount doesn't return the number of records unless you call
something like Dataset.Last first of all. What is the best way then to find
the number of records?

I am using the Interbase Express components. Should I run a matching IBSQL
query with a Count(*) at the same time as I use TIBDataSet to get the data?

Should I instead use a stored procedure, or something like that?

Should I just call Last and then RecordCount?

Is TIBDataSet the best component to be using to get the data? Would TIBQuery
be better?

Thanks,
Stephen