trigger a calculation in a calcuated field

Classic Servoy
1

Hi everyone,
need help again.

My servoy solution has a table with 4 fields and a stored calculation field.

weight 1, 2,3,4, Weight average.

I just did an import from an excel sheet (using MS SQL server) to import that raw data. But my weight average remains blank. Is there trigger the calculation so that I can get the weight average back into the stored calculation field?

thanks,

sammy

2

Hi Sammy,

This is an old favourite. I’m sure you will find some posts about this if you search the forum.

My suggestion (untested):
Update the store field using a SQL command in MS SQL server. Then restart Servoy.

3

The problem with calcs is that you don’t want that they get updated too often and you don’t want them to never update at all. This is one of the reasons why this has been heavily discussed in the forum.

We now, however, have a solution to this that gives us control:

databaseManager.recalculate(Object foundset/record)

Hope this helps.

Patrick