Embedded Grid: need help with syntax to assign grid field value to a global variable

[jhackney]

I have been spinning my wheels on and off for a total of 20 hours trying to assign a value in the current row of an embedded grid into a global variable. However, the syntax escapes me. Please help if you can. I have reached the point of spontaneous combustion. Following are the details:

1. Form 'F' has Grid 'G' embedded within and displays the records from Table 'T'.
2. Form 'F' initializes Global Variable 'GV' when opened and assign a character value of "".
3. I would like to attach an event on the 'on row select' event found under system events of the grids properties that will return the value of one of the fields from the row just selected and assign it to 'GV'.
4. By doing so, my 'G' is functioning as a record selector that the other objects of 'F' can use to do their thing.
5. I tried using Action Javascript 'AJ', client side x-basic 'csxb', and a combination of the 2 and can not get a value passed to the variable.

Where am I going wrong? Does anyone know the correct syntax and placement to accomplish this? I searched high and low on the message boards and could not find any questions that came close. I also tried several of the how-to's and other instructional's that I came across but they did not work either.

Any help is greatly appreciated.

[Clunes]

Re: Embedded Grid: need help with syntax to assign grid field value to a global vari

I do not use the embedded grid. That said, does it have an onclick event? If so try using AS do a set variable = field value.

[jhackney]

Re: Embedded Grid: need help with syntax to assign grid field value to a global vari

Clunes, thanks for the quick response. Yes I did try that syntax using around a dozen different flavors. The ones that stick out that did not work in the Action Javascript were:

var a = global v (where var a = {grid.object}.getValue('G','LASTNAME',{grid.rowNumber});
SESSION.a = global v (where SESSION.A was listed as a published session variable)
self->a = global v
etc....

[Peter.Greulich]

Re: Embedded Grid: need help with syntax to assign grid field value to a global vari

I have been spinning my wheels on and off for a total of 20 hours trying to assign a value in the current row of an embedded grid into a global variable. However, the syntax escapes me.

You want to:

1. read the value of a field in the grid
2. assign that value to a JS var
3. Read the JS var into a global var

Check out this thread:

http://msgboard.alphasoftware.com/al...ad.php?t=92797

[jhackney]

Re: Embedded Grid: need help with syntax to assign grid field value to a global vari

Peter, that did the trick. Thanks a million for the help. It is very appreciated. My circumstances were a little different that what was referenced so I will detail what I did for the community.

1. I dimmed a global var called "my_global_var" inside a form when initialized. Since the variable was called prior to the initialization of the grid, it is accessible by the grid. Otherwise, I could have dimmed it inside the grid itself.
2. Inside the grid, I defined a calculated field called "my_calc_field" that uses one or several other fields to calculate it's value.

The goal of my form is to be able to select a row of data in the grid and use that information to either populate other fields outside of the grid on the form or to use that information as a trigger to display other related information in the form.

As such, the appropriate event for me was "onRowSelect". Unlike the example provided to me, this event is located under the "Properties" section of the grid under "Javascript System Events". Under this event I have the following javascript:

var rowNum = {grid.object}._selectedRow;
{grid.Object}.ajaxCallback('G',rowNum,'xbGet_JS_Var','','_getData=true');

Note that I used the same function name that Peter used in his example. Also note that I had to add the first line of javascript b/c the "onRowSelect" event is not an event defined in each row as was the original example. Thirdly, I had to add the "_getData=true" to the end of the second line because my grid is read only. As such, the ajax callback would not return the values for ALL fields in the row unless I added this javascript.

Under the definition of the "xbGet_JS_Var" function, I have the following code listed in the "X-Basic Function Declaration" section of the grid:

function xbGet_JS_Var as c (e as p)
    
''get the JavaScript variable from the hidden calc field
[COLOR=Blue]my_global_var[/COLOR] = e._currentRowDataNew.[COLOR=Blue]my_calc_field[/COLOR]

end function

Now, whenever I select a row in the grid, the value in my_calc_field is populated inside a global variable that I can use anywhere else on the form.

[jkukuda]

Re: Embedded Grid: need help with syntax to assign grid field value to a global vari

Helped me a lot, thanks