To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108593 Issue #|108593 Summary|Base puts double quotes around keyword SYSDATE in quer |ry throws "invalid identifier" error. Component|Database access Version|OOO310m19 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|smithtv
------- Additional comments from smit...@openoffice.org Sat Jan 23 01:03:08 +0000 2010 ------- When running a query against an Oracle 9i database the product adds double quotes around key word SYSDATE causing Oracle to throw an ‘ORA- 00904: “SYSDATE”:invalid identifier’ error. Example: SELECT * FROM "A_TABLE" WHERE "THE_DATE" > SYSDATE is changed to: SELECT * FROM "A_TABLE" WHERE "THE_DATE" > "SYSDATE" :( --------------------------------------------------------------------- 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
