Libreoffice Base doesn’t save new records or changes to records after commit applied by pressing “Save” button in form.
I have a “todo” Base document with data table and some forms to add, view and modify this data table. When I add a new record and commit it from the “add” form, I could see data changes in “view” form as expected. But if there is a crash of Libreoffice, no recent data changes could be retrieved from saved to disk database file.
For example: add new record to table, commit it and check if it’s there. Then “kill -9” Libreoffice or simulate crash by the other means. Open saved database file, answer “yes, recover” to “Recover after crash” dialog and check there is no recently added data record. Data lost could be significant in such a way (for some days for long uptime).
There is an old closed question related with a macro workaround:
make-database-store-changes-immediately
So, is there a way to commit changes to disk(!) manually? Without using a macro? Should it be the default behavior?
Base info:
Version: 5.0.3.2
Build ID: 1:5.0.3~rc2-0ubuntu1~trusty2
Locale: en-IE (en_US.UTF-8)
Database driver: HSQLDB