Hi Rob,

This is great help, many thanks!

Do you know if this is a feature or bug? Is IBObject going to fix
this in the future?

kind regards,
Duncan

--- In IBObjects@yahoogroups.com, "Robert martin" <rob@c...> wrote:
> 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]