OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

field formatting in all caps

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
cyberwuffy
General User
General User


Joined: 12 Sep 2004
Posts: 37
Location: Corneria

PostPosted: Sun Apr 01, 2007 4:09 pm    Post subject: field formatting in all caps Reply with quote

this is probably a stupid question as the feature/convenience I hope to find is from M$ access, but is there a way to keep all the text in caps without having to enter everything in caps all the time?
_________________
Best Wishes,
Cyberwuffy Ala Wolfe

Sysinfo:
Debian Linux; OO 2.3
Back to top
View user's profile Send private message Send e-mail AIM Address
DrewJensen
Super User
Super User


Joined: 06 Jul 2005
Posts: 2616
Location: Cumberland, MD

PostPosted: Sun Apr 01, 2007 6:41 pm    Post subject: Reply with quote

How about an answer of - yes, no and there is another option.

Yes - If you want to insure that all data entering the tables is in uppercase then you would create a trigger for each table that would do that whenever the data is written to it. In the case of an embedded Base file this means creating the trigger in java - the HSQLdb users manual covers the format for this trigger and the web site offers the code you need.

No - there is no simple flag you set telling Base to make everything uppercase.

The other way - if you are wanting to do this so that you never have to worry about case sensitive issues when searching for records then HSQLdb offers a data type of varchar_caseinsensitive. If you declare your text fields of this type then you don't need to force anything to uppercase at all.

Drew
_________________
Blog - http://baseanswers.spaces.live.com/
Back to top
View user's profile Send private message Send e-mail Visit poster's website
cyberwuffy
General User
General User


Joined: 12 Sep 2004
Posts: 37
Location: Corneria

PostPosted: Mon Apr 02, 2007 9:00 am    Post subject: Reply with quote

wow. ok. :3 It's an embedded file. You got the link?
_________________
Best Wishes,
Cyberwuffy Ala Wolfe

Sysinfo:
Debian Linux; OO 2.3
Back to top
View user's profile Send private message Send e-mail AIM Address
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group