For the case of the HSQL database engine I have a very unofficial list, you can download it at http://www.paintedfrogceramics.com/OpenOffice/hsql_functions.ods
Drew Jensen On 4/21/07, Roland <[EMAIL PROTECTED]> wrote:
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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
