To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=86169 Issue #|86169 Summary|Allow tables to be aliased in GUI query designer Component|Database access Version|current Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|atjensen
------- Additional comments from [EMAIL PROTECTED] Mon Feb 18 05:17:46 +0000 2008 ------- Open the the bugdoc attached to Issue #: 73627 Open any of the queries Now ask yourself "How would I create these using the Query Designer?" The situation is that you can not - if you added the persons table twice the designer would create "persons" and "persons_1". There is no support for actually setting the alias for the tables as there is for columns, You could switch the designer off and then in the SQL view change the table aliases, but by the time the query is complicated enough that it is a problem, this becomes a problem. There seems three obvious ways to add this enhacnement: One support a Find & Replace function when in SQL view mode. Two add a popup menu for the table objects with "Rename" or "Alias" Three support in-place editing of the table object name. Of course a combination of One and Three would be real nice. --------------------------------------------------------------------- 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]
