I get SQL syntax errors whenever I attempt to use H2 parameterized queries with OpenOffice Base. For example:
SELECT "DESCRIPTION" AS "DESCRIPTION", "ID" AS "ID" FROM "TOPAZ"."PUBLIC"."COLOR" AS "COLOR" WHERE "ID" = :COLOR_ID When I run the query, OpenOffice correctly displays a dialog allowing me to enter a value for the COLOR_ID parameter. However, I then get a SQL syntax error: SQL Status: 42001 Error code: 42001 Syntax error in SQL statement "SELECT ""DESCRIPTION"" AS ""DESCRIPTION"", ""ID"" AS ""ID"" FROM ""TOPAZ"".""PUBLIC"".""COLOR"" AS ""COLOR"" WHERE ""ID"" = :[*]COLOR_ID"; expected "ALL, ANY, SOME, SELECT, FROM"; SQL statement: SELECT "DESCRIPTION" AS "DESCRIPTION", "ID" AS "ID" FROM "TOPAZ"."PUBLIC"."COLOR" AS "COLOR" WHERE "ID" = :COLOR_ID [42001-135] If I replace the COLOR_ID parameter with a hardcoded value, the query runs correctly. Parameterized queries work for me when I use the embedded HSQLDB that comes with OpenOffice. Any suggestions? Bruce -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
