Subject Not able to retrieve the data from Table
Author Mahesh Pratihari
Hi All,

I am writing the query for getting the first 100 records from the

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.


Mahesh Pratihari

Sonata Software Limited

Phone : +91 80 3097 1527

Mobile : +91 99808 37446 <>

Please don't print this email unless you really need to. This will
preserve trees on our planet.

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