On 1/22/07, Joe Martinez <joe@...> wrote:

> I have a TIBOQuery that I use as a general-purpose object for allowing
> users to run ad-hoc queries against the database. This works fine
> most of the time. However, this one particular query is giving us
> trouble

This is because internally the TIBOQuery component tries to build a
count SQL containing the union statement.
With TIB_Dataset descendants (e.g. TIB_Query) you have the possibility
to use the OnGetRecordCount event. Maybe something similar is possible
with a TDataset based component, too?