[Libreoffice-bugs] [Bug 68675] ODBC: support arbitrarily-sized bookmarks

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #7 from Lionel Elie Mamane <lionel at mamane.lu> ---
(In reply to Matt K from comment #6)
> Can you specify how to create these ODBC connections

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

> and how to view/create the bookmarks?

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()

-- 
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/20210514/e2596124/attachment.htm>