To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=93457 Issue #|93457 Summary|table controls with check boxes bound to a non-NULLabl |e column must not allow the "indetermined" state Component|Database access Version|OOO300m3 Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|fs Reported by|fs
------- Additional comments from [EMAIL PROTECTED] Thu Sep 4 08:26:53 +0000 2008 ------- - open the attached database document - open the contained form, or the contained table, by doubling it - in the table data view (resp. in the table control within the form), there's a check box column which is bound to a table field which is declared as NOT NULL (aka "Entry Required" = "Yes" in the table designer) - repeatedly click onto the check box in the current row, cycling through its possible values this way => the cycle is "checked", "undetermined", "not checked" The "undetermined" state does not make sense at all, in case the bound table column is required - in such a case, trying to update the row will result in an error message from the database. Well, that's not completely true. There's one case where it could make sense to use an "undetermined" value for the check box: If there is a server-side default value for this table column. However, comparing how often users are confused/annoyed by a checkbox which wrongly allows NULL values, with how often there are server-side defaults for boolean columns, and considering that in such a case the easy workaround would be to simply set the respective default value in Base's table design, too, I'd say that changing the current behavior is the better alternative. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
