Some extra notes about the calculation changes:
All stored calculations are calculated when the record is loaded from database. So that the calculated values of the record are in synch with the database as soon fast/early as possible
2 things needs to taken into account when returning a value of a stored calculation so that servoy doesn’t see it constantly as a change.
1> If you return a string then please take care that the value that is returned can fit in the column. So if you specify a column of length 10 and the string you return is of length 11 then that value will be constantly updated to the database. (we are planning to generate a warning for this)
2> some database (like sybase) return a NULL for a empty string. So if you return an empty string (“”) in a calculation then servoy will see this as a change because the database did return a NULL. So just to be safe for these kind of things do return a NULL instead of a “” when returning an empty string from a calculation.