Aggregate field

dargos · Post by **dargos** » 21.01.2009, 22:37

Does zeos support aggregate fields?

Post by **mdaems** » 22.01.2009, 14:58

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

dargos · Post by **dargos** » 22.01.2009, 16:12

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.

akli_agha · Post by **akli_agha** » 23.01.2009, 20:56

Perhaps because your field 'count' is a reserved word ??

Post by **mdaems** » 29.01.2009, 22:06

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

dargos · Post by **dargos** » 30.01.2009, 05:27

I study c++ builder help and I found Taggregate fields is support only by TClientDataset.
It would by nice to support this by zeos

Post by **mdaems** » 30.01.2009, 08:23

No way of working using a TZQuery, combined with TDataSetProvider and TClientDataset? Should work...

Mark