Subject RE: [firebird-support] Not able to retrieve the data from Table
Author Mahesh Pratihari
Hi Svein,

I am using the flameRobbin tool to execute the query.

I write the select query like select first 100 * from XXX , I am able to get the result. But when use one more query select first 110 * from XXX , I am not able to get the data, still it is in process to get the

Data. I am surprise for getting another 10 extra records why it is taking so much time.

I don't know where is the problem, please let me know if you have faced this type of problem how you resolved this.



From: [] On Behalf Of Svein Erling Tysvær
Sent: Saturday, May 19, 2012 6:55 PM
Subject: RE: [firebird-support] Not able to retrieve the data from Table

>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,

[Non-text portions of this message have been removed]