Ok, I have added in support for the ROWS clause. It will be in build 36.

Also, please take notice, there was a bug introduced in build 35 that makes
it unfit for production use. Please, hold back making any production
releases of your software based upon build 35.

Jason

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Robert Martin
Sent: 10 January 2012 05:18 PM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] RecordCount

Thanks Jason

Will give that a go :)

p.s. I'm using Firebird not Interbase. Just use Rows because thats more
standard then FIRST / SKIP.

Cheers
Rob

On 11/01/2012 12:54 p.m., IBO Support List wrote:
> Rob,
>
> I need to fix this as I consider it a bug. I just recently fixed the use
of
> FIRST and SKIP so that they will work accurately and so now I need to take
> the InterBase side of it into consideration as well.
>
> In the meantime, if you set AutoFetchAll to true or call FetchAll prior to
> requesting the RecordCount then you will get an accurate count.
>
> Jason
>
>
> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On
Behalf
> Of Robert Martin
> Sent: 10 January 2012 04:06 PM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] RecordCount
>
> Hi
>
> I have RecordCountAccurate set to true but when calling RecordCount for
> queries with a limited results (i.e. using Rows 200 to restrict the
> number of records returned), the rows qualifier is ignored.
>
> Is there another way to get the number of records in the dataset that
> will work?
>
> Thanks
> Rob