The original query was something like

select Account, Invoice , ' ' from ArInv
where Period = :P
join
select Account, Invoice , CheckNo from ApInv
where Period = :P

This resulted in x number of records for a report.
The Report software issued a RecordCount against
the above Query to get its PageNumbering correct
in the format of Page n of m

IBO is pretty smart about this and converted the
RecordCount request to

select Count(*) from ArInv
where Period = :P
join
select Account, Invoice , CheckNo from ApInv
where Period = :P

which is not quite a correct SQL query and raised
an exception.

A small modification issues automaitically 2 queries
1. select Count(*) from ArInv
where Period = :P
2. select AccountCount(*) from ApInv
where Period = :P
and returns the sum of 1 and 2 as the RecordCount

Old Program and is now content and produces
the report correctly.

Best Regards
Hans

----- Original Message -----
From: "Aage Johansen" <aagjohan@...>
To: <ibobjects@yahoogroups.com>
Sent: Wednesday, February 02, 2005 2:16 PM
Subject: Re: [IBO] Problem with TIBOQuery


>
> Hans wrote:
> > ...
> > The closest I can think for FlushBuffers is Commit.
>
> What did FlushBuffers do with an IB (or Fb) database?
> My guess is that the BDE FlushBuffers could be replaced by a No-op.
>
>
> > ...
> > After I modified IB_Parse and IB_Components to
> > at least return a summarized UNION RecordCount,
> > it surprisingly all starting to work
>
> What did the BDE do to find the RecordCount? Run the query an extra time
> to get the count?
>
> > ...
>
>
> --
> Aage J.
>
>
>
> ___________________________________________________________________________
> 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 Links
>
>
>
>
>
>
>