Page 1 of 1

RecordCount, geting only partial

Posted: Mon 22 Sep 2014 13:28
by alexhaifa
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

Re: RecordCount, geting only partial

Posted: Tue 23 Sep 2014 08:07
by ViktorV
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