Execute SQL query from OpenOffice macro

Question

I have an SQL query which I want to run when a button in my OpenOffice Calc worksheet is pressed. I've found out how to bind a macro to the button, but I can't get a connection to the database it seems (I've created an .odb file and I can run the query from within OpenOffice Base).

How do I tell OpenOffice Calc which connection to use and which query to execute?

What code did you try for connecting to the database?

Jim K
– Jim K

2016-09-12 14:39:23 +00:00
Commented Sep 12, 2016 at 14:39 — Jim K
– Jim K, Commented Sep 12, 2016 at 14:39

Community · Accepted Answer · 2017-05-23 12:14:57Z

2

Create a connection to the .odb file as in my answer here.

Then perform a query using executeQuery() and getString() as shown here: https://wiki.openoffice.org/wiki/Documentation/BASIC_Guide/Database_Access

edited May 23, 2017 at 12:14

CommunityBot

11 silver badge

answered Sep 12, 2016 at 14:36

Jim K

14.1k2 gold badges26 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Execute SQL query from OpenOffice macro

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related