|Subject||Re: [IBO] recordcount wrong|
Do a FetchAll prior to accessing RecordCount with a query like this.
----- Original Message -----
From: "d5f212" <abhishek_dsc@...>
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