I have a CSV file which I am using as a database with LibreOffice DB.
What I'm doing is explained in detail in this answer.
I can do some operations, but when I try to enter the following into the SQL editor:
select SUM(Dollars) from original
I get the following error:
The query cannot be executed. It is too complex. Only Count(*) is supported.
So I think its an error from the ODBC or maybe JDBC driver. Where can I find a better driver for my MacBook OSX 10.7.2? Or what else should I do?