Hello,
when I open my IBCQuery I need to get all recordcount that my Query got, but through this
way
IBCQuery.RecordCount
It returns me only the partial.
How can I get all the records count from my query?
Thanks
Alex
RecordCount, geting only partial
Re: RecordCount, geting only partial
The TIBCQuery component has the FetchAll and FetchRows properties, which default values are False and 25, correspondingly. If FetchAll = False, only FetchRows of rows will be read during fetching of the TIBCQuery.Open method.
The rest of the rows will be fetched by necessity. If you would like to read all the rows of the query when opening it, set FetchAll to True. You can read about it in the IBDAC help: http://www.devart.com/ibdac/docs/devart ... tchall.htm
Otherwise, if FetchAll is set to False, then you can set the TIBCQuery.Options.QueryRecCount property to True. You can read about it in the IBDAC help: http://www.devart.com/ibdac/docs/devart ... ccount.htm
The rest of the rows will be fetched by necessity. If you would like to read all the rows of the query when opening it, set FetchAll to True. You can read about it in the IBDAC help: http://www.devart.com/ibdac/docs/devart ... tchall.htm
Otherwise, if FetchAll is set to False, then you can set the TIBCQuery.Options.QueryRecCount property to True. You can read about it in the IBDAC help: http://www.devart.com/ibdac/docs/devart ... ccount.htm