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

Boolean value display...

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


Joined: 26 Feb 2009
Posts: 5

PostPosted: Sun Mar 01, 2009 9:22 pm    Post subject: Boolean value display... Reply with quote

Hey,

Thanks for the prior help with the mainform/subform linking (sorry I asked a redundant question).

The whole reason I started looking into it was because I wanted to get around the horribly designed boolean value display on forms. It's either a check, a grayed-out check, or nothing, which is somewhat misleading. I was looking to parse it to show each value as Yes/No, based on its boolean value, but I'm not sure how to go about this...

Again, thanks for the help!
Back to top
View user's profile Send private message
r4zoli
Super User
Super User


Joined: 17 May 2005
Posts: 570
Location: Budapest, Hungary

PostPosted: Mon Mar 02, 2009 12:29 am    Post subject: Reply with quote

The boolean types in SQL, using more than True and False, exist a third state UNDEFINED, see HSQLDB documentation, and it is supported in that way.

More on Boolean on Wikipedia.
Back to top
View user's profile Send private message
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