To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=93692
------- Additional comments from [EMAIL PROTECTED] Thu Sep 11 14:28:54 +0000 2008 ------- If I start with a fresh base doc and follow the steps you list below, I am unable to make this fail at all. Everything works just fine. If I follow these steps, starting with a fresh database, I can make this fail at will: 1) Start OOo Base and get the "Database Wizard." 2) Select "Connect to an existing database -> Oracle JDBC" 3) Fill in the blanks to point to the DB server 4) Select the icon for "Database Queries" 5) Select Query in SQL View 6) Create a simple "SELECT A.FIELD1 FROM TABLE1 A" and run it. As expected, you'll get the error due to the "AS" prefix to the alias. 7) Select "Run SQL command directly" and try to "Run Query" again. (note that in the SQL DDL there is NO "AS" ) -- You'll get the same error. This indicates that OOo is touching the code in spite of "Run SQL command directly." 8) Now go into the Database->Advanced Properties->Special Settings tab and select "Append the table Alias Names" checkbox. Uncheck "Use keyword AS before table alias names" 9) Try the query again. (For good measure, I even closed the query in the first try and created a new one.) You get the error. 10) Select "Run SQL command directly" and then run the query. You get the same problem. In summary, it appears as though you're okay if you start with the Advanced Settings set up before you even begin but once you have started working with the "Append the table Alias Names" checkbox checked, there is no way to undo it and make it. As a final test, I saved the query and the database doc and then closed and reopened the document. This time, it worked both with and without "Run SQL command directly". So what is happening is that the properties on the Advanced Settings tab" that were modified after the query was created are not being propagated through the program unless the document is saved, closed and reopened. Saving the query (while keeping the db doc open) and reediting it is not sufficient. Thanks again for your time! --------------------------------------------------------------------- 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]
