Ask Your Question
0

Error in Query using NOT BETWEEN x AND y (SQL Error Code 1000) ??? [closed]

asked 2014-10-31 15:20:04 +0200

mrmister gravatar image

updated 2016-03-05 18:59:00 +0200

Alex Kemp gravatar image

Hello I have a simple database of Employees created and I am doing queries to test it. I am doing the queries in the grid design mode, not using SQL... however I don't know why this is happening.

I have several fields Name, Last name, Address, ZIP, City, Experience

Experience is an Integer Field and this field (numeric) is used to store the employee experience in a certain area, for example 10 would represent 10 years of experience.

Very easy to understand

Ok. I have my records and when doing the query if I drag and drop the field Experience to the grid and I put in criteria BETWEEN 5 AND 10 when I run the query I get all the records that have between 5 and 10 years of experience. But... and this is strange...

If I put NOT BETWEEN 5 AND 10 (because I don't want to get the records that have between 5 and 10 years of experience) then what I get is an Error...

It says...

SQL Error Code 1000

Exactly it says: syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE

Why is this happening and how may I solve it?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-05 18:59:43.685661

1 Answer

Sort by » oldest newest most voted
0

answered 2014-10-31 17:58:26 +0200

mrmister gravatar image

I've discovered this is a very annoying bug in LibreOffice base, because NOT BETWEEN is not working when the user Interface is in Spanish but when the user Interface is in English, NOT BETWEEN is working fine. How may I report this bug?

edit flag offensive delete link more

Comments

https://bugs.freedesktop.org/enter_bu... and be as verbose as possible, and selecting as correct options as possible.

rautamiekka gravatar imagerautamiekka ( 2014-10-31 18:01:06 +0200 )edit
mrmister gravatar imagemrmister ( 2014-10-31 18:36:14 +0200 )edit

I ALSO DID A VIDEO CONFIRMATION OF IT. PLEASE, TAKE A LOOK HERE: link text

mrmister gravatar imagemrmister ( 2014-10-31 21:51:58 +0200 )edit

* ERROR WAS SOLVED AND THE NEXT UPDATE FROM LIBREOFFICE WILL HAVE THE CORRECTION *

mrmister gravatar imagemrmister ( 2014-11-01 20:44:02 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2014-10-31 15:20:04 +0200

Seen: 274 times

Last updated: Oct 31 '14