Subject RE: [firebird-support] Not able to retrieve the data from Table
Author Svein Erling Tysvær
>Hi All,
>I am writing the query for getting the first 100 records from the table.
>Like - select first 100 * from XXX
>I am able to get the data from the table
>But when trying to getting the first 110 records from the table, I am not able to retrieve
>the data as it is still in transaction.
>I don't know what behavior of the table in firebird 2.5. Please help me how to overcome
>this issue.

Simple answer - we don't know. To get a better answer, please provide more details, what you've written above is about as helpful as asking 'my car can go 100 km, but not 110. Please help.' No one can tell the answer without getting to know more about your problem (I know Firebird normally has no problem returning thousands of records, many of us write queries that does that every day).

Are you saying that you're using isql (included with Firebird, typically in the 'bin' directory), FlameRobin or IB_SQL and that select first 100 works, whereas select first 110 doesn't? Or are you using some other way to issue the select? And what do you mean by 'data still in transaction?' Firebird does (almost) everything within transactions, any SELECT has to be within a transaction and the transaction typically lasts until you do COMMIT or ROLLBACK.

Or are you saying that you cannot simultaneously run two queries selecting the same data? Since Firebird uses optimistic locking and only complains if two transactions try to modify the same data, that could mean that either you or your connection components are doing something behind the scenes.

So, please provide more details so that we can give you better help,