https://bugs.freedesktop.org/show_bug.cgi?id=69554
Priority: medium
Bug ID: 69554
Assignee: [email protected]
Summary: EDITING: Optionsfield in forms don't work with 1/0
connected to a boolean field, works only with
true/false
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.1.0.0.beta1
Component: Database
Product: LibreOffice
Created attachment 86119
--> https://bugs.freedesktop.org/attachment.cgi?id=86119&action=edit
Database with two forms: One is connected to boolean field with 1/0, the other
with true/false
In a form an optionsfield is connected to a boolean field of a table. The
attachment shows this boolean field as "Swimmer".
"Yes" is connected to '1', "No" is connected to '0'.
The values aren't shown any more since 4.1.0.0beta1.
Since this version you have to change the options to 'true' and 'false'.
If you start a query and want to select the "Swimmer", the following works:
SELECT "Name", "Swimmer" FROM "Table" WHERE "Swimmer" = 1
This works in the GUI and also, when the query is started in direct SQL-mode.
So this is only a bug of the options-field.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
