[libreoffice-users] Re: Trimming Whitespace on Save

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

or

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.


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