On Sat, 06 Feb 2010 19:40:26 -0500, Drew Jensen <[email protected]> wrote:
> 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. Thanks for the explanation Drew! I'm not sure how to turn escape_processing off though. I don't seem to have the Run SQL Direct button in my version (OOo 3.1.1). -- Seb --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
