To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110117
------- Additional comments from ia...@openoffice.org Tue Mar 16 17:01:31 +0000 2010 ------- Thank you kindly for following up on this. Possibly refer to other issues where this has been reported - I'll have a look at all the references made in regard to aliasing and the responses as soon as I have a chance - but aliasing is something that has come up quite often and solutions have pointed to Advanced Settings and setting the aliasing options as described in this issue. Please have a look at Advanced Settings in OOBASE - There are two options related to the use of aliased table names which work in conjunction with each other. By default on defining a new database, the options "Append table alias name on SELECT statements " and option "use keyword AS before table names" are checked. If you uncheck the "Append table alias name on SELECT statements" then the "Use keyword AS before table names" is also unchecked. This would imply that unchecking these options will no longer result in table names being appended to queries as aliases, and secondly, that the "AS" keyword will also not be used (quite logical - if you are not appending table aliases to queries then you won't need the "AS" option) . If you only "uncheck" the "AS" option then the implication is that the "AS" keyword will not be used in statements but that table aliases will be appended. The purpose of these two options, as far as I can determine from other postings and from a logical observation, is to allow for the turning off of aliasing either completely or to just remove the "AS" option - otherwise why would the two options be available. It would seem to be at least inconsistent if not a defect. Rgds Ian --------------------------------------------------------------------- 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