Hi Duncan

You get this message when you interrogate the recordcount property of a TIBOQuery that contains a Union. The component cannot determine the number of records in a union result set. I think the only way to get the number of records is to run a separate SQL.


Rob Martin
Software Engineer

phone 03 377 0495
fax 03 377 0496
web www.chreos.com

----- Original Message -----
From: innoy1k
To: IBObjects@yahoogroups.com
Sent: Thursday, August 05, 2004 6:49 PM
Subject: [IBO] TIBOQuery problem


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



___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !


Yahoo! Groups Sponsor
ADVERTISEMENT





------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/IBObjects/

b.. To unsubscribe from this group, send an email to:
IBObjects-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]