Joe Willis sent me this solution offline. The child form still behaves the same. It sets a global Parent ID field and broadcasts an event. The parent entry picks up the event, and if it is the entry in global Parent ID, instead of refreshing the display window, it sets a display-only field to "Yes", and "Commit"s. The save updates the displayed data without refreshing the display window. (Obviously the display-only field can't have "Disable Change Flag" set.) Joe said to set the ar.conf file to suppress the warning about another user updating the record. I did have "Suppress-warnings: 61" but commented it out just to see what would happen, but I don't get that message. Maybe it is the wrong warning number. So far it seems to work. Thanks, Joe, Dwayne Martin James Madison University From: Martin, Dwayne - martinrd Sent: Friday, March 26, 2010 11:03 AM To: 'arslist@ARSLIST.ORG' Subject: FW: Refreshing parent form display following child action - Not solved afterall
I implemented the new system and was testing it, when I discovered a serious design flaw. Let's say a user opens a query of "Open" Parent entries. Then the user opens a Child subfile entry, and makes a change that changes data in the Parent entry, and the Parent is no longer "Open", it is "Completed." The Child entry sends an event that the Parent picks up and does "PERFORM-ACTION-TABLE-REFRESH 1020." This refreshes the table that is displaying the parent entry, and the entry no longer belongs in the table. If it is the only entry in the display, all the data disappears, the display turns grey, and a message says "No data to display." (That scared me. I thot I had deleted the entry. I don't know what happens if there is more than one entry. My guess is that the one you are editing will disappear and be replaced by the next in line.) Is there any way of refreshing the data on the entry being displayed, without removing it from the table displaying it if it no longer qualifies? Dwayne Martin James Madison University From: Martin, Dwayne - martinrd Sent: Wednesday, March 17, 2010 3:39 PM To: 'arslist@ARSLIST.ORG' Subject: RE: Refreshing parent form display following child action - SOLVED LJ, THAT WORKS! On receipt of the Event, the Active Link does "PERFORM-ACTION-TABLE-REFRESH 1020," and the new values display in the parent form even tho it is not the active window. THANK YOU! THANK YOU! THANK YOU! Dwayne From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: Wednesday, March 17, 2010 9:35 AM To: arslist@ARSLIST.ORG Subject: Re: Refreshing parent form display following child action ** Dwayne, Try the Application-Refresh-Table 1020...I always forget if it's refresh-table or table-refresh....but either way if you fire that on the parent form it causes that record to refresh the results list....the equivalent of an F5 in the client. ________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Martin, Dwayne Sent: Monday, March 15, 2010 11:42 AM To: arslist@ARSLIST.ORG Subject: Refreshing parent form display following child action ** Dear List, We have a parent form and a child sub-file form. We open the parent record, then click on a table row to open a child entry. When we update the child, it pushes a new value to the parent entry, and we would to see that new value automatically displayed. So, we have the child send an Event, which the parent picks up via an Active Link, which does an F5 keystroke to refresh the display. The trouble is, that even tho the parent is sending the F5, the child is the active window, so its display gets refreshed, not the parent's. I tried having the parent form "Set Focus" to one of its fields, hoping that that would activate the window, but it didn't. Any suggestions? Dwayne Martin James Madison University (ARS 7.1 p3, RH Linux server, Oracle 10.2 db) _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
