To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=108229
User fs changed the following:
What |Old value |New value
================================================================================
Assigned to|dbaneedsconfirm |oj
--------------------------------------------------------------------------------
Target milestone|--- |OOo Later
--------------------------------------------------------------------------------
------- Additional comments from f...@openoffice.org Mon Feb 1 19:34:35 +0000
2010 -------
confirming:
- open the attached database document
- open the contained query by double-clicking it
=> the parameter input dialog opens
- enter a date value in the "Value" field
- press OK
=> you get an error message saying that this is no legitimate value for the
column
(which is wrong)
- enter a plain numeric value in the "Value" field
- press OK
=> the value is accepted
(which is wrong)
=> the query's data view opens, but you get an error message saying something
about an illegal type
fs->oj: I'd say the problem here is that the parser recognizes the parameter as
integer column, since the return type of DAYOFWEEK is an integer. It should,
however, recognize it as date column.
---------------------------------------------------------------------
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
