If you have a direct SQL query in your workflow, you do not need to use either of these after the Query. The AR Server performs the commit after the successful execution of that query wherever a commit is required (in case of insert, update or delete).
Perform-Action-Apply is used for submitting in a submit or modify window and search in a search window while commit changes is used to push the values from a child window in a dialog box operation to the parent window after the child is closed, on fields where there was a mapping on window close between the parent and child window.. Joe From: Brittain, Mark Sent: Thursday, December 08, 2011 3:51 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Commit Changes vs PERFORM ACTION APPLY ** HI All, Commit Changes vs. PERFORM ACTION APPLY. Is one better to use than the other on ARS 6.3? I have one active link that populates data from a SQL query and a second active link to commit the changes. These were probably created under ARS 3 or 4. The Commit Changes does the job but always looking to smart way to do things. Thanks Mark Mark Brittain Remedy Developer NaviSite – A Time Warner Cable Company mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-317-2897 -------------------------------------------------------------------------------- This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"