[libreoffice-users] Re: How to format data entry in base table to UPPERCASE only
Am 14.04.2012 07:57, Mark Stanton wrote: Which is also to say that the input filters you're expecting don't exist in Base. Regards Mark Stanton One small step for mankind... In this case a form related macro solution might be simple, I guess. -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: How to format data entry in base table to UPPERCASE only
Am 14.04.2012 16:38, Mark Stanton wrote: Having said all of that, it doesn't exist in Base (yet :-) ). Sure, it does exist. It's called pattern field: http://user.services.openoffice.org/en/forum/viewtopic.php?f=61t=10132p=47451hilit=input+mask+literal#p47451 A macro solution could convert any lower case input to upper case before the record gets stored. -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: How to format data entry in base table to UPPERCASE only
Am 13.04.2012 17:42, leon244 wrote: I am trying to find a way to format the text fields in my small data base to be uppercase only. Is there a way to do it at the table field level with the 'format', or can it only be done at the form level through a pattern field using 'X'? -- View this message in context: http://nabble.documentfoundation.org/How-to-format-data-entry-in-base-table-to-UPPERCASE-only-tp3908311p3908311.html Sent from the Users mailing list archive at Nabble.com. Since 'x' and 'X' are different characters, this has nothing to do with formatting. Set the field type to VARCHAR_IGNORECASE so 'x' and 'X' are considered as equivalent. In queries you can use the UCASE or UPPER function in order to display the upper case version of the text. -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: How to format data entry in base table to UPPERCASE only
On Fri, 2012-04-13 at 17:49 +0200, Andreas Säger wrote: Am 13.04.2012 17:42, leon244 wrote: I am trying to find a way to format the text fields in my small data base to be uppercase only. Is there a way to do it at the table field level with the 'format', or can it only be done at the form level through a pattern field using 'X'? -- View this message in context: http://nabble.documentfoundation.org/How-to-format-data-entry-in-base-table-to-UPPERCASE-only-tp3908311p3908311.html Sent from the Users mailing list archive at Nabble.com. Since 'x' and 'X' are different characters, this has nothing to do with formatting. Set the field type to VARCHAR_IGNORECASE so 'x' and 'X' are considered as equivalent. In queries you can use the UCASE or UPPER function in order to display the upper case version of the text. Howdy, Right - well the VARCHAR_IGNORECASE is fairly specific to HSQLdb, but it works well. You may also create an update trigger, using an SQL command via the SQL window, to cast all input to upper case before it is written into the data field - for any relational database engine used by Base, including the embedded HSQLdb engine, the syntax varies a bit from engine to engine however. //drew -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: How to format data entry in base table to UPPERCASE only
Thank you both. -- View this message in context: http://nabble.documentfoundation.org/How-to-format-data-entry-in-base-table-to-UPPERCASE-only-tp3908311p3908612.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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