Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index

Le 16/07/2014 12:03, Ian Prideaux a écrit :

Hi Ian,

What do I need to do, so that when I click the Save Record button, the
form automatically strips leading and trailing whitespace from the text
fields. I know that there's a trim function, but I can't figure out how
to tie it into the form.

Either :

1) a trigger


2) a macro that gets fired on the Save record button, or alternatively
an executeSQL statement object that you could tie in to a separate
button on the form..

(1) is complicated to set up with the default version of hsqldb 1.8
included in LO, basically because you would have to write it in Java and
then find some way to call it from within the embedded hsqldb instance
(good luck !)

(2) is probably the easier of the two routes.

If you are not using the default hsqldb embedded database instance, then
I'm assuming you're using a proprer RDBMS which has triggers and that
you know how to use them.


To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.