How do I retreive a calculated value from a child grid

[Davidk]

Re: How do I retreive a calculated value from a child grid

This example moves the javascript into the server-side event onSummarySectionRender.

This is where all the summary magic happens... and this event allows the return of javascript... so... might as well put it to good use.

This code will run in this server-side event...

dim p as p
p.summaryTotal = e.summaryValues.TOTAL.Total

dim js as c

js = <<%txt%
if ({grid.Object}.__firstRender == false){
var pobj={grid.Object}.getParentObject();
if (pobj) {
var rowNum = {Grid.Object}._selectedRow;
{grid.Object}.submitGridPart();
var currentRow = pobj.getRepeatingSectionActiveRow('CONTAINER_1', true);
pobj.setValue('EXTENSION:'+currentRow,p.summaryTotal);
{grid.Object}.setSelectedRow(rowNum);
}
else
{
//alert('No Object Detected.');
}
}
%txt%

js = replace_variables_in_string(js, p, "p")

e.javascript = js

This code will run every time the summary values change.

However... there is a little problem. The summary values get set when the grid is first rendered. We do not want this code running when the grid first gets rendered.

So... in the Client-side event onGridInitializeComplete put this...

{grid.Object}.__firstRender = true;

And... in the Client-side event canGridSubmit put this...

{grid.Object}.__firstRender = false;

So... when the grid first opens, our grid object namespace variable {grid.Object}.__firstRender gets set to true.

The summary code runs... but the Javascript is not executed because it only runs if {grid.Object}.__firstRender is set to false.

When any change is made to the grid, {grid.Object}.__firstRender is set to false.

If the server-side event get executed... {grid.Object}.__firstRender is now false and the javascript gets executed.

I guess it depends on why you're in the Grid... because the summary code will get executed after ANY grid update... not just on summary updates.

You could start testing for specific control changes... just depends on your needs.

This is just another way of looking at things.

[jackp_MDB]

Re: How do I retreive a calculated value from a child grid

David,

What a wonderful piece of code...and I understand almost all of it.

It works fine and does exactly as I need.

Can you explain the js replace string statement. Does it just "substitute" a quoted "p" string?


Jack

[Davidk]

Re: How do I retreive a calculated value from a child grid

Yes... you've got p.summaryTotal in the txt string... and you've got a pointer array (alias property array or dot variable) variable p with a property of summaryTotal defined.

In the function you pass in the string js, the pointer variable you've defined and assigned and the quoted "p" refers to the pointer variable in the string. It doesn't have to be "p"... but the elements of the pointer variables must match.

You can also do this with stritran and a few other functions. Have a look in the docs for character replacement functions.

I just like using this function 'cause it's very cool.

[jackp_MDB]

Re: How do I retreive a calculated value from a child grid

Thanks Dave.

Jack