How to get the recordcount?

[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

[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

[alexhaifa]

Thanks very much

[ViktorV]

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.