Manually Recalc Fields
Posted: Thu 26 Nov 2009 08:52
Hy,
i know that this is not a standard and also not supported by design. But i need a solution to manually refresh the Calced Fields.
E.g.
The Problem is that in a Master-Detail dataset the Master should show a different Sum in dependence of which detail DataSetRecord is selected. (this ia not the need i have but it will explain the problem (e.g. different currency's or discount's))
So i need to Recalc the Calced Fields of the Master. Currently i do that by RefreshRecord but that forces much DB-Load. The solution can be proprietary too, everything is done in a Class Structure so there will be only one sourceline ^^ I know PGDAC is very flexible so i think there should be a solution ^^
Any Ideas would be great!
Daniel.
i know that this is not a standard and also not supported by design. But i need a solution to manually refresh the Calced Fields.
E.g.
The Problem is that in a Master-Detail dataset the Master should show a different Sum in dependence of which detail DataSetRecord is selected. (this ia not the need i have but it will explain the problem (e.g. different currency's or discount's))
So i need to Recalc the Calced Fields of the Master. Currently i do that by RefreshRecord but that forces much DB-Load. The solution can be proprietary too, everything is done in a Class Structure so there will be only one sourceline ^^ I know PGDAC is very flexible so i think there should be a solution ^^
Any Ideas would be great!
Daniel.