Subject How to know the size of result set before fetching?
Author Eyal

I need to know the size of a result set (ie. how many rows will be
fetched), before actually fetching them. This is in order to prepare
enough storage and to provide a visual progress bar to the user.

I tried using a TIB_Query with AutoFetchAll=FALSE, hoping that after I
activate the query, I'll get the number of rows from the RowsSelected
property, and then I can fetch them one by one as needed.

However RowsSelected returns the value 10, while there are many more
records in the result set.

Am I doing something wrong?

Is there any way (aside from a seperate COUNT(*) query) to get the
number of rows in the result set on the server?