To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114566 Issue #|114566 Summary|query wizard: cannot set (anymore) conditions other th |an "equal" Component|Database access Version|OOo 3.3 Beta 1 Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|oj Reported by|fs
------- Additional comments from [email protected] Fri Sep 17 08:55:21 +0000 2010 ------- - open the attached database document - select "Queries" on the left hand side - select "Use Wizard to Create Query" in the task pane - in the query wizard - on the first page, move all fields to the right - advance to the "Search Conditions" page - in the first condition, select "names.ID" as field, and "is not equal to" as condition. Enter an arbitrary numeric value in the "Value" field - advance to the "Overview" page => note that it says "Search conditions: ID is not equal to <> 3" - this is already strange - finish the wizard => you get an error message saying something about a syntax error in SELECT "names"."ID" AS "ID", "names"."name" AS "name" FROM "names" "names" WHERE ("names"."ID" <> <> 3) (Well, that error message is right) => the query is not created This happens with all conditions except equal, not/like, not/null --------------------------------------------------------------------- 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]
