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