Do a FetchAll prior to accessing RecordCount with a query like this.

Regards,
Jason Wharton

----- Original Message -----
From: "d5f212" <abhishek_dsc@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, July 20, 2009 8:55 AM
Subject: [IBO] recordcount wrong


> Hi all,
>
> I was working with a query as follows
>
> "select first 3 skip 2 from table"
>
> where in i was expecting the recordcount of the query to be 3, but it gave
> the recordcount of the following query
>
> "select * from table"
>
> not just that, when i navigated through the query i was able to retrieve
> the records which were skipped/or not selected.
>
> Please help/guide me to a proper solution, i m using firebird 2.1.2 and ib
> 4.8.6