Subject Re: [IBO] TIB_Query won't work with UNION
Author Jason Wharton
SQL Trace monitor would reveal useful information here.

Jason Wharton
CPS - Mesa AZ

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

----- Original Message -----
From: "alexp772001" <alexp772001@...>
To: <>
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
> 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.