It works but when the column title has english characters. If we place instead of 'AS "month"' -->'AS "μήνας"' (in greek) it doesn't
org.h2.jdbc.JdbcSQLException: Column μήνας not found; SQL statement: SELECT returnMonth(date, 'no') AS "νο μήνα", returnMonth(date, 'name') AS "μήνας" , COUNT(*)AS "πλήθος", SUM(invoice.value) AS "σύνολο", AVG (invoice.value) AS "Μ.Ο." FROM invoice WHERE invoice.farmerId=1 AND invoice.companyId LIKE '1' AND invoice.dbyear LIKE '2006' GROUP BY "μήνας", "νο μήνα" ORDER BY "νο μήνα" [42122-117] Is there any solution for this? --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
