Manually Recalc Fields

Discussion of open issues, suggestions and bugs regarding PgDAC (PostgreSQL Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
dschuch
Posts: 75
Joined: Thu 05 Feb 2009 15:29
Location: Dresden

Manually Recalc Fields

Post by dschuch » 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.

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Thu 26 Nov 2009 14:09

You can call Edit and then Cancel to recalculate fields.

Post Reply