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.