Base - Passthrough queries?

users
#1

In Access I can runn a passthrough query to execute SQL commands on a true DB server. Is this possible in Base? I have a MariaDB server and want to use Base to create forms for accessing it, but need to run SQL commands to encrypt and decrypt certain data, so linking the tables won't work.

Also, thank you for the advice with my last issue! I will be looking into using one of those methods to do an application style form later today.

#2

Hi Ryan,

In Access I can runn a passthrough query to execute SQL commands on a
true DB server. Is this possible in Base? I have a MariaDB server and
want to use Base to create forms for accessing it, but need to run SQL
commands to encrypt and decrypt certain data, so linking the tables
won't work.

There is an option to execute SQL directly.

From within the main LO Base window, once an ODB file is opened, go to

Tools > SQL

If you are just carrying out a select query, you can do this via the
"Construct a query in SQL mode"

Note that only select queries are supported via the Query GUI. Use the
Tools > SQL menu entry for DDL statements. Also note that even Tools >
SQL does not replace a command line client console, so your mileage as
to what you want to actually achieve might vary.

Alex

#3

That is not what I need. When I push a button on a form, I need some SQL statement(s) to be sent to the server. Is this possible?

#4

Hey Ryan,

You could write some Basic code and link it to the button.

#5

Only via a LO Basic macro or a script (python, java, JS, REXX), the
push-once and fire functionality you're considering isn't available in
LO as a simple UI option.

The UNO API property that deals with (by)passing the internal SQL parser
is "EscapeProcessing"

http://api.libreoffice.org/docs/idl/ref/servicecom_1_1sun_1_1star_1_1sdb_1_1DataAccessDescriptor.html#aa71981b851337d3842caede42c842c31

Alex