To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=93692 Issue #|93692 Summary|SQL to Oracle Database prefixes alias with "AS" despit |e settings. Component|Database access Version|OOo 2.4.1 Platform|Unknown URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|blkline
------- Additional comments from [EMAIL PROTECTED] Tue Sep 9 22:18:47 +0000 2008 ------- I am using 2.4.1 to connect to an Oracle 9i database via JDBC. The connection to the DB is set as an Oracle JDBC connection. The trouble I'm having is that a query such as "SELECT A.FIELDA FROM TABLEA A" fails because OOo is converting it to read: SELECT A.FIELDA FROM TABLEA AS A". The "AS" before the alias is causing Oracle to choke. In the database Advanced Properties, Special Settings tab, Option "Use keyword AS before table alias names" is checked and greyed out (as noted in issue 93452) so I am unable to turn off that "feature." I have attempted to circumvent this by using the "Edit in SQL View" option, which from my reading of the documentation should pass my query directly to the database without modification. No joy there, either. The behaviour I describe has been verified by using wireshark to sniff the traffic between my box and the database server. Thinking that I some kruft from earlier versions may be responsible for this issue I decided to created a new user on my Linux box and create an entirely new database and link to the Oracle db. I still have the same problem. This problem has been on-again, off-again through the various versions of OO. The first version of OO that had the "Use keyword AS before table alias names" option fixed the problem. I don't recall having the problem with the 2.3 series but I'm sure experiencing it with 2.4.1. This is a real impediment to using OOo Base and apparently a regression from the 2.3 series. I read the "WORKSFORME" status of the aforementioned issue tracker (93452), but I've seen enough references to this issue in a Google search that I it to be a real bug. --------------------------------------------------------------------- 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]