| Subject | TIB_Query won't work with UNION |
|---|---|
| Author | alexp772001 |
| Post date | 2002-09-10T14:30:53Z |
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.
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.