| View previous topic :: View next topic |
| Author |
Message |
idleranger
Newbie
Joined: 31 Jul 2007
Posts: 2
|
 Posted: Tue Jul 31, 2007 12:10 pm Post subject: [Solved} Query on Boolean Field |
 |
|
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 |
|
 |
DrewJensen
Super User
Joined: 06 Jul 2005
Posts: 2616
Location: Cumberland, MD
|
|
| Back to top |
|
|
idleranger
Newbie
Joined: 31 Jul 2007
Posts: 2
|
| Posted: Wed Aug 01, 2007 7:00 am Post subject: [Solved] Query on Boolean Field |
|
|
| 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 |
|
|
|
