Re: Refreshing parent form display following child action - Not solved afterall
Dwayne, That's the nature of the results listif the entry you are editing is the only one in the list and you modify it so it doesn't qualify for that list anymore, then you get that message 'no data'the only way to avoid it is to make it so that the results list is not dependent on a qual other than something that won't cause that entry to be removed because of it's status...you could do that by generating a console of 'open' parent entriesto do the process you are describing they would dbl click on a table for example to get into that entry...once in that entry you can refresh the 1020 table all you want and it won't cause the entry to be removed _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Martin, Dwayne Sent: Friday, March 26, 2010 9: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-refreshbut either way if you fire that on the parent form it causes that record to refresh the results listthe 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_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Refreshing parent form display following child action - Not solved afterall
Thanks, LJ, This is what I figured. I was hoping that somebody had some magical way around the problem. I can hardly control what queries the users are allowed to run, so I guess abandon the project. But it was fun while it lasted! Dwayne From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: Monday, March 29, 2010 1:13 PM To: arslist@ARSLIST.ORG Subject: Re: Refreshing parent form display following child action - Not solved afterall ** Dwayne, That's the nature of the results listif the entry you are editing is the only one in the list and you modify it so it doesn't qualify for that list anymore, then you get that message 'no data'the only way to avoid it is to make it so that the results list is not dependent on a qual other than something that won't cause that entry to be removed because of it's status...you could do that by generating a console of 'open' parent entriesto do the process you are describing they would dbl click on a table for example to get into that entry...once in that entry you can refresh the 1020 table all you want and it won't cause the entry to be removed From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Martin, Dwayne Sent: Friday, March 26, 2010 9: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-refreshbut either way if you fire that on the parent form it causes that record to refresh the results listthe 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_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Refreshing parent form display following child action - Not solved afterall
Sure you can control itwhy wouldn't you be able to :).if you don't want them opening the form in search mode, have an AL that looks for that operation, if it finds it close the form and open your control panel:) _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Martin, Dwayne Sent: Monday, March 29, 2010 11:20 AM To: arslist@ARSLIST.ORG Subject: Re: Refreshing parent form display following child action - Not solved afterall ** Thanks, LJ, This is what I figured. I was hoping that somebody had some magical way around the problem. I can hardly control what queries the users are allowed to run, so I guess abandon the project. But it was fun while it lasted! Dwayne From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: Monday, March 29, 2010 1:13 PM To: arslist@ARSLIST.ORG Subject: Re: Refreshing parent form display following child action - Not solved afterall ** Dwayne, That's the nature of the results listif the entry you are editing is the only one in the list and you modify it so it doesn't qualify for that list anymore, then you get that message 'no data'the only way to avoid it is to make it so that the results list is not dependent on a qual other than something that won't cause that entry to be removed because of it's status...you could do that by generating a console of 'open' parent entriesto do the process you are describing they would dbl click on a table for example to get into that entry...once in that entry you can refresh the 1020 table all you want and it won't cause the entry to be removed _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Martin, Dwayne Sent: Friday, March 26, 2010 9: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-refreshbut either way if you fire that on the parent form it causes that record to refresh the results listthe 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
Re: Refreshing parent form display following child action - Not solved afterall
It depends on what you mean by can. I CAN stop people from running queries, but then they'd fire and the next guy would let them do all sorts of stuff they shouldn't. Is it Friday yet? Dwayne From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: Monday, March 29, 2010 1:26 PM To: arslist@ARSLIST.ORG Subject: Re: Refreshing parent form display following child action - Not solved afterall ** Sure you can control itwhy wouldn't you be able to :).if you don't want them opening the form in search mode, have an AL that looks for that operation, if it finds it close the form and open your control panel:) From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Martin, Dwayne Sent: Monday, March 29, 2010 11:20 AM To: arslist@ARSLIST.ORG Subject: Re: Refreshing parent form display following child action - Not solved afterall ** Thanks, LJ, This is what I figured. I was hoping that somebody had some magical way around the problem. I can hardly control what queries the users are allowed to run, so I guess abandon the project. But it was fun while it lasted! Dwayne From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: Monday, March 29, 2010 1:13 PM To: arslist@ARSLIST.ORG Subject: Re: Refreshing parent form display following child action - Not solved afterall ** Dwayne, That's the nature of the results listif the entry you are editing is the only one in the list and you modify it so it doesn't qualify for that list anymore, then you get that message 'no data'the only way to avoid it is to make it so that the results list is not dependent on a qual other than something that won't cause that entry to be removed because of it's status...you could do that by generating a console of 'open' parent entriesto do the process you are describing they would dbl click on a table for example to get into that entry...once in that entry you can refresh the 1020 table all you want and it won't cause the entry to be removed From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Martin, Dwayne Sent: Friday, March 26, 2010 9: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-refreshbut either way if you fire that on the parent form it causes that record to refresh the results listthe 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
