[libreoffice-users] Re: LO Base - Query Question

Le 17/07/11 13:08, Ian Whitfield a écrit :

Hi Ian,

> When making a Query in LO Base how do you select the contents of a
> Tick-Box?
>
> ie I have a Tick-Box to indicate a particular class of people in my DB -
> so how do I make the Query select only Tick-Boxes that have a tick in them?

If you have a new question, please start a new thread instead of
"replying to", otherwise it makes it very difficult to follow what is
going on.

Anyway, a tick box should be linked to a Boolean field, so either your
query can contain any of the following SQL :

where 'fieldname' IS TRUE/FALSE
where 'fieldname' = 1/0

replace TRUE WITH FALSE or 1 with 0 as appropriate.

> From what I remember, a tick box can actually have 3 possible states (a)
deactivated (i.e. neither selected nor unselected), (b) selected (value
= TRUE or 0) and (c) unselected (value = FALSE or 1). You might like to
check whether that is actually the case though, because I might have got
TRUE and FALSE mixed up.

That is the theory, at least. The reality is that throughout various
versions of OOo prior to the existence of LibreOffice, boolean fields
linked to tick boxes sometimes behaved rather strangely, and did not
work as expected/intended. All I can say is try it out and see whether
it works as you wish.


Alex


-- 
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted