Thanks Helen,

I changed my application to check for EOF, not just loop for the
RecordCount, now works fine.

As you say, counting of records is unreliable.

> -----Original Message-----
> From: Helen Borrie [SMTP:helebor@...]
> Sent: Wednesday, 13 November 2002 8:41 AM
> To: ib-support@yahoogroups.com
> Subject: Re: [ib-support] Newbie Question
>
> At 08:01 AM 13-11-02 +1100, you wrote:
> > > I am new to Firebird (and SQL as you will guess by my question)...
> > > select * from GDTH JOIN GDTT ON GDTH_KEY = GDTT_PARENT where GDTH_KEY
> =
> > > "SCHL"
>
> Some older versions of query tools may not do the right thing in counting
> the number of rows fetched, especially from joined queries