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

[Solved} Query on Boolean Field

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


Joined: 31 Jul 2007
Posts: 2

PostPosted: Tue Jul 31, 2007 12:10 pm    Post subject: [Solved} Query on Boolean Field Reply with quote

I have a simple database that contains several Boolean field types. I have a query that counts the rows when a 'TRUE' condition exists. This worked fine on previous OOo Base version (2.2.0). I am currently running 2.2.1 and now the query doesn't work. I am also running JRE 1.6.0_02.

I tried writing a new simple query but this also failed. It seems there has been a change to the table and how it interprets Boolean expressions.

Any suggestions? Thank you.


Last edited by idleranger on Wed Aug 01, 2007 8:12 am; edited 1 time in total
Back to top
View user's profile Send private message Yahoo Messenger
DrewJensen
Super User
Super User


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

PostPosted: Tue Jul 31, 2007 12:12 pm    Post subject: Reply with quote

Any chance you can list the actual query statement?
_________________
Blog - http://baseanswers.spaces.live.com/
Back to top
View user's profile Send private message Send e-mail Visit poster's website
idleranger
Newbie
Newbie


Joined: 31 Jul 2007
Posts: 2

PostPosted: Wed Aug 01, 2007 7:00 am    Post subject: [Solved] Query on Boolean Field Reply with quote

The problem occurred when I copied the database to another computer using the newer release. The Boolean expression options were 'yes' = checked, 'no' = blank and , <none> = shaded. The <none> or shaded boxes in the table did not appear after the copy. Once I changed the boxes, the query ran correctly.
Back to top
View user's profile Send private message Yahoo Messenger
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