| View previous topic :: View next topic |
| Author |
Message |
cyberwuffy
General User
Joined: 12 Sep 2004
Posts: 37
Location: Corneria
|
 Posted: Sun Apr 01, 2007 4:09 pm Post subject: field formatting in all caps |
 |
|
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 |
|
 |
DrewJensen
Super User
Joined: 06 Jul 2005
Posts: 2616
Location: Cumberland, MD
|
| Posted: Sun Apr 01, 2007 6:41 pm Post subject: |
|
|
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 |
|
|
cyberwuffy
General User
Joined: 12 Sep 2004
Posts: 37
Location: Corneria
|
| Posted: Mon Apr 02, 2007 9:00 am Post subject: |
|
|
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 |
|
|
|
