Thanks Fred,
That’s what I suspected. I didn’t have too many ‘good macros’ to compare as I saw a number of them that had this same ‘problem’. I’m suspecting that the client tool is actually running that search twice. I haven’t done tests to confirm that but if those instructions appear twice within the macro I don’t see how it would perform it only once. I may have some clean up to do. I have no idea why they have these statements twice – these were perhaps developed by end users and not the developer is my best guess. Since the macro recording process does not actually display the contents of what it has already recorded, it might have been easy for the end user to repeat some actions without suspecting the consequence. Joe _____ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Grooms, Frederick W Sent: Monday, February 25, 2013 6:05 PM To: [email protected] Subject: Re: Suspect actions in a macro.. I just looked at a couple here (I can’t believe I still had some macros on a network share) were in the format of Set Working Schema Perform Query Form-open Form-entry-list Form-final: modify So, Yes I believe lines 5 and line 6 are unnecessary and can be deleted. Fred From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe D'Souza Sent: Monday, February 25, 2013 4:38 PM To: [email protected] Subject: Suspect actions in a macro.. ** When I used armacroed for checking out a macro definition, this is what it returned: 1) Set Current Working Schema to FormName (ServerName) 2) Perform Query Query bar -- '536871083' >= "$Start Date$" AND '536871083' <= "$End Date$" AND '536870932' = "Tier2 Customer Support" AND '7' = "Closed" 3) ** Unknown command ** Form-open: 4) ** Unknown command ** Form-entry-list: 0 5) Perform Query Query bar -- '536871083' >= "$Start Date$" AND '536871083' <= "$End Date$" AND '536870932' = "Tier2 Customer Support" AND '7' = "Closed" 6) ** Unknown command ** Form-entry-list: 0 7) ** Unknown command ** Form-final: modify☺@ I find it a little suspicious that the same action/query, is repeated twice. Since I did not develop it I cannot say with certainty if this was actually recorded twice. I suspect it was. Would this mean that this macro would perform that same query twice? I am yet to test the run of these macros to log if it actually runs the query twice. What do you’ll think? Is line 5 and 6 unnecessary and will repeat the query the second time? Joe _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
