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

Hey Ryan,

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

On 01/15/2014 06:57 PM, Ryan Ashley wrote:
> 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?
>
> On 1/15/2014 1:04 PM, Alex Thurgood wrote:
> > 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


-- 
    _
   °v°
  /(_)\
   ^ ^  Mark LaPierre
Registered Linux user No #267004
https://linuxcounter.net/
****

-- 
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