To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=52919 Issue #:|52919 Summary:|Cannot create "boolean not null" column with HSQL Component:|Database access Version:|OOo 2.0 Beta Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|johnix
------- Additional comments from [EMAIL PROTECTED] Thu Aug 4 14:22:31 -0700 2005 ------- In an embedded HSQL database, when editing a table in Design view, if I create a boolean (yes/no) field with "entry required" set to "Yes" (thus creating a 2-state column), when saving, I get the following pop-up box : "Error while connecting to the datasource." "Column constrains are not acceptable in statement [ALTER TABLE "Table1" ADD "check" BOOLEAN NOT NULL]". If I create a boolean column, save, and then set "entry required" to "Yes", I get the following message : "The column "foobar" could not be changed. Should the column instead be deleted and the new format appended?" I encountered this problem on m122. --------------------------------------------------------------------- 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]