To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=55714 Issue #:|55714 Summary:|New Database Field creation error Component:|Database access Version:|OOo 2.0 Platform:|All URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|mosesau
------- Additional comments from [EMAIL PROTECTED] Sun Oct 9 23:58:03 -0700 2005 ------- I have just installed the current OOo 2.0 release. I opened "Database" and started creating a new database and tables using the wizard. I created the table "Personal" "Plants" but, in step 4, I got the error ... "column size is required in statement [CREATE TABLE ........." The offending fields were "Notes" (Memo [LONGVARCHAR], Length = 2147483647) and "Photo" (Image [LONVARBINARY], Length = 2147483647). Removing these, or changing their field type, allows me to create the table. I cannot find where to change the Length. If I remove these two fields, create the table, then edit the table to add the fields, then all is well. --------------------------------------------------------------------- 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]