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+unsubscr...@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
