<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Firebird: Support more XResultSet functions" href="https://bugs.documentfoundation.org/show_bug.cgi?id=118094#c13">Comment # 13</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Firebird: Support more XResultSet functions" href="https://bugs.documentfoundation.org/show_bug.cgi?id=118094">bug 118094</a> from <a class="email" href="mailto:lionel@mamane.lu" title="Lionel Elie Mamane <lionel@mamane.lu>"> Lionel Elie Mamane</a> <pre>(In reply to Tamas Bunth from <a href="show_bug.cgi?id=118094#c12">comment #12</a>) > The Firebird API supports moving the cursor only forward. ${EXPLETIVE} Now I feel guilty for selecting Firebird as embedded database for LibreOffice. > They could be implemented though by reopening the result set each time we'd > go backwards, and seek out the requested row. I usually consider that is beyond the role of the SDBC driver. An alternative implementation idea would be to cache the whole resultset... > After looking around in the documentation of the C API it seems to me that > it cannot be done, unless we calculate it with a "Select COUNT(...) from > ..." kind of query. That could be expensive though. Again, that kind of thing is beyond the role of the SDBC driver. For the specific thing of isLast, we can fetch one additional row (and cache it), this would allow to know if the current row is the last... I looked at the JDBC driver, it seems they cache (at least in some situations) the resultset in order to be able to implement going backward.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>