To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=75802 Issue #|75802 Summary|Forms should not use NOT NULL attribute to return Requ |ired message box Component|Database access Version|OOo 2.1 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|odaata
------- Additional comments from [EMAIL PROTECTED] Wed Mar 28 05:49:29 +0000 2007 ------- When designing databases, I try to make sure text fields never have a NULL value, so code and queries are much less complicated and less error prone, so if a field is optional for the user, I set it to NOT NULL with a DEFAULT ''. This does not work in Base however, because the forms will not allow the user to leave a field blank if it is a NOT NULL field. The only workaround for this is to remove the NOT NULL constraint, but that opens your data up to possible NULL values - see the issue on the 'Empty String is NULL' property (75799). When adding new records, Base should only submit fields that the user has changed. Then the DB will fill in any defaults or return an error if a field is required. You could also allow people to set a default of '' in the metadata for the table (Edit table view) and then use that for updates as well. This is a fundamental requirement for DBs in general and MS Access handles this really well (with a nice description of it in their help file). Thanks, Mike Olson --------------------------------------------------------------------- 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]