Subject Re: [IBO] TIBOQuery problem
Author Robert martin
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
----- Original Message -----
From: innoy1k
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

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!


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

Yahoo! Groups Sponsor

Yahoo! Groups Links

a.. To visit your group on the web, go to:

b.. To unsubscribe from this group, send an email to:

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

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