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
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> 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
>
>
>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> 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
>
>
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.1901 / Virus Database: 2109/4734 - Release Date: 01/10/12
>
>