To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=64981 Issue #:|64981 Summary:|SQL Parser DEFECT - unusable Component:|Database access Version:|OOo 2.0.2 Platform:|All URL:| OS/Version:|Linux Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P1 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|jojoax
------- Additional comments from [EMAIL PROTECTED] Mon May 1 20:22:59 -0700 2006 ------- This Statement is comletely correct and works fin, but is _NOT_ accepted from OOo Base: SELECT ZEIT,LOGTEXT FROM OL_SYSTEMLOG WHERE TIMEDIFF(TIMESTAMP, ZEIT) < '01:00:00' It is impossible to execute, save or use this correct within OOo Base. This Scenario occurs for: Linux + unixODBC (Statement works in isql) Database: MySQL MaxDB, SapDB, Adabas D, Oracle et al. My Suggestion do not parse SQL Statements by OO itself, use the DB engine to do so, using the ODBC prepare call. it must be possible to: - save - execute - use such a statement --------------------------------------------------------------------- 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]
