**

I have a requirement to allow one user to delete records from a form. I am creating a button that user can see and using the RUN PROCESS Delete action. Everything works fine but they get a message after it runs that says Entry no longer exists in the database, which is true. However, as an admin I can go to the toolbar and select Actions, Delete and that message doesn't appear, the results pane just refreshes. My question is how do I get my results pane to refresh after the RUN Process action so that error doesn't appear. Thanks

This posting was submitted via the Web interface

**

I think that I wrote a piece of workflow that did that sometime ago, and I seem to remember that I fixed that very problem that you are having by using an OLE send-keys action to send an F5 to refresh the search. While I know that would work, I want to say that there has to be an easier way to do it that I am just not able to think of right now... In any event I’ll look and see if I have the workflow that I used here somewhere.



Warm regards,



Adam D Pederson

Digital Celerity LLC





From: Action Request System discussion list(ARSList) [mailto:ARSLIST@ARSLIST.ORG] On Behalf Of Kevin Shaffer
Sent: Monday, December 22, 2003 10:29 PM
To: ARSLIST@ARSLIST.ORG
Subject: Delete Run Process



I have a requirement to allow one user to delete records from a form. I am creating a button that user can see and using the RUN PROCESS Delete action. Everything works fine but they get a message after it runs that says Entry no longer exists in the database, which is true. However, as an admin I can go to the toolbar and select Actions, Delete and that message doesn't appear, the results pane just refreshes. My question is how do I get my results pane to refresh after the RUN Process action so that error doesn't appear. Thanks

This posting was submitted via the Web interface
This posting was submitted via the Web interface

**
Adam,

I would be interested in that too!

Thanks,

rp

-----Original Message-----
From: Adam D Pederson [mailto:Adam.Pederson@DIGITALCELERITY.COM]
Sent: Tuesday, December 23, 2003 9:22 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Delete Run Process


**

I think that I wrote a piece of workflow that did that sometime ago, and I seem to remember that I fixed that very problem that you are having by using an OLE send-keys action to send an F5 to refresh the search. While I know that would work, I want to say that there has to be an easier way to do it that I am just not able to think of right now... In any event I'll look and see if I have the workflow that I used here somewhere.



Warm regards,



Adam D Pederson

Digital Celerity LLC





From: Action Request System discussion list(ARSList) [mailto:ARSLIST@ARSLIST.ORG] On Behalf Of Kevin Shaffer
Sent: Monday, December 22, 2003 10:29 PM
To: ARSLIST@ARSLIST.ORG
Subject: Delete Run Process



I have a requirement to allow one user to delete records from a form. I am creating a button that user can see and using the RUN PROCESS Delete action. Everything works fine but they get a message after it runs that says Entry no longer exists in the database, which is true. However, as an admin I can go to the toolbar and select Actions, Delete and that message doesn't appear, the results pane just refreshes. My question is how do I get my results pane to refresh after the RUN Process action so that error doesn't appear. Thanks

This posting was submitted via the Web interface This posting was submitted via the Web interface
This posting was submitted via the Web interface

**
We use
@@:Application-Delete-Entry "$SCHEMA$" $Request ID$
as the run process. They don't get an error, but in order to not see the record they need to refresh the screen.

-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:ARSLIST@ARSLIST.ORG]On Behalf Of Adam D Pederson
Sent: Tuesday, December 23, 2003 12:22 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Delete Run Process


**

I think that I wrote a piece of workflow that did that sometime ago, and I seem to remember that I fixed that very problem that you are having by using an OLE send-keys action to send an F5 to refresh the search. While I know that would work, I want to say that there has to be an easier way to do it that I am just not able to think of right now... In any event I’ll look and see if I have the workflow that I used here somewhere.



Warm regards,



Adam D Pederson

Digital Celerity LLC







From: Action Request System discussion list(ARSList) [mailto:ARSLIST@ARSLIST.ORG] On Behalf Of Kevin Shaffer
Sent: Monday, December 22, 2003 10:29 PM
To: ARSLIST@ARSLIST.ORG
Subject: Delete Run Process



I have a requirement to allow one user to delete records from a form. I am creating a button that user can see and using the RUN PROCESS Delete action. Everything works fine but they get a message after it runs that says Entry no longer exists in the database, which is true. However, as an admin I can go to the toolbar and select Actions, Delete and that message doesn't appear, the results pane just refreshes. My question is how do I get my results pane to refresh after the RUN Process action so that error doesn't appear. Thanks

This posting was submitted via the Web interface This posting was submitted via the Web interface

This posting was submitted via the Web interface

Here's one way to do it. Create the following actions in a single
active link.

1. Use the Run Process action Linda describes in her message below.

@@:Application-Delete-Entry "$SCHEMA$" $Request ID$

2. Do an Open Windows action where the Window Type is Modify, the
Display type is Split Window, and the Target Location is Current. In
the Form Detail section of the Open Window action, select the same
server and the same form name. Leave the Form View selection list with
the value of "(Clear)" to ensure the user's preferred view is opened.

3. Kill the old window with a Close Window action.

Now when the user clicks on the button, a new split window (modify +
results list) is opened with a refreshed results list that omits the
deleted record. It isn't perfect, but is does the job.

