Set Value in related grid with Ajax CB

[gaby_h]

With an Ajax CB, the e._set.xxx.value allows you to set value in the current grid. Is there a way to set a value in a related grid (from child to parent or parent to child) from within the Xbasic function declaration? For expl an Xbasic function returns a certain value in current grid, the value is set in a related grid.

[Jay Talbott]

Re: Set Value in related grid with Ajax CB

Have you watched video # 62? I found this helpful for getting the name of the parent grid, and then manipulating that grid.
http://news.alphasoftware.com/V10Preview/videos.htm

Jay Talbott

[gaby_h]

Re: Set Value in related grid with Ajax CB

Hi Jay
Doing it with JS is not a problem. I am trying to do it via an Ajax CB. I am nearly there, and will get it to work (I think) if someone can help me with the following:
Just a single grid with an Ajax CB that grabs the value in Text1 field and try to set it in Text2 field as follows:

function vox as c (e as p)
z3 = e._currentRowDataNew.TEXT1
vox = " {grid.Object}.setValue('G','TEXT2',{Grid.RowNumber}, z3); "
end function


The error I am getting is ' z3 is undefined '. Replacing z3 with a static value works. I guess because z3 is a server side variable and is not seen on the client side. The question now is how can I get the browser to see z3?

[Jay Talbott]

Re: Set Value in related grid with Ajax CB

I would try it with a button on the "source" grid, using:

z3 = {grid.Object}.getValue('G','TEXT1',{Grid.RowNumber});
TARGETGRID.setValue('G','TEXT2',{Grid.RowNumber}, z3);

If that works, then place those two lines in your:
vox =
section

Not sure I have completely solved the issue, but hope this gets it closer
Jay

[Davidk]

Re: Set Value in related grid with Ajax CB

You need to put the vox= statement together in pieces in order to have z3 evaluated.

vox = " {grid.Object}.setValue('G','TEXT2',{Grid.RowNumber}," + z3) + "; "

[gaby_h]

Re: Set Value in related grid with Ajax CB

Hi David:
Thanks David, I am getting an error message but definitely the right track. I suspect the bracket after z3 is not in the right place and I suspect it needs single quotes somewhere in there. Single quotes, dbl quotes, brackets have never been my friends. I'll keep fiddling around with it. Thanks for pointing me in the right direction.

[aburningflame]

Re: Set Value in related grid with Ajax CB

Hi David:
Thanks David, I am getting an error message but definitely the right track. I suspect the bracket after z3 is not in the right place and I suspect it needs single quotes somewhere in there. Single quotes, dbl quotes, brackets have never been my friends. I'll keep fiddling around with it. Thanks for pointing me in the right direction.

Try:
vox = " {grid.Object}.setValue('G','TEXT2',{Grid.RowNumber}, '"+z3+"'); "

last parameter is:
singlequote doublequote + z3 + doublequote singlequote

[gaby_h]

Re: Set Value in related grid with Ajax CB

Thanks Scott, right on, works great. Thanks a million for the solution and the explanation.

[aburningflame]

Re: Set Value in related grid with Ajax CB

No Problem.
The reason for this was because you were trying to use the z3 variable in javascript context (i think you knew that).

vox = " {grid.Object}.setValue('G','TEXT2',{Grid.RowNumber}, '"+z3+"'); "

If you translate this to the resolvation (with the z3 variable) it becomes:
GRIDIDWILLGOHERE.setValue('G','TEXT2',15, 'TESTVALUE');

Notice the last value - and compare it to the other strings ('G','TEXT2').

Glad you got it working :)

PS if brackets arent your friend you can always do this

vox = " {grid.Object}.setValue('G','TEXT2',{Grid.RowNumber}, '{param1}{param2}'); "
vox=stritran(vox,"{param1}",z3) <<replaces {param1} with your z3 variable value
vox=stritran(vox,"{param2}",z4) <<replace {param2} with your z4 variable value

This is how a lot of mail merge and templating is done:

'define template
dim myemailtemplate as C="Hi {name}, Thank you for signing up. Your trial is active until {active_trial_date}"

while loop here-------------------------
' reset the template for each new client
dim new_email as C=myemailtemplate
new_email=stritran(newemail,"{name}",username)
new_email=stritran(newemail,"{active_trial_date}", date_Format(trialdate,"yyyy-MM-dd"))
send(new_email)
------------------------------------------end while loop

Hope you learned something useful :)


Its pretty useful to learn the stritran function.

:) enjoy

[gaby_h]

Re: Set Value in related grid with Ajax CB

Awesome, it makes more sense now. Pretty sure this will help other users too. Thanks again.

[aburningflame]

Re: Set Value in related grid with Ajax CB

Glad I could help.