Bug 45912 - Connecting to access database using libreoffice's driver: one record missing
Summary: Connecting to access database using libreoffice's driver: one record missing
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
3.4.5 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 46772 (view as bug list)
Depends on:
Blocks:
 
Reported: 2012-02-10 13:26 UTC by pirri
Modified: 2014-07-14 14:51 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
MDB test database with 3 records (6.95 KB, application/x-zip-compressed)
2012-02-21 00:31 UTC, pirri
Details

Note You need to log in before you can comment on or make changes to this bug.
Description pirri 2012-02-10 13:26:54 UTC
I have detected the same bug that this user (not me :D) describe in his blog. See the post for more information. 3.5.x seems to be solved the problem.

http://do-the-right-things.blogspot.com/2012/01/caveat-in-using-libreoffice-base-to.html
Comment 2 pirri 2012-02-21 00:31:39 UTC
Created attachment 57379 [details]
MDB test database with 3 records
Comment 3 Alex Thurgood 2012-02-29 10:51:44 UTC
*** Bug 46772 has been marked as a duplicate of this bug. ***
Comment 4 Lionel Elie Mamane 2012-07-05 08:58:31 UTC
There is no further LibreOffice 3.4 bugfix release planned. Closing as fixed in 3.5 and later.

FYI, the patch to fix this is most probably (but I haven't tested that)

--- a/connectivity/source/drivers/ado/AResultSet.cxx
+++ b/connectivity/source/drivers/ado/AResultSet.cxx
@@ -401,7 +399,7 @@ void SAL_CALL OResultSet::beforeFirst(  ) throw(SQLException, RuntimeException)
 
 
     if(first())
-        previous();
+        m_bOnFirstAfterOpen = !previous();
 }
 // -------------------------------------------------------------------------
 void SAL_CALL OResultSet::afterLast(  ) throw(SQLException, RuntimeException)