This is a case where you need to override the RecordCount functionality
using the OnGetRecordCount event. You can also fetch all records into the
dataset and avoid the attempt it does to have the server figure the record
count out. Setting AutoFetchAll to true.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "alexp772001" <alexp772001@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, September 10, 2002 10:45 AM
Subject: Re: [IBO] TIB_Query won't work with UNION


> --- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:
> > SQL Trace monitor would reveal useful information here.
> >
>
> Jason,
> I found it. It attempts to count records using a wrong statement like:
>
> SELECT COUNT(*) FROM MYTABLE WHERE.....
> UNION ALL SELECT F1, F2, FN FROM TABLE2 WHERE.....
>
> I can send you the complete log if you need it.
>
> Regards,
> Alessandro.