To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105801 Issue #|105801 Summary|The nice bug. Please, extend. Component|Database access Version|OOo 3.1.1 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|villeroy
------- Additional comments from ville...@openoffice.org Sun Oct 11 08:27:58 +0000 2009 ------- Don't know how to classify this. It behaves as desired but not specified, in the wrong place though. In the attached HSQLDB table "Data" has duplicates of Name AND Value. "ViewDupes" gives an overview over duplicate entries. "ViewDeleteDupes" shows all but the latest duplicates which can be deleted with: DELETE FROM "Data" WHERE "ID" IN (SELECT "ID" FROM "ViewDeleteDupes"); The specified behaviour seems to be that all views are always read-only, even if they rely on a single table including the PK. At least this is what I got used to and "ViewDeleteDupes" gives a read-only record set. OK, open "ViewDeleteDupes" for editing and run the query for preview (menu:Edit>Run Query). The preview pane gives an editable row set where I can delete my duplicates in a GUI. I wish I could have editable row sets for regular use. --------------------------------------------------------------------- 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