Aggregate Fields

goranpro · Post by **goranpro** » Tue 05 Oct 2010 06:20

Hello,

I have a problem using aggregate fields.

I added a TAggregateField in the Fields Editor of TUniQuery dataset and set its properties:

Active=true
Visible=true
Expression=SUM(FLD_TEST)
FieldKind=fkAggregate

,but the result of summary is not visible in the TDBText component.

May be I am missing something. Is there any properties I should set too?

Thanks.

AndreyZ · Post by **AndreyZ** » Tue 05 Oct 2010 09:21

Hello,

The point is that aggregate fields are used only with ClientDataSet. TUniQuery doesn't support aggregate fields.

goranpro · Post by **goranpro** » Tue 05 Oct 2010 10:33

OK...thanks Andrey