To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92471 Issue #|92471 Summary|"Empty Field is NULL" = "No" is not respected for cont |rols unless you touch them Component|Database access Version|OOo 2.4.1 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] Tue Aug 5 11:42:33 +0000 2008 ------- - 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 --------------------------------------------------------------------- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
