Page 1 of 1
Aggregate field
Posted: 21.01.2009, 22:37
by dargos
Does zeos support aggregate fields?
Posted: 22.01.2009, 14:58
by mdaems
What do you mean exactly?
Select statements using group by and aggregate functions as count(), max(), ... are evaluated correctly. Of course, these queries are not updatable because of the grouping.
Mark
Posted: 22.01.2009, 16:12
by dargos
I tried TZQuery with sql and with upadte object.
select id, type, count from table
Fields was created automatic and I created TAggregate field with expression Sum(count). I don't use grouping I want sum over full query.
But aggregate field doesn't do anything, it has null value for all time.
Posted: 23.01.2009, 20:56
by akli_agha
Perhaps because your field 'count' is a reserved word ??
Posted: 29.01.2009, 22:06
by mdaems
Dargos??
Was akli_agha's answer useful? Otherwise, please post a bug report + test project in the bug tracker at
http://zeosbugs.firmos.at/
We can't just guess what you're exactly trying to do. Don't forget to include a data creation script.
Mark
Posted: 30.01.2009, 05:27
by dargos
I study c++ builder help and I found Taggregate fields is support only by TClientDataset.
It would by nice to support this by zeos
Posted: 30.01.2009, 08:23
by mdaems
No way of working using a TZQuery, combined with TDataSetProvider and TClientDataset? Should work...
Mark