SQL Trace monitor would reveal useful information here.

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 7:30 AM
Subject: [IBO] TIB_Query won't work with UNION


> Hi all,
> I'm using a TIB_Query with an select statement containing a UNION ALL.
> If I use it in a standard app everything goes ok but inside a
> service, built with the standard D6 TService, it always returns:
>
> ERROR CODE:335544569
>
> ISC ERROR MESSAGE:
> Dynamic SQL Error
> SQL error code = -104
> Invalid command
> count of column list and variable list do not match
> .
>
> This has been solved by setting AutoFetchAll to True. It sounds very
> strange to me.
>
> Regards,
> Alessandro.