aggregation not working

Classic Servoy
1

Hi guys,

I have found a problem on some aggregations function (count and sum).
I have a formA based on tableA. In formA there is a SplitPane that contains two forms formB (tableA) and formC (tableA). formB and formC have relationname’s property set to tableA_to_tableA.
On tableA i have created an aggregation function on field1 (for count) and an aggregation on field2 (for sum) and put them in the formC. When, in formB, i add a new record in formB (and save in the beckend db) the aggregation field is always empty, but i would to display the number of the record that i create and the sum of the field2.

Anyone know why?
I hope that is all clear. (and sorry for the bad english)

Regards,

Marco Alessio Milazzo

2

Marco,

The aggregates are on the related foundset tableA_to_tableA from the record of tableA on formA.

I guess you are mixing up the source and target for the relation (being the same table in your example), it seems you are using the aggregate from the related record instead.

If you put related tableA_to_tableA.count_field1 on formA, I expect it will show.

Rob

3

I will test your solution.

Thanks

4

I test your solution but when i add tableA_to_tableA.count_filed1 as dataproveder of the field i obtain “unresolved dataprovider” warning.

5

i see a strange behavior.
If i create a new record on the foundset of the formA the aggregation not working, but if i perform foundset.loadrecord(…) the aggregation show the correct value and if i create a new record the aggregation is still update.

Anyone can explain this? :?