Devart Forums

I am experiencing some inconsistencies when I run a simple 'Select * from TABLE order by PARAM' style query on a specific table in my database while comparing IBC and BDE.
BDE (And FlameRobin) shows 57 entries in the query while IBC finds 25.

I am using IBDAC 5.2.6 on Delphi XE and I realize a newer version if IBDAC has been released, but I wonder if this is a problem you are familiar with?

It turns out setting TIBCQuery.Options.QueryRecCount := True solved the problem

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 the fetch of the TIBCQuery.Open method. The rest of the rows will be fetched by necessity. If you would like to read all rows of the query when opening it, set FetchAll in True.