To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87514
------- Additional comments from [EMAIL PROTECTED] Wed Apr 2 21:06:20 +0000 2008 ------- For the record (and for myself when later reading this): The field in question is marked as required in the table definition. Unfortunately, our table data view is always set up in a way (API-wise: "EmptyIsNull" property) that when you don't enter text in a column, this is interpreted as the dedicated "null" value (means: "no value"), not as "empty string" (which is different from "null"). "Required" means: "null" is not allowed, but "empty string" is. (Side note: Thus, the manual SQL update works fine - it updates the column as "empty string" not as "null".) One solution would be to set up the table data view so that columns which are marked as required in the table definition never update "null", but always "empty string", when no text is entered. However, that's not the complete story. A quick check shows that in this case, still something goes wrong in the ADO driver. This needs further investigations. --------------------------------------------------------------------- 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]
