Is there any documentaion about which are the valid syntax constructs OO
Base allows for query building?
E.g. the following runs without any problems from isql:
SELECT CASE WHEN "length" LIKE '%small%' THEN 1 ELSE 0 END small FROM
"paper"
but gives me the following error when run from "Query Design":
SQL Status: HY000
Error code: 1000
syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE
Do I have only a syntax error somewhere or am I using a incompatible
syntax? Which would be a compatible formulation?
Thank you for help!
Roland
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
