IBCQuery: select-query inconsistency with table

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Bjarke_Moholt
Posts: 39
Joined: Thu 21 Nov 2013 12:51

IBCQuery: select-query inconsistency with table

Post by Bjarke_Moholt » Wed 20 Aug 2014 11:23

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?

Bjarke_Moholt
Posts: 39
Joined: Thu 21 Nov 2013 12:51

Re: IBCQuery: select-query inconsistency with table

Post by Bjarke_Moholt » Wed 20 Aug 2014 13:06

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

PavloP
Devart Team
Posts: 149
Joined: Fri 24 Jan 2014 12:33

Re: IBCQuery: select-query inconsistency with table

Post by PavloP » Wed 20 Aug 2014 14:06

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.

Post Reply