To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=104023
User fs changed the following:
What |Old value |New value
================================================================================
Assigned to|dbaneedsconfirm |fs
--------------------------------------------------------------------------------
Ever confirmed| |1
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
OS/Version|Linux |All
--------------------------------------------------------------------------------
Priority|P3 |P4
--------------------------------------------------------------------------------
Platform|PC |All
--------------------------------------------------------------------------------
Summary|Field Properties in Form D|Cannot re/set "Input requi
|esign |red" property when "Empty
| |string is Null" is "No"
--------------------------------------------------------------------------------
Target milestone|--- |OOo Later
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Wed Aug 12 13:19:06 +0000
2009 -------
Indeed, the *runtime* checks for the value of the InputRequired property, and
ignores the "Empty is NULL" property. Speaking strictly, this is correct: "Empty
is Null" is evaluated at the time a modification you do to the control is
committed to the database row (which is usually the case when you un-focus this
control).
The runtime check, however, is made *after* that, it it checks the database row
(before it is actually sent to the database) for fields which are NULL though
required. For any such field, if there is a control bound to it, which does have
"Input Required" set to "Yes", the runtime complains.
(In particular, if you travel to a new record, then the "Empty is Null" property
is *never* evaluated, as there's no user input to transfer to the database row.)
Design-wise, the "bug" is that "Input Required" is a per-control property,
instead of a per-database-field property. In the latter case, you could tell OOo
that for any control ever bound to that field, input is not required - once and
for all (instead of once for every control).
However, adding such client-side per-field properties is difficult for various
reasons, so it's a control property now.
The second bug is that "Empty is Null" has an influence on "Input Required"'s
enabled/disabled state. As explained above, both apply in different scenarios.
Perhaps the most feasible fix indeed is to simple remove that dependency in the
property browser.
---------------------------------------------------------------------
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]
