Ask Your Question

Using macros to dynamically change a query definition [closed]

asked 2014-06-04 22:56:49 +0100

stuart.simon65536 gravatar image

Hello! My name is Stuart Simon. I am an active LibreOffice user and an experienced SQL programmer. However, I am just learning Java and am relatively new to LibreOffice macros. I have read through parts of's documentation and am still confused about what everything means for the user who is not experienced with macros. I have a database registered to LibreOffice under the name of "ArchiveMusic" and a query inside said database named "CSVExport" whose SQL definition string I would like to change dynamically. I would like to know the clause that assigns the new definition string to the "CSVExport" query inside the "ArchiveMusic" database. I would also like to know the command I can use to run a SELECT statement inside the macro that returns a single integer value, and assign said value to the macro variable var, preferably using the syntax '$var = select_value("SELECT ...")'. If you quote your answer, like I just did, please remember to use double quotes to quote single quotes and quadruple quotes to quote double quotes. Thank you!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-24 13:50:18.671470

1 Answer

Sort by » oldest newest most voted

answered 2014-06-05 00:49:15 +0100

m.a.riosv gravatar image

I think you can find useful information in:

Andrew's Macros it's a reference.
OO.o Basic Programmer's guide.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-06-04 22:56:49 +0100

Seen: 1,000 times

Last updated: Jun 05 '14