To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110117 Issue #|110117 Summary|Turning off alias options in Advanced settings does n |ot remove aliased table name from SQL Component|Database access Version|OOO320m12 Platform|Unknown URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|ianst
------- Additional comments from ia...@openoffice.org Sun Mar 14 18:47:30 +0000 2010 ------- Using JDBC to define and access connection to an existing database. In advanced settings deselected "Append the table alias name on SELECT statements" - this automatically "unselected" use AS keyword option. In Create in Query Design View selected columns from a table and then viewed SQL The query generated after selecting the columns for the query looks as follows: SELECT "@ID", "CHEQUE", "BANK", "AMOUNT", "PERIOD" FROM "CHEQUES" "CHEQUES" While the "AS" is not included (deselected in Advanced settings) the table name "CHEQUES" is still aliased despite the setting in Advanced Settings. Amending the SQL to remove the redundant alias results in the query running as expected i.e SELECT "@ID", "CHEQUE", "BANK", "AMOUNT", "PERIOD" FROM "CHEQUES" Kind regards Ian Stuart --------------------------------------------------------------------- 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
