Apache OpenOffice (AOO) Bugzilla – Issue 92471
"Empty Field is NULL" = "No" is not respected for controls unless you touch them
Last modified: 2017-05-20 10:33:52 UTC
- open the attached database document - open the contained form for editing - put the focus into the "remarks" control, enter some text - press the "Save Record" button in the toolbar => an error message pops up saying that the value for column "name" cannot be NULL The appearance of this error message is actually wrong. Two setups have been made to the database which are expected to prevent it: - The "Form data input checks for required fields" option for the complete database has been set to FALSE (see Edit/Database/Advanced) - The "Empty Field is NULL" property for the edit control which is used to input values for the "name" column has been set to "NO". - (The "name" column is declared to be NOT NULL) Because of the first option, the form controller is expected to *not* check for required fields (which works fine, the error message comes from the back-end, not the front-end). Because of the second option, the edit control is expected to write an empty string into the database, not the NULL value. Obviously, this is the point which does not work. To verify this: Enter a new record, with "name" *not* being empty. After you saved this record, change name's edit control to be empty, then save the record => Base properly writes the empty string, instead of NULLL
Created attachment 55561 [details] document to reproduce the bug case
fixed in CWS dba31c (also for combo boxes, formatted fields, and pattern fields - they all have the "Empty Field is NULL" property, too). Added test case to integration.forms.FormControl test, to ensure it doesn't re-appear.
fs->msc: please verify in CWS dba31e
verified in CWS dba31e find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdba31e
This issue is closed automatically and wasn't rechecked in a current version of OOo. The fixed issue should be integrated in OOo since more than half a year. If you think this issue isn't fixed in a current version (OOo 3.1), please reopen it and change the field 'Target Milestone' accordingly. If you want to download a current version of OOo => http://download.openoffice.org/index.html If you want to know more about the handling of fixed/verified issues => http://wiki.services.openoffice.org/wiki/Handle_fixed_verified_issues
Sorry this issue was wrongly closed. This issue will be reopened automatically. And will be set after that back to fixed/verified.
Set to state 'fixed'.
Set back to state 'verified/fixed'. Again. Sorry for the mass of mails.