To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=56912 Issue #:|56912 Summary:|A "TO_DAYS(NOW())..." is not correctly handled by OOo |SQL preprocessing Component:|Database access Version:|OOo 2.0 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:|cianoz
------- Additional comments from [EMAIL PROTECTED] Sat Oct 29 01:57:32 -0700 2005 ------- I refer to a MySQL query but i guess the problem is the same with other dbs. If you use a condition like the following in the WHERE clause of a SQL query OOo doesn't understand it correctly if you use the "Design View" The condition is: WHERE TO_DAYS(NOW())- TO_DAYS(movim.date) <= 365 If you use the Design View OOo create a column for it where the title is "TO_DAYS(NOW())- TO_DAYS(movim.date)" and the Criterion is "<= #30/12/1900#" If you start creating the query in Design View it looks like initially you can do a regular query, but after saving the query and the document after you try to edit the query again you find it has been modified as above by the OOo SQL preprocessor An SQL query with this condition is correctly handled only if run in "Direct mode" --------------------------------------------------------------------- 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]