Product: Database Access
Type: changed
Title: "Empty string is NULL" behavior refined
Posted by: [EMAIL PROTECTED]
Affected: -
TaskId: i90403
<http://www.openoffice.org/issues/show_bug.cgi?id=90403>
Effective from: CWS dba31e
CWS:
<http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300/dba31e>
CWS status: new
*Flags*
-------
API/ BASIC [ ]
Configuration [ ]
File format change [ ]
Help/ Guide [x]
Performance test [ ]
Translation [ ]
UI relevant [ ]
*Description*
-------------
In the course of fixing issue 90403 and issue 92471, the behavior of
form controls whose "Empty string is NULL" property is set to "Yes"
has been refined. This change might make existing forms behave
slightly different than before, but certainly more
expectation-conformant now.
First, the property is now also respected when you never touched the
respective control before saving the record. That is, imagine a
control which has this property set to "Yes", this way declaring that
if the control contains an empty string, then this should be
propagated to the database as (the dedicated) NULL value.
Formerly, when you moved to the insertion row of the form, so the
control was initially empty, entered some data into other controls of
the current record, and saved the record without actually touching the
first control, then it actually updated an empty string. Now, with the
change, it updates NULL, as this is what "Empty String is NULL" =
"Yes" requests.
Second, when a control was bound to a database column which was
declared as NOT NULL, then the control *always* updated an empty
string instead of NULL, no matter what its "Empty string is NULL"
property requested. Effectively, this killed server-side defaults of
database fields, as such defaults are only applied when the field is
NULL. Now, with the change, controls always update NULL in such a
setup, this way enabling server-side defaults.
Send feedback to [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
