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 a 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 make the Length.
If I remove these two fields, create the table, then edit the table to add the fields, then all is well.
Any ideas ??
I have filed an issue #55714

Moses

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to