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: [email protected] 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
