<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - Libreoffice 6.1.3.2 does not allow saving Advanced Properties options with SQLITE 3 over ODBC"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=121092">bug 121092</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>NEW
</td>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Libreoffice 6.1.3.2 does not allow saving Advanced Properties options with SQLITE 3 over ODBC"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=121092#c17">Comment # 17</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Libreoffice 6.1.3.2 does not allow saving Advanced Properties options with SQLITE 3 over ODBC"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=121092">bug 121092</a>
from <span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span></b>
<pre>It is confirmed by independent research on
<a href="https://forumooo.ru/index.php/topic,7532.0.html">https://forumooo.ru/index.php/topic,7532.0.html</a>, 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:
<span class="quote">> ThisDatabaseDocument = ThisComponent
> ThisDatabaseDocument.DataSource.Settings.RespectDriverResultSetType = false</span >
Setting to NEW.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>