Field type [Yes/No] boolean

Creating tables and queries

Field type [Yes/No] boolean

Postby veer » Wed Feb 02, 2011 3:41 am

I am using Openoffice data base for the first time. I created a database and using to keep a track of the work done. Now, I have a problem with the field type [yes/No] Boolean. I have attached a image file of how it looks like when opened in a different computers. The first row first column in base 1 is same as the first row first column of the base2, but it is really confusing to use it that way (The blue solid block is replaced by the grayed out checked box in other). Is there a setting where I can change it ? I have tried everything I can, but could not findout. Any suggestions? and yes, we are using the same version (open office 3.2 on all the computers)

Copied base1 image from the reply of villeroy (moderater) from viewtopic.php?f=42&t=5251&start=0
Attachments
base 2.jpg
base 2.jpg (7.32 KiB) Viewed 2665 times
base 1.jpg
base 1.jpg (7.76 KiB) Viewed 2665 times
Last edited by veer on Wed Feb 02, 2011 7:03 am, edited 1 time in total.
Open office version 3.2 ans the Operating system being used is windows 7
veer
 
Posts: 2
Joined: Wed Feb 02, 2011 3:15 am

Re: Field type [Yes/No] boolean

Postby DACM » Wed Feb 02, 2011 5:47 am

veer wrote:...The database created is saved in a shared folder and every one of us use it.

If you're using an "Embbeded database" among several users simultaneously from a shared folder, then you're going beyond the design of that particular configuration. In that case, there's no fix because the follow-on users are limited to read-only database access -- which is reflected in various ways such as graying-out fields, controls, etc. In this case, the tri-state checkbox (Null, True, False) is most likely working according to design.

But there is a fix, if you're so inclined. I'm betting you'll get a consistent view (the dark blue bubble for Null checkboxes) when all users have read/write access to the underlying HSQL database. See the links in my signature block for information on migrating to a robust, client-server configuration for multi-user, read/write access.

Either way, make sure you're keeping regular backups because multi-user access to an "Embedded database" is the most risky (data-wise) approach we've seen in the forums.
AOO 4.0.x; LO 4.1.x; Windows 7 64-bit
Wizard: Automated 'split' HSQL database template; Warning: Avoid embedded databases
Soli Deo gloria
User avatar
DACM
Volunteer
 
Posts: 1068
Joined: Tue Nov 03, 2009 7:24 am

Re: Field type [Yes/No] boolean

Postby Villeroy » Wed Feb 02, 2011 8:47 am

The boolean fields in the screenshots are triple-state. They can take 3 different values: On, Off and Null (empty). Make the field mandatory (not nullable) and the field will be on or off only.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 12.04, Apache OpenOffice 4.x
User avatar
Villeroy
Volunteer
 
Posts: 17285
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Field type [Yes/No] boolean

Postby veer » Wed Feb 02, 2011 5:36 pm

Hey Villeroy, I want it to be triple-state with null as blue bubble.

Thanks DACM for the links..Will look in to it.
Open office version 3.2 ans the Operating system being used is windows 7
veer
 
Posts: 2
Joined: Wed Feb 02, 2011 3:15 am


Return to Tables & Queries

Who is online

Users browsing this forum: No registered users and 4 guests