Personally, I think you should be able to call this statement from a
Run Process:

PERFORM-ACTION-TABLE-REFRESH 1020

...and the User tool should "take the hint" and refresh the results
list. Maybe someday.

--Tim Widowfield, UWIP


--- Linda Hill wrote:
> We use
> @@:Application-Delete-Entry "$SCHEMA$" $Request ID$
> as the run process. They don't get an error, but in order to not see
> the record they need to refresh the screen.
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:ARSLIST@ARSLIST.ORG]On Behalf Of Adam D Pederson
> Sent: Tuesday, December 23, 2003 12:22 AM
> To: ARSLIST@ARSLIST.ORG
> Subject: Re: Delete Run Process
>
>
> **
>
> I think that I wrote a piece of workflow that did that sometime ago,
> and I seem to remember that I fixed that very problem that you are
> having by using an OLE send-keys action to send an F5 to refresh the
> search. While I know that would work, I want to say that there has
> to be an easier way to do it that I am just not able to think of
> right now... In any event I'll look and see if I have the workflow
> that I used here somewhere.
>
>
>
> Warm regards,
>
>
>
> Adam D Pederson
>
> Digital Celerity LLC
>
>
>
>
>
>
>
> From: Action Request System discussion list(ARSList)
> [mailto:ARSLIST@ARSLIST.ORG] On Behalf Of Kevin Shaffer
> Sent: Monday, December 22, 2003 10:29 PM
> To: ARSLIST@ARSLIST.ORG
> Subject: Delete Run Process
>
>
>
> I have a requirement to allow one user to delete records from a
> form. I am creating a button that user can see and using the RUN
> PROCESS Delete action. Everything works fine but they get a message
> after it runs that says Entry no longer exists in the database, which
> is true. However, as an admin I can go to the toolbar and select
> Actions, Delete and that message doesn't appear, the results pane
> just refreshes. My question is how do I get my results pane to
> refresh after the RUN Process action so that error doesn't appear.
> Thanks
>
>

> UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org ) ARSList is hosted by QMX
> SUPPORT SERVICES at www.QMXS.com This posting was submitted via the
> Web interface
>


Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/

Another way to do it is if you have DSO you can call the DSO delete
record action.

Fred

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@ARSLIST.ORG] On Behalf Of Tim Widowfield
Sent: Sunday, December 28, 2003 4:12 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Delete Run Process


Here's one way to do it. Create the following actions in a single
active link.

1. Use the Run Process action Linda describes in her message below.

@@:Application-Delete-Entry "$SCHEMA$" $Request ID$

2. Do an Open Windows action where the Window Type is Modify, the
Display type is Split Window, and the Target Location is Current. In
the Form Detail section of the Open Window action, select the same
server and the same form name. Leave the Form View selection list with
the value of "(Clear)" to ensure the user's preferred view is opened.

3. Kill the old window with a Close Window action.

Now when the user clicks on the button, a new split window (modify +
results list) is opened with a refreshed results list that omits the
deleted record. It isn't perfect, but is does the job.

Personally, I think you should be able to call this statement from a Run
Process:

PERFORM-ACTION-TABLE-REFRESH 1020

...and the User tool should "take the hint" and refresh the results
list. Maybe someday.

--Tim Widowfield, UWIP


--- Linda Hill wrote:
> We use
> @@:Application-Delete-Entry "$SCHEMA$" $Request ID$
> as the run process. They don't get an error, but in order to not see
> the record they need to refresh the screen.
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:ARSLIST@ARSLIST.ORG]On Behalf Of Adam D Pederson
> Sent: Tuesday, December 23, 2003 12:22 AM
> To: ARSLIST@ARSLIST.ORG
> Subject: Re: Delete Run Process
>
>
> **
>
> I think that I wrote a piece of workflow that did that sometime ago,
> and I seem to remember that I fixed that very problem that you are
> having by using an OLE send-keys action to send an F5 to refresh the
> search. While I know that would work, I want to say that there has to

> be an easier way to do it that I am just not able to think of right
> now... In any event I'll look and see if I have the workflow that I
> used here somewhere.
>
>
>
> Warm regards,
>
>
>
> Adam D Pederson
>
> Digital Celerity LLC
>
>
>
>
>
>
>
> From: Action Request System discussion list(ARSList)
> [mailto:ARSLIST@ARSLIST.ORG] On Behalf Of Kevin Shaffer
> Sent: Monday, December 22, 2003 10:29 PM
> To: ARSLIST@ARSLIST.ORG
> Subject: Delete Run Process
>
>
>
> I have a requirement to allow one user to delete records from a form.

> I am creating a button that user can see and using the RUN PROCESS
> Delete action. Everything works fine but they get a message after it
> runs that says Entry no longer exists in the database, which is true.

> However, as an admin I can go to the toolbar and select Actions,
> Delete and that message doesn't appear, the results pane just
> refreshes. My question is how do I get my results pane to refresh
> after the RUN Process action so that error doesn't appear. Thanks
>
>


> UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org ) ARSList is hosted by QMX
> SUPPORT SERVICES at www.QMXS.com This posting was submitted via the
> Web interface
>


Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com