[Libreoffice-bugs] [Bug 121092] Libreoffice 6.1.3.2 does not allow saving Advanced Properties options with SQLITE 3 over ODBC

[bugzilla-daemon at bugs.documentfoundation.org]

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

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
     Ever confirmed|0                           |1

--- Comment #17 from Mike Kaganski <mikekaganski at hotmail.com> ---
It is confirmed by independent research on
https://forumooo.ru/index.php/topic,7532.0.html, where another server
(Firebird) was connected using ODBC. Newer versions of LO (reportedly 6.0+)
could not perform specific tasks on the server (namely, add records), while
creation and editing of tables was possible. It was reportedly OK with 5.4.7.2.

The problem was nailed down to the "Respect the result set type from the
database driver" setting on the Advanced Settings dialog, where it is reset to
enabled state upon reloading the odb, along with some other settings. Being
unable to unset and save state drove the reporter to write a macro attached to
"File Open" event:

> ThisDatabaseDocument = ThisComponent
> ThisDatabaseDocument.DataSource.Settings.RespectDriverResultSetType = false

Setting to NEW.

-- 
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/20190305/520b9b3b/attachment-0001.html>