To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=77388 Issue #|77388 Summary|invalid SQL statement generated by open office Component|Database access Version|OOo 2.2 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|dughutch
------- Additional comments from [EMAIL PROTECTED] Tue May 15 11:48:16 +0000 2007 ------- Issue reading tables through an ODBC driver, submitted question to Qantel support who appears to have diagnosed the issue. Would appear to be a simple fix (I am not a coder...;) Details below ----------Initial email---------- To: Qantel - Technical Support Department Subject: Qantel ODBC connection works with Excel but having issues with Open Office I'm writing to inquire about utilization of the ODBC driver. It is installed and works with Excel (via the Query Wizard) but when attempting to set up through Open Office, although it allows me to set up the connection, and tests as connecting successfully, I seem to have no access to the data... Any ideas, please? ----------Initial email---------- ----------Qantel Response---------- The issue stems from an invalid SQL statement generated by open office. The statement: SELECT TABLE_QUALIFIER, TABLE_OWNER, TABLE_NAME, TABLE_TYPE, REMARKS FROM OA_TABLES WHERE TABLE_NAME LIKE '%' AND (TABLE_TYPE LIKE 'VIEW' OR TABLE_TYPE LIKE 'TABLE' OR TABLE_TYPE LIKE '%' ORDER BY TABLE_TYPE,TABLE_QUALIFIER,TABLE_OWNER) is used to request a table list. Note the incorrect placment of the ) character that should be framing the precedence of the AND and OR WHERE conditions. The query should be: SELECT TABLE_QUALIFIER, TABLE_OWNER, TABLE_NAME, TABLE_TYPE, REMARKS FROM OA_TABLES WHERE TABLE_NAME LIKE '%' AND (TABLE_TYPE LIKE 'VIEW' OR TABLE_TYPE LIKE 'TABLE' OR TABLE_TYPE LIKE '%') ORDER BY TABLE_TYPE,TABLE_QUALIFIER,TABLE_OWNER Qantel Support. ----------Qantel Response---------- --------------------------------------------------------------------- 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]