How to Refresh Detail Form in Master Derail Application.

Scriptcase 8 Discussion
#1

I have a Master Detail Application , When i OnBlur from particular field then i am inserting some data in Detail form, I just want to know how to auto refresh detail form when i am moving out from particular field.

#2

I had a similar problem at one point. I did not find a way to refresh the detail form as such, but found an acceptable solution for my application: Doing a refresh on the master application using the sc_redir macro to call it again (i.e. from itself). As for for the detail form, I just made sure that the block (in the main application) containing it was defined to be started open – specified under Layout->Blocks, “Collapse” column. Thus when the main form was reopened, the detail form would show new data right away.

Perhaps this could work for you to.

#3

You can use JavaScript and force the detail iframe to reload

#4

Interesting!
If an action in the master application updates the database table that is the basis of the detail form (e.g. an editable grid view with several lines), will such an iframe reload really get new data in the table in the database to show in the detail form?

#5

i am not finding proper solution for this issue. i am temporarily using auto refresh the detail form using HTML code in onLoad Event.

<meta http-equiv=“refresh” content=“5”/>

My detail form auto refresh every 5 seconds. I think this is not the proper solution.

Thanks Giu please share with me the JavaScript code for reloading the detail block. it is quite urgent for me.

Regards.

#6

It should. Reload the iframe means to select against database.

Amit, if I get time I will do it

#7

@Giu Thanks

#8

@AmitGK

[video=youtube_share;OUio77S6kW0]https://youtu.be/OUio77S6kW0[/video]

4 Likes
#9

@Giu

Thank you so much that you took so much initiative to prepare this video, Its really a great help from your side for me.
I feel many people will be benefited by your video.

Thanks

Regards

#10

@Giu

Great video.
Very useful when things don’t work, to see how you fix it.
Thanks!

#11

[SIZE=14px]Hi,[/SIZE]
[SIZE=14px]I’m using the technique in Giu’s excellent video to reload the detail iframe in SC9 when I change a dropdown on the master with linked value, but the detail form does not reload data from the database.[/SIZE]

[SIZE=14px]Dropdown (select) is on field ID in master form. ID is linked to SUBCAT_ID on detail form.[/SIZE]

[SIZE=14px]My AJAX php code in OnChange event in dropdown:[/SIZE]
[SIZE=14px]sc_ajax_javascript(‘refresh_iframe’);[/SIZE]

[SIZE=14px]The refresh_iframe javascript function:[/SIZE]
[SIZE=14px]document.getElementById(‘nmsc_iframe_liga_form_dbo_ITEM’).contentDocument.location.reload(true);[/SIZE]

[SIZE=14px]The subform seems to reload, but the data is not refreshed. I also check in database, SC is not requerying the database.[/SIZE]

#12

I have a need to refresh the header of the form.

I use sc_label to modify the detail header on load. However, when I modify detail data,the header is refreshed and I lose my changes.
I need either to prevent the header refresh, or find a way to redo my changes but I dont know where to place that code

#13

i think when you refresh the header takes the original value of the title header.

Maybe when you use a global variable to define the header. So onLoad change the global to the desired value and SC will takes the value of the global. Haven’t tried it but i guess it should work.

onload:

[glo_header_title] = 'modified title';
#14

@Giu

Thank you so much for sharing the Video.
It helps to refresh the detail iframe.
What can I do if I want to refresh the master from the detail iframe.

​​​​​​​Thank you!

#15

It Works !!

sc_redir macro, reload master (and defail form) very smothly.

Thank you, Orion…!