Hi all,

I'm trying to use Kexi to find the average for a university question. I've used the line

SELECT avg(Birth_rate) FROM birth_rate

in the SQL query builder where Birth_rate is the column name, and birth_rate is the table name. Every time I try to test or run the command it says

The query is incorrect
Syntax error near ")"

I've tried the help on Kexi and SQLite (which I understand is the back-end) and I can't find any alternative suggestions on how to write the query. I've tried with and without a semi-colon and moved around spaced and parentheses to no avail.

Does anyone know how to use the avg function in Kexi?

Thanks very much,
Aston

Hi,
Aggregation functions and groupping (and functions in general) are not available in the Kexi SQL module yet (used for queries and forms). For 1.x they will not be released at all, since it is series closed for new features. For 2.x series it is definitely in plans after 2.2, i.e. before end of 2010.

That said, groupping is independently added to the new Kexi 2.2 reports plugin (currently in beta 2). So reports are not limited by the above.

Ahh that explains it, thanks for the info.