To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101700 Issue #|101700 Summary|query design view duplicates not visible coloumns when | change SQL/Design view Component|Database access Version|OOO310m11 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|ud
------- Additional comments from u...@openoffice.org Fri May 8 22:01:40 +0000 2009 ------- The query designer duplicates coloums if they not visible. Better, it put for every change between SQL view and Design view one of the not visible marked fields in the design view. To see what i mean, open the attached database. -go to Queries -open query "was_ist_das" to edit -click once to SQL view by click on "Design/SQL" in the toolbar and back to design view. => notice that the 3 coloumns like before -go to coloumn "JAHR" and uncheck the "visible" button of "Jahr" -click once to SQL view by click on "Design/SQL" in the toolbar and back to design view. =>in my case in design view has now 4 coloumns. "MONAT" and "JAHR" are marked not visible. -click once to SQL view by click on "Design/SQL" in the toolbar and back to design view. =>in my case in design view has now 5 coloumns. "JAHR" is duplicated For every switch between SQL view and Design view the coloum "Jahr" will be inserted again. But it is only the view, if you save the query it will stay right. --------------------------------------------------------------------- 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