Well, everything is in title... When I test a boolean field that contain no value (neither YES nor NO) with <> 1 (I suppose it's the same than NOT YES, LO returns FALSE.
Boolean fields in LO are tristate - unset, true or false, so perhaps you could try testing for "= -1" instead ?
(In reply to Alex Thurgood from comment #1) > Boolean fields in LO are tristate - unset, true or false, so perhaps you > could try testing for "= -1" instead ? Well, I don't exactly see what is the value -1 in this case...But, Sure I can test that, thanks
-1 is the unset state
@moebius : you don't say how you are testing the value : - directly as SQL tp the underlying table ; - via a form containing a control bound to a field ; - via macro with DatabaseContext. The results of the test might vary depending on which method you are using.
See also : https://forum.openoffice.org/en/forum/viewtopic.php?f=42&t=5251 We also need the LO version you are using (you didn't say which in your report), and whether or not you are using a distrib provided version of LO or the TDF download.
No info from OP for more than 6 months, setting as resolved insufficient data