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?
IBCQuery: select-query inconsistency with table
-
- Posts: 39
- Joined: Thu 21 Nov 2013 12:51
-
- Posts: 39
- Joined: Thu 21 Nov 2013 12:51
Re: IBCQuery: select-query inconsistency with table
It turns out setting TIBCQuery.Options.QueryRecCount := True solved the problem
Re: IBCQuery: select-query inconsistency with table
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.