To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=44320 Issue #:|44320 Summary:|Problem creating unique index/primary key manually Component:|Database access Version:|OOo 2.0 Beta Platform:|All URL:| OS/Version:|Windows 2000 Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|msc Reported by:|rudolfcardinal
------- Additional comments from [EMAIL PROTECTED] Mon Mar 7 02:39:17 -0800 2005 ------- Within OOo 2.0 beta (build 1.9.79): 1. Create a new table (e.g. Design view). 2. Close/save the table, *refusing* the offer to create a primary key. At this point, records cannot be entered (no primary key). 3. Edit the table design again; choose Index Design. PROBLEM: Even if you tick the "Unique" field for a new or pre-existing index in the Index Design dialogue box, this change to the "uniqueness" doesn't appear to be saved (even though the program asks "Do you want to save changes made to the current index?"). Consequently, you can't create a primary key or enter records. SUB-PROBLEM, perhaps: When an index is created in the Index Design table view, it has the default name of "Index1". It seems impossible to create an index actually called "Index1" - the following SQL error is generated: SQL Status: S0011 Error code: -23 Index already exists in statement [CREATE INDEX "index1" ON "Table3"] My guess is that the dialogue box creates the index (defaulting to the name Index1) for the user to fill in values (e.g. which fields are being indexed), saves this index called "Index1" in the database before the user has chosen the fields to index, and then forgets that it's done so, so when it tries to resave the user's changes, the database complains. --------------------------------------------------------------------- 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]
