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 --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
