Subject | TIBOQuery problem |
---|---|
Author | innoy1k |
Post date | 2004-08-05T06:49:03Z |
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
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