To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106524 Issue #|106524 Summary|Table wizard can't create table after adding, then rem |oving, a field Component|Database access Version|OOo 3.1.1 Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|rene
------- Additional comments from r...@openoffice.org Sun Nov 1 11:35:39 +0000 2009 ------- from http://bugs.debian.org/553578: Found in 3.1.1 by him, confirming it also happens in 3.0 beta. --- snip --- In the table wizard, when I add a field, then remove that field, the wizard is unable to later create the table in its final step. Steps to reproduce: * Open OpenOffice.org Base. * The “Database Wizard” opens at the “Select database” step. * Select “Create a new database”, then select “Next”. * The wizard proceeds to the “Save and proceed” step. * Select “No, do not register the database”. * Select “Create tables using the table wizard”. * Select “Finish". * The wizard prompts for a filename for the document. * Select an arbitrary document filename for the new document, then select “Save”. * The “Table Wizard” appears, at the “Select fields” step. * Select the sample table “Tasks”. * Select all available fields with the “>>” control. * Select “Next”. * The wizard proceeds to the “Set types and formats” step. * Select the “+” control to add a new field. * The new field is added to the list, named “Field”. * Select the new field, then select the “−” control to remove the field. * The field is removed from the list. * Select “Next”. * The wizard proceeds to the “Set primary key” step. * Select “Use an existing field as primary key”. * The “Fieldname” control becomes active. * Select the field named “TaskID”. * Select “Next”. * The wizard proceeds to the “Create table” step. * Select “Create a form based on this table”. * Select “Finish”. * An “OpenOffice.org Base” error dialogue appears, with the message: Unexpected token: in statement [CREATE TABLE "Tasks" ("Notes" LONGVARCHAR,"TaskID" INTEGER NOT NULL,"EndDate" DATE,"StartDate" DATE,"Description" LONGVARCHAR,""] * The wizard will not proceed; no matter what action is selected, the same error message appears. --- snip --- --------------------------------------------------------------------- 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org