Calculated field in Grid not updating

[bob9145]

I have a grid component (update only) with a client side calculated field that is the sum of 2 other fields. total has the calc field expression: value1 + value2
Problem is this field (total) when submitted does not update. If I remove the calc field property and manually enter the field amount it updates. Since it updates without the calculated field I am assuming the expression is blocking the update. Is this a no no? Why won't it update? How Can I get it to update with the calculated amount since adding the two values is needed?

Note: the grid is based on a custom sql statement.

[bob9145]

Re: Calculated field in Grid not updating

Typing that post made me think a little harder. Why wouldn't it update, possibly because the calc field does not count as making the field dirty. Stay tuned I'll change that property, and see what happens.

[bob9145]

Re: Calculated field in Grid not updating

That didn't work seems the calc field is blocking the update. Also changed the grid property to allow insert, this didn't work. Couldn't find any documentation addressing this. Is this just a fact of grid life?

[Davidk]

Re: Calculated field in Grid not updating

I can't duplicate your issue. I have a grid... set for update only, custom sql statement including 3 fields... CustAmount, Quantity, Total. Total has a Calculated field expression of Quantity * CustAmount. Changing CustAmount and/or Quantity updates Total and I can submit the changes without issue. I then added formatting to the fields and I'm still able to update.

Create a new simple grid with just the table key and your 3 fields and test that.

[bob9145]

Re: Calculated field in Grid not updating

Don't quite understand this. The calculated fields will not update when submitted unless I change the base field after the grid is rendered. They are not recognized as dirty according to the sql statement. If I change the value in a field the calculated value is based on (even if I return it to the initial value) it then registers as dirty and is updated. The fields are initially Null but they are filled with the result of the calculated field expression as rendered. Why is this not making the field immediately dirty? What am I missing? Can these fields be set to dirty?

[bob9145]

Re: Calculated field in Grid not updating

I'll try that Dave thank you for taking a look.

[bob9145]

Re: Calculated field in Grid not updating

I think the curve ball is the existing records have null fields. These null fields are immediately filled by the calculated fields when the grid is rendered because the field that the calculated field is based on has a value. These fields may or may not be changed by the user, but either way they need to be updated. The problem is if they are not changed by the user they don't show up as dirty and they are not included in the update statement even though they contain a new value created by the calculated field. Should't the calculated field immediately make these fields Dirty?

[bob9145]

Re: Calculated field in Grid not updating

Guess it is a kinda odd set up. because if you updated a row and refreshed the grid the calc field would just manipulate the fields again when the updated record was retrieved. But I have a filter on the sql statement so it does not re retrieve the record when successfully updated. Another field changes with a checkbox and the record is not retrieved once it is edited because it no longer meets the filter criteria. This record pops up on a related grid (not linked).

[bob9145]

Re: Calculated field in Grid not updating

just using a simple expression: field1 * 2 Doesn't matter if the field is initially Null or has a value.

[bob9145]

Re: Calculated field in Grid not updating

The proof of this seems to be that the submit button is not initially active confirming that the calculated field is not making the field dirty. So I guess I need some kind of way to set the column field as dirty? Or is there a better work around? Can I delay the field being calculated? Is this a timing issue?

[Davidk]

Re: Calculated field in Grid not updating

What is the sql statement?

[bob9145]

Re: Calculated field in Grid not updating

Can anyone explain the sequence of events? If the calc field is triggered as the grid is rendered what is the sequence of events? Or are the render and the calculation getting jumbled? I came across a post where someone said the calc is immediate. Not sure what immediate means?

[bob9145]

Re: Calculated field in Grid not updating

I eliminated the statement and just based a grid on a single mysql table fields, no filter.

[bob9145]

Re: Calculated field in Grid not updating

I used a check box field to manually trigger the calcs I need this makes the grid fields needed dirty. Not ideal but it works for now. Would like to understand this better.

[Davidk]

Re: Calculated field in Grid not updating

As you say, the calcs are running but not setting the rows dirty. Try this in the Grid's onRowRender event. If your data is clean... if you only need to update empty fields upon render... then this should be ok.

var tot = {grid.Object}.getValue('G','TOTAL',e.rowNumber);
if(tot==""){
	var value1 = {grid.Object}.getValue('G','CUSTAMOUNT',e.rowNumber);
	var value1 = value1 * 2;
	{grid.Object}.setValue('G','TOTAL',e.rowNumber,value1);
}

This is essentially performing the calc twice if the calc field is empty... but using .setValue sets the row dirty. It leaves the existing calculated fields alone.