3.5.6: Aggregation behavior

Classic Servoy
1

Hi,

Is it correct that the Aggregation (for example sum) only works on data that is physically in the database?

I have a foundset and I added new records to my foundset without saving the data to the database.

I expected that my sum-value would change on each record that I add or change within my foundset. Because in that way I could show the current totaal sum to my user

Is that behavior normal? Is there any reason for that? And can it be changed?

Martin

2

Hi Martin,

All aggregations are done in the database.
So when you have defined a SUM all what Servoy does is sending a SQL statement to the back-end.

SELECT SUM(fieldName) FROM table