[Libreoffice-bugs] [Bug 106463] Data Records Not Saved to External Firebird Database File

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=106463

--- Comment #18 from Lionel Elie Mamane <lionel at mamane.lu> ---
(In reply to Terrence Enger from comment #11)

> (1) A user thinking of data entry into a database will expect changes
>     to become permanent at the end of each transaction, for some
>     meaning of transaction.  If Base is linked to an external
>     database, this is how we work.  Right?

Yes, that's how it works when Base acts as a front-end to an external database.
IMO, in a form or "table data entry view", each time one
 - switches from one record to another
 - closes the form
 - clicks the "save record" button in the "form navigation" toolbar
that's a commit (end of a transaction).

Most DBMSs have a mode where they "autocommit" at the end of each statement,
and it is the default mode; it seems firebird does not, so IMO the SDBC driver
should take care of issuing a commit at the end of each call to any of execute,
executeQuery, executeUpdate in Statement.cxx and PreparedStatement.cxx

> (2) A user thinking of maintaining an office document will expect
>     close-without-save to discard the whole session.

IMO, no, that's not how Base works as front-end to an external database.

When connecting to an external database, saving the ODB file and saving
(committing) the data to the database is not linked, not one way nor the other.
One can save the ODB file without committing data, and one can commit data
without saving the ODB file.

It is only with a database embedded in the ODB file that "saving" the data
requires saving the ODB!!!

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190128/776873e8/attachment.html>