Subject | Re: [IBO] TIB_Query won't work with UNION |
---|---|
Author | alexp772001 |
Post date | 2002-09-10T17:45:35Z |
--- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:
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.
> 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.