Aggregates with INSERTS thru the backdoor

Classic Servoy
1

I have a parent table and a child table.
The child table is used by a financial program with SQL-INSERTS.
The child table has an aggregate column.

When I show the rows thru a tab-panel in the parent table the rows are quickly shown.
The aggregate however doesn’t refresh so easyly.
It doesn’t refresh after I change to another row in parent table…it doesnt refresh when I go to completely other non-related forms…and then go back.

Is there a way to force the aggregate to recalculate with an Onshow or OnrecordSelect method?? I have tried several options like

forms.fin_ontvangst_lijst.controller.loadRecords(parent_to_child);
databaseManager.recalculate(forms.fin_ontvangst_lijst.foundset);

But the aggregate is not recalculated.

Any suggestions?

2

The rawSQL plugin allows you to flush the client cache if you alter the database form outside servoy at the same time servoy is using the database.

3

Jan Blok:
The rawSQL plugin allows you to flush the client cache if you alter the database form outside servoy at the same time servoy is using the database.

Yeah…but I understand that all clients are then flushed…and that is kind of expensive operation. I dont want 100 people flushing on onSHow’s and on OnRecordselects

4

call it once after you know there is an update done with an external system