Product: Database Access
Type: new
Title: form controls: new property "Input Required"
Posted by: [EMAIL PROTECTED]
Affected: -
TaskId: i92322
<http://www.openoffice.org/issues/show_bug.cgi?id=92322>
Effective from: CWS dba31e
CWS:
<http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300/dba31e>
CWS status: new
*Flags*
-------
API/ BASIC [x]
Configuration [ ]
File format change [ ]
Help/ Guide [x]
Performance test [ ]
Translation [x]
UI relevant [x]
*Description*
-------------
All form controls which can be bound to a database column (i.e. have
the "Data field" property) now have a new property called "Input
required".
Description
=========
This property controls whether or not the input of this field is
checked against being empty (NULL). It is evaluated for controls which
are bound to a database field which is defined as required (i.e. which
is not allowed to contain the special NULL value), immediately before
the current record of the form is to be written into the database.
If the property is set to "Yes", and the field contains no input when
the current record is to be written to the database, then an error
message will be shown to the user, and the respective control will be
focused afterwards. Note that this is the known behaviour so far - the
property defaults to "Yes" so that newly created controls behave as
they would do in previous OOo versions.
If the property is set to "No", and the field contains no input when
the current record is to be written to the database, then this is
ignored. It's up to the underlying database to either reject the
update, or fill the respective column with a server-side default value.
Functional Constraints
=================
If the "Form data input checks for required fields" option in the
advanced settings of the database document (Edit / Database / Advanced
Settings ...) is *not* checked, then the "Input required" property for
all controls in all forms in this database document does not have any
effect, since the document-wide setting overrules the per-control
settings.
UI
==
In the property browser, the "Input required" is located immediately
below the "Empty string is NULL" property, if it is present, otherwise
immediately below the "Data field" property.
If the "Data field" is not set (i.e. empty), then "Input required" is
disabled, since it would be evaluated for bound controls only, anyway.
If the "Empty string is NULL" is set to "No", then "Input required" is
also disabled, since "Empty string is NULL" being "no" implies that
when the user does not enter any value in the control, then an empty
string, instead of the dedicated value NULL, is written, so there's
always a non-NULL value no matter the user's action.
Send feedback to [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
