Pierre wrote:
James E. Lang wrote:
I'm trying to work with v1.9.125 to create a database. I'm finding
that fields defined as "Yes/No [ BOOLEAN ]" are not accepting a
default value of "Yes." I shift to another part of the display and the
default returns to "No." Sometimes the Length changes from one (1) to
zero (0) also though this is not consistent.
Has anyone else tried the database module and Yes/No fields within a
table?
I suspect the assigned value has to be one of TRUE, FALSE, -1, 1 or 0
The displayed value can probably be set to any reasonable string, like
"BLACK" for TRUE, "WHITE" for FALSE
In my experience the above holds for most database programming
environments.
Remember that the database engine in OOo is HSQLDB which is
written in 100% Java. In Java the Boolean type can only have
two values: True or False. In Java this does not equate to
True = anything > 0 and False = 0 or less like in most other
languages; just True or False.
--
Dale Erwin
Salamanca 116
Pueblo Libre
Lima 21 PERU
Tel. +51(1)461-3084
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
