Hi Duncan

I noticed the problem recently and posted the same question. Jason Wharton confirmed it is a known problem with no easy solution. If you really need the record count you could always do an SQL to calculate it.

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: Friday, August 06, 2004 11:23 AM
Subject: Re: [IBO] TIBOQuery problem


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]



___________________________________________________________________________
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]