Callback Receiving Old Data

[nlk10010]

OK, stipulating to the fact that this could easily be pilot error, I'm seeing an issue that I can't seem to figure out.

I have a read-only grid with an editable detail part. To accomplish what I need I've created a callback calculation routine, a javascript action to call that routine and, in the OnDetailViewRender server-side event of the grid, I return javascript to run that action. The callback needs the value of a couple of fields in the detail part and then returns javascript to set other fields with the result. To give the callback the required information, instead of selecting "Compute current row data" in the Action Javascript dialog, I've created a javascript function which I put in the "Additional Data to Submit" field. The function reads the values from the detail part using getValue.

So far, so good. Everything fires when it's supposed to. The callback (with the exception I'm about to note) gets the data it needs, does its calculations and is able to return javascript to set the appropriate field(s) on the detail form. The problem is the following: If I CHANGE the value of one of the fields that the javascript function is accessing with getValue, then click "Save", the variable sent to the callback contain the PREVIOUS value of the field. That is, if, say, I change "Rate" from .90 to 1.00, then click Save, the callback (which is definitely triggered AFTER the data has been saved), gets .90 instead of 1.00. The 1.00 shows in the "Rate" field in the detail form; if I set an OnChange event handler for the "Rate" field to do a getValue and display the return value in an alert, I see 1.00. I have no idea why the callback is getting .90.

Again, it could easily be pilot error (either a lack of understanding of the fundamentals or a coding error), but I've cobbled up a small test case to exhibit the problem (it's called setValue because I was too lazy to change the name of the test case I posted previously).

Any ideas would be gratefully accepted.

BTW, I'm using 3550-4650.

[lvasic]

Re: Callback Receiving Old Data

You can try putting it here: CanUpdateRecord

q = datasubmitted.QUANTITY
r = datasubmitted.rate
CalcResult = convert_Type(q,"n") / convert_Type(r,"n")

[lvasic]

Re: Callback Receiving Old Data

Or if you have a column that you are saving it to you can use a Calculated field expression and just put Quantity / Rate. This will display on screen and also save it when you save.

[Davidk]

Re: Callback Receiving Old Data

Although you give an excellent explanation of what you're doing and an excellent test case, I'm not sure what you're trying to achieve. Once you have this working, is your plan to do something more involved at the server with any calculations? If not, then your current methodology is far too complex and extremely wasteful.

What you're doing, in effect, is this.

Rendering the detail view on the client side... and when that's done you're sending a message to the server to run an action... on the client side. That action performs an ajax callback... heading back to the server... to calculate a value using 2 numbers you already had at the client side, and send that calc back to the client.

That's like you and I standing beside each other... and you handing me a calculator and asking me to run down the street and give it to our friend, Bob... and ask him to bring it back to you. So I run down the street, give the calculator to Bob and ask him to run it back up the street to you. He does this. You then tell Bob that Quantity = 9101 and Rate = 1, hand Bob the calculator and ask him to run down the street and give everything to me and ask me to bring everything back to you. So... Bob runs down the street, gives and tells me everything and I run back up the street and tell you and give you back the calculator. But, you already knew everything and already had the calculator... so you actually had everybody running around for nothing... in which case Bob and I go off for pizza shaking our heads.

You want to calculate Mileage which is Quantity / Rate. In the Query section of the Grid I added a Calculated field... mileage = quantity/rate. I then added this field to the Detail Section. Now when I change the Rate and save, the Calculated field is automatically updated with the correct and current value. Granted, because you're saving stuff, the calc is being passed back to the client.

You don't have to use a Calculated field. You could do this all client side, if you don't need anything from the server. It depends on what you want to do with the calculated data.

Is that all you want to achieve? Or is it more complex than that.