I am in a Delphi 5 using Firebird 1.0 environment.

I build a sql query that has a UNION statement. When I ran it using
TIBOQuery in a smaller size of database, the result set has no
problem.

If I ran it against a much bigger scale (expecting a return of 18000
records) of database, an exception raise: ISC Error code 335544569:
invalid SQL command, count column list & variable list do not match.

I ran the SQL query separatly without the Union, it worked ok.

Is there a limit in TIBOQuery?

Please help!

Thanks
Duncan