Dialog must update on closing pop-up window

[Rida Alhasan]

.
Hi,
I have two dialogs in a parent-child setup. Both get their data from the same Students table. This is the Students table:

student_id	student_name	student_height (cm)
1	Peter Smith	182
2	Joan Black	165
3	Henry Higgins	177
4	Mary Malone	159

• The parent dialog is a read-only dialog. It contains a Repeating Section with the student_name and student_height, plus a Modify button that opens a child dialog in a pop-up window.
  

  Peter Smith	182	MODIFY
  Joan Black	165	MODIFY
  Henry Higgins	177	MODIFY
  Mary Malone	159	MODIFY

• The child dialog is a simple dialog that it is updatable. It contains the student_name and the student_height corresponding to the row clicked in the first dialog, plus an Update button.
  

  Student name	Henry Higgins
  Student height	177
  		UPDATE

What should happen:
When the user opens the child dialog to modify a student's name or height and then clicks on the Update button:

A) The data in the Students table is modified
B) The pop-up child dialog closes
C) The student's data in the parent dialog displays the modifications

Thank you,
Felix
.

[mhammond71]

Re: Dialog must update on closing pop-up window

Here is a video to illustrate a working solution to you post. Hope this helps.

http://screencast.com/t/zJBGTXBDT

[agillbb]

Re: Dialog must update on closing pop-up window

Have you tried emitting some js at the end of your afterDialogValidate xBasic event?

e.javascript = "setTimeout(function() {var po = {dialog.Object}.getParentObject(); if(po) {po.populateControlsFromTable('123');} },200);"
e.javascript = e.javascript + crlf() + "var ele = $('{dialog.ComponentName}.R1'); + crlf() + {dialog.object}.closeContainerWindow(ele);"


Of course, you need to modify this code to include your primary key (instead of 123).

[Rida Alhasan]

Re: Dialog must update on closing pop-up window

Hi Andy,
Thank you for the tips. I've been struggling to make it work, but no luck yet. I would be grateful if you could give me a more extended counseling.

In the child pop-up dialog, I've added your code in Events - Server-side - afterDialogValidate. I've placed it after the code that saves the submitted data.

ExecuteServerSideAction("Save Data::Save_Submitted_Data_to_STUDENTS")

e.javascript = "setTimeout(function() {var po = {dialog.Object}.getParentObject(); if(po) {po.populateControlsFromTable('3');} },200);"
e.javascript = e.javascript + crlf() + "var ele = $('{dialog.ComponentName}.R1'); + crlf() + {dialog.object}.closeContainerWindow(ele);"

As I understand, when the user clicks the Update button, the database record shown in the child dialog is modified and then line one of your code goes into action: it retrieves record number 3 and after 200 milliseconds updates the parent dialog. Then line two of your code closes the window. But I must be missing something or not understanding it right because I cannot make it work ...



Regards,
Felix
.

[mhammond71]

Re: Dialog must update on closing pop-up window

Felix,

I posted a video on here Friday. Don't know what happened to it. Here is another link.

http://www.screencast.com/t/zJBGTXBDT

[mhammond71]

Re: Dialog must update on closing pop-up window

Felix,

Did you get this working? I have an example that I built on the Alphasport sample database. I am happy to send it to you.

Max

[Rida Alhasan]

Help: how to update parent dialog automatically when child dialog closes

.
Max,
No, I have not been able to make it work. I'd be grateful to get hold of your example.



Regards,
Felix
.

[mhammond71]

Re: Help: how to update parent dialog automatically when child dialog closes

Here you go. I am sorry. I posted a video on this for you Friday but apparently the blog will not allow the link to post. I did not realize until earlier that it did not post.

[Rida Alhasan]

Help: how to update parent dialog automatically when child dialog closes

.
Max,
I've already downloaded your zip file and opened it in Alpha Five v11. I'm now going to see the innards.


Thank you,
Felix
.

[J.R. Noe]

Re: Dialog must update on closing pop-up window

Felix, I have a dialog that is set up about the same way. When I click a button in the repeating section, it opens a dialog where edits can be made, and when closed the repeating section row is updated. Here is how I do it, although I am not 100% sure it is the best way.

To make sure it stays on the current record in the repeating section, I set a page variable called "_myRSActiveRow" as a number on the parent dialog, and put this in the Client side events:

if(typeof {dialog.object}._myRSActiveRow != 'undefined') {
{dialog.object}.setRepeatingSectionActiveRow('CONTAINER_5',{dialog.object}._myRSActiveRow);
{dialog.Object}.setFocus('NARCBARCD', {dialog.object}._myRSActiveRow);
delete {dialog.object}._myRSActiveRow
}

the button in the repeating section is setup to "Open a dialog component", and in the window javascript events: onBeforeHide I put this code:

var data = {dialog.object}.getValue('ID');
{dialog.Object}.submit();
{dialog.object}.populateControlsFromTable(data,false);

[Rida Alhasan]

Re: Dialog must update on closing pop-up window

.
J.R.,
Thank you for the code and indications. Would you please tell me if the following assumptions are right:

A) NARCBARCD is a field in the Repeating Section of your dialog
B) "_myRSActiveRow" is defined as numeric, and is a LOCAL variable --> dim _myRSActiveRow as N
C) In which Client-side event do you place the code if(typeof {dialog.object}... ?
D) In var data = {dialog.object}.getValue('ID'); , ID is the primary key of the table of the dialog that gets opened




Regards,
Felix
.

[J.R. Noe]

Re: Dialog must update on closing pop-up window

Yes, NARCBARCD is a field which gets the focus once the update is complete.
Yes, _myRSActiveRow is defined as numeric and I have it set as a page variable and defined in the dialogs properties:arguments.
I forgot to say where that code goes. Sorry. It goes in the "afterPopulateFromTable" in the Client side events.
ID is my unique ID field on the dialog. It has been a long time since I did this, but you may not need that line. Try it with and without.

[Rida Alhasan]

Re: Dialog must update on closing pop-up window

.
Andy,
Max,
JR,
Thanks to your tips and indications, I finally got it working. Due to the characteristics of my dialogs, I used JR's solution. Since my parent dialog is read-only, I only needed the onBeforeHide code. JR gave this:

var data = {dialog.object}.getValue('ID');
{dialog.Object}.submit();
{dialog.object}.populateControlsFromTable(data,false);

I deleted the submit line and left it like this:

var data = {dialog.object}.getValue('ID');
{dialog.object}.populateControlsFromTable(data,false);

Without the submit line, it updates twice as fast. (Of course, where JR has 'ID', I placed my corresponding primary key).



Thank you again to all,
Felix
.

[J.R. Noe]

Re: Dialog must update on closing pop-up window

Glad you got it working Felix. You have helped me more than once in the past, so I am glad I had a small part in repaying the favor.

-JR