jbader wrote:Johan, you certainly know more than anyone about under what circumstances calcs do and do not work/fire/run updates etc then anyone else. I have provided my use case, and I really need some help understanding where the problem is. [please]
jeff, you really need and i do stress this, you need to go to 5.2.4
Because you use db transactions and columns with default values, there where problems with that in 5.2.2 and lower when columns with default values didn't update related foundsets (what you also reported in another thread)
that was fixed in 5.2.3 but then default values and db transactions but surfaced this is fixed in 5.2.4.
So in your case you really need to be on 5.2.4
These 2 things don't really have to do anything specific with calcs. Stored calcs are just column values that are changed and updated to the database when coming to storing it to the database (there is no difference in that way)
Then calcs just should work, besides the cases that paul and i described in this thread.
databaseManager.recalculate() should really always update the stored column values of the records that are walked over. I don't know any way in 5.2.4 why that would not work for you.