Subject | Not able to retrieve the data from Table |
---|---|
Author | Mahesh Pratihari |
Post date | 2012-05-19T12:03:46Z |
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]
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]