In an Open Office spreadsheet, press f4 to view the datasources, select any H2 table, then add a filter on any field (I added a non-null filter). This results in an error message like this:
ERROR: Column TEST.AAA.CONTAINER_USE.BATCH not found; SQL statement: SELECT * FROM "TEST"."AAA"."CONTAINER_USE" WHERE ( "TEST.AAA.CONTAINER_USE"."BATCH" IS NOT NULL ) [42122-111] Query = SELECT * FROM "TEST"."AAA"."CONTAINER_USE" WHERE ( "TEST.AAA.CONTAINER_USE"."BATCH" IS NOT NULL ) Same query fails standalone as well. Not sure whether what they are doing is standard, but I presume it works with other databases, and regardless, it would be neat to have H2 compatible with Open Office. Thanks --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
