[libreoffice-users] Re: Base - Passthrough queries?

Le 15/01/2014 16:14, Ryan Ashley a écrit :

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


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted