To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=91679 Issue #|91679 Summary|Oracle unhappy with AS before table alias, switch disa |bled Component|Database access Version|OOo 2.4.0 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|elmicha
------- Additional comments from [EMAIL PROTECTED] Tue Jul 15 18:07:35 +0000 2008 ------- Hi, I'm tyring to use an Oracle 10.2 database via the Oracle JDBC driver. Oracle does _not_ like an "AS" before table alias names, but Ooo insists on inserting that "AS". So every query created with the wizard fails to work with "ORA-0933: SQL command not properly ended". In Edit -> Database -> Advanced Settings there is an option called "Use keyword AS before table alias names". But alas it is enabled and grayed-out at the same time, so it has the wrong default value and I cannot change it. Can you please change the default value and/or not gray-out that checkbox? I'm aware that OOo 2.4.0 is not the latest and greatest, but I'm afraid I cannot test 2.4.1 or 3.0.0beta at the moment. Maybe you can look in 3.0.0beta and see if that checkbox is still enabled and grayed-out at the same time? Regards... Michael --------------------------------------------------------------------- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]