Re: new SQL syntax error in list box

There query component has two views and a property escape_processing.

When the query component is is Designer view, the full GUI, 
escape_processing must be TRUE. This allows the Base level parser to, 
parse, the sql statement and look for named parameters you may have used 
and that will be prompted for values, when the query itself is run.

When you turn the designer view off, so that the SQL command is 
displayed the escape_processing property is still true. This way you can 
still work with the named parameter feature.

Now however there is a toolbar button available, SQL (With a green check 
mark), and the name Run SQL Direct. By selecting this your set the 
escape_processing property FALSE.

The error string you are getting "expecting BETWEEN or IN or 
SQL_TOKEN_LIKE" most often is caused when the Base level parser can't 
make sense of some function or construct used when in the non designer 
view. Even when the syntax may be acceptable to the connected database 
engine.

Normally when you get this error message, you can turn off 
escape_processing and the query will run.

HTH

Drew