update value on form grid cell

(0) Share

Report

Posted on by xain

491

Hi,

i want to update the grid cell value based on two cell values by multiplying it. when i debug, in modified method i am getting expected value in "num" variable but but it is not reflecting on forms grid.

here's the code

public void modified()
{
   real num;
    
    num = WriteOffTrans1_Weight.realValue() * WriteOffTrans1_PPPounds.realValue();

    WriteOffTrans1_WriteOffAmount.realValue(num);
    super();
    

}

All responses (2)

Answers (1)

xain 491 on at

Like (0)

Report

RE: update value on form grid cell

Hi martin,

Thank you, this works like charm!
Verified answer

Martin Dráb 229,420 Most Valuable Professional on at

Like (0)

Report
RE: update value on form grid cell

Your approach is indeed wrong. The grid takes values for each row from a data source, either from a field or from a display/edit method.

If the value is always calculated in this way, then it's likely not necessary to maintain a field in database. You can put a display method on the table, like this:

display YourEdt writeOffAmount() { return this.Weight * this.PPPounds; }