Issue 22582 - Query Design - SQL View does NOT LIKE WHERE NOT
Summary: Query Design - SQL View does NOT LIKE WHERE NOT
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: OOo 2.4
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-11-18 00:59 UTC by jhansonxi
Modified: 2008-02-18 01:57 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description jhansonxi 2003-11-18 00:59:03 UTC 
General query for an ODBC connected Access database:

SELECT table.field
FROM database
WHERE NOT table.field LIKE somevalue

Result when save attempted:

Syntax error in SQL expression
parse error, expecting `BETWEEN' or `IN' or `SQL_TOKEN_LIKE'

Remove the NOT and it's happy to save it.
Comment 1 Frank Schönheit 2003-11-18 09:47:21 UTC 
workaround:
WHERE table.field NOT LIKE somevalue

Our parser currently cannot handle the form "WHERE NOT ... LIKE ..."
Comment 2 hans_werner67 2004-02-02 12:49:12 UTC 
change subcomponent to 'none'
Comment 3 ocke.janssen 2007-08-23 12:02:27 UTC 
Fixed in cws dba24b
Comment 4 ocke.janssen 2007-10-02 10:00:39 UTC 
Please verify. Thanks.
Comment 5 marc.neumann 2007-10-10 14:25:06 UTC 
verified in CWS dba24b

find more information about this CWS, like when it is available in the master
builds, in EIS, the Environment Information System:
http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=SRC680%2Fdba24b
Comment 6 marc.neumann 2007-10-16 10:40:22 UTC 
change target to 2.4 because issue will be fixed in OpenOffice.org 2.4
Comment 7 drewjensen.inbox 2008-02-18 01:57:28 UTC 
tested w/00H680_m7 ( Build: 9272 )
CLOSING