To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=91192 Issue #|91192 Summary|Query : cannot save “NOT LIKE” criterion Component|Database access Version|OOo 3.0 Beta 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|py_samyn
------- Additional comments from [EMAIL PROTECTED] Sun Jun 29 10:35:33 +0000 2008 ------- Create a query in design view with the criterion NOT LIKE. For instance : NOT LIKE 'J*' Save the query. After reopening in “edit view” the criterion becomes 'J*' In SQL view : SELECT "ID", "Name" FROM "Table1" WHERE NOT "Name" LIKE 'J%' To make things worse : when opening the query (without edit first), the dataset is ok (as expected with “not like”) edit the query in SQL view (syntax as above), run the query, the dataset is also ok (as expected with “not like”) edit the query (not in SQL view), run the query, the dataset as expected with 'J*' (but not LIKE 'J%') Nota : Same symptom when using Form-Based Filters Same in 2.4.1 --------------------------------------------------------------------- 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]
