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







Thanks,

Mahesh Pratihari

Sonata Software Limited

Phone : +91 80 3097 1527

Mobile : +91 99808 37446

www.sonata-software.com <http://www.sonata-software.com>



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]