Refreshing Linked Grids

[clivevdmescht]

I'm having a problem refreshing a linked grid and would appreciate it if anybody maybe has an idea on how I can get around the following.

I have a Parent grid which has a linked grid. On the Linked Grid I have a button which opens a dialog and the user enters information which is posted to various other tables and also to the linked grid.

I want the linked grid to REFRESH when I close / submit the dialog.

Is there a way of doing this - None of the Dialog Action Script options work for this so I have to find another way.

I'm using version 11 and have the following Server-side AfterDialogValidate event which saves the values to the database / tables and closes the Dialog.
_________________________________________________________________________________________-
ExecuteServerSideAction("Save Data::Save Data")

if rtc.flagRecordWasSaved then

dim jsclose as c
jsclose = "var ele = $('mywindow'); if(ele) {{dialog.object}.closeContainerWindow(ele);}"
e.javascript = e.javascript + ";" + jsclose

end if
__________________________________________________________________________________________

I would assume I need a refresh parent / linked grid option in here somewhere, but can't seem to find the right method.

Any help on this will be great.

[gkpurcey]

Re: Refreshing Linked Grids

This is exactly what I am working on as well.
Did you every find a way to get this done?
The only way I could get the linked grid to refresh is to choose "All Rows" as what gets updated after the dialog submits.

[gkpurcey]

Re: Refreshing Linked Grids

Hi Clive,

I think I have found a way to accomplish this so that the linked grid refreshes and remains on the same record.

Here's what I did:

Assume a "master" grid with linked grid "A"

First, in the grid "A" component itself (not the "master" grid, but the linked grid component in this case "A"- hope that makes sense), I created a simple javascript function as follows:

function refresh() {
{grid.Object}.refresh();
}

I placed this function in the "Code" section of grid "A" under "Javascript functions"

Then, in the "afterDialogValidate" section, after my "insert" command is executed, I check for the success of the insert and if successful, I add the following javascript commands to be returned to the browser:

if flag = .f. then  
  e.javascript="alert('Error, Record was not inserted. Error was: " 
  e.javascript=e.javascript + cn.CallResult.text + "');"
else  
  'This is a successful Add
  e.javascript="alert('Record Added');"
  e.javascript = e.javascript + "$('{dialog.ComponentName}.V.R1.BUTTON_PRINT').disabled = false;"  
  e.javascript = e.javascript + "refresh();"
  
end if

So here is what the javascript that I am sending back to the browser will do:

First, it displays an alert window notifying that the add was successful.
Next it concatenates another javascript command which enables a print button on my dialog.
Then it concatenates one more javascript command which calls the "refresh()" function on the calling grid, and this performs the update of the linked grid.

The javascript executes all three of these commands sequentially.

This works for me. It may not be a good idea to write a function called refresh(), as this is one of the built in functions, but the system seems to be able to keep them separate.

By the way, in case anyone is wondering, here is how I disabled the print button on the dialog initially:

In the dialog's onDialogInitialize event, I have : e.javascript = "$('{dialog.ComponentName}.V.R1.BUTTON_PRINT').disabled = true;"

Hope this helps.

[Charles Hoens]

Re: Refreshing Linked Grids

Thanks for this post. I've tried it out and it just isn't working for me. The Record Added box pops up, but the dialog does not close nor does the grid refresh. I tried this both with and without the print disabled. Here is my code in the AfterDialogValidate event.

function afterDialogValidate as v (e as p)


dim rtc.flagRecordWasSaved as l
'To edit this action, place insertion point anywhere in the command, then click the 'Action Scripting' button'.
ExecuteServerSideAction("Save Data::SaveUser")
if rtc.flagRecordWasSaved
'To edit this action, place insertion point anywhere in the command, then click the 'Action Scripting' button'.
ExecuteServerSideAction("Save Web Security Values::SaveSecurity")
end if
if rtc.flagRecordWasSaved = .f. then
e.javascript="alert('Error, Record was not inserted. Error was: "
e.javascript=e.javascript + cn.CallResult.text + "');"
else
'This is a successful Add
e.javascript="alert('Record Added');"
'e.javascript = e.javascript + "$('{dialog.apassword1}.V.R1.BUTTON_PRINT').disabled = false;"
e.javascript = e.javascript + "refresh();"

end if
end function

Anything I am doing wrong?

Charlie

[gkpurcey]

Re: Refreshing Linked Grids

Charlie,

I can offer only a couple of guesses.

Since you have it commented out, I don't think this would be the main cause, but in your next to the last line where you have:

'e.javascript = e.javascript + "$('{dialog.apassword1}.V.R1.BUTTON_PRINT').disabled = false;"

you should not put your dialog name into the code. I believe you wat to use the placeholder {dialog.ComponentName}

Also, you did not mention it, but be sure you have the javascript function "refresh ()" defined in the javascript code of your linked grid.
I would put an "alert('Calling refresh function');" or something similar into the refresh() function to be sure your code is getting there.

My code does not attempt to close the dialog so you should not expect that to happen just with my code.

Also, the button that opens the dialog on my application uses the Javascript "Open a dialog component" action script. The builder for this has a property called "Refresh Grid on Window Close" and mine is set to "Current Row".

Beyond these suggestions, I'm not sure what else could be the problem.

[Charles Hoens]

Re: Refreshing Linked Grids

What version are you using? I'm using V11 and I don't see the option of Refresh Grid on Window Close in my dialog builder.

[gkpurcey]

Re: Refreshing Linked Grids

I am also using V11, and that option is not a property of the dialog builder, rather it is a property of the Action Javascript when you "Open A Dialog Component".
In other words, when you define the javascript action for a button, you have the ability to use Action Javascript to create that action, and when you do that, and select "Open A Dialog Component", that builder will have the "Refresh Grid on Window Close" property.

Having said that, however, I still had to use my "refresh()" javascript function for the linked grid to be refreshed.