Page 1 of 1
How to get the recordcount?
Posted: Tue 05 May 2015 14:56
by alexhaifa
Hello,
When I use the code this way:
IBCquery.RecordCount
It always return me the 25 registers.
How to get all the recordCount correctly?
Thanks
Re: How to get the recordcount?
Posted: Tue 05 May 2015 15:37
by marcodor
So, you have 2 options here:
One is to call Query.FetchAll before RecordCount.
Better one (for large datasets) is to set Options.QueryRecCount to True and fill appropriate SQLRecCount property to retrieve count, like: select count (*) from bla bla
Re: How to get the recordcount?
Posted: Tue 05 May 2015 18:31
by alexhaifa
Thanks very much
Re: How to get the recordcount?
Posted: Wed 06 May 2015 07:26
by ViktorV
alexhaifa wrote:Hello,
When I use the code this way:
IBCquery.RecordCount
It always return me the 25 registers.
How to get all the recordCount correctly?
Thanks
The similar question has already been discussed on our forum.
Follow the link
http://forums.devart.com/viewtopic.php?f=24&t=30459 for details.