<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - ODBC: support arbitrarily-sized bookmarks"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=68675#c7">Comment # 7</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - ODBC: support arbitrarily-sized bookmarks"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=68675">bug 68675</a>
from <span class="vcard"><a class="email" href="mailto:lionel@mamane.lu" title="Lionel Elie Mamane <lionel@mamane.lu>"> <span class="fn">Lionel Elie Mamane</span></a>
</span></b>
<pre>(In reply to Matt K from <a href="show_bug.cgi?id=68675#c6">comment #6</a>)
<span class="quote">> Can you specify how to create these ODBC connections</span >
Create an ODBC data source (OS specific; windows: launch ODBC administrator;
GNU/Linux: edit ~/.odbc.ini or use some GUI tool to do that)
launch:
libreoffice --base
(or from a running LibreOffice, menu file / new / database)
connect to an existing database
choose "ODBC" in the drop-down box
next
enter a valid ODBC data source configured on the system
next, etc
<span class="quote">> and how to view/create the bookmarks?</span >
They are not exposed in the UI; they are a feature of the programming API.
Insofar as LibreOffice code itself uses ODBC bookmarks, this would also cause
gui-user-visible bugs when operating on an ODBC source that makes bookmarks
longer than 20 bytes.
open a result set (programmatically execute a query returning results)
stick in a variable, named e.g. rs
then something like:
rs.next()
rs.getBookmark()</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>