Calculated Fields

[ncurado]

I've been having a problem with calculated fields. I'm using a calculated field where the value comes from a form that is used several times, and every time the dataset makes a posts all data for every calculated field is redone instead of calculating just the last one. Can anyone give me a hand with this problem?

PS: I'm using DOA 3.3.3. i've upgraded to 3.4.5 but it was useless. I still had the same problem.

 

[Marco Kalter]

Do you mean for all calculated fields of one record (the one you posted), or for all calculated fields of all records?

------------------
Marco Kalter
Allround Automations

 

[ncurado]

It happens for all records in all calculated fields in the Dataset. Every time I make a post the event oncalcfields is called and it updates the data in all records on every calculated field. Wasn't it supposed to just calculate the new record?

--
Nuno Curado
ncurado@ipn.pt

 

[Marco Kalter]

In that case I would expect that you also refresh the dataset. The records will be fetched again, and the calculated fields will be calculated again. Could this be the case?

------------------
Marco Kalter
Allround Automations

 

[ncurado]

If I did a refresh, all records would be recalculated. But in this case I don't do any refresh on the dataset. The oncalcfield event that changes all records happens just after my post command.

--
Nuno Curado
ncurado@ipn.pt