Let me get this straight ... You want the Macro to also be limited to the 1000 records returned.
You can go in on the server and set the Max Rows returned (for 5.0.1 check the server properties thru the Admin tool. I think the Advanced tab) Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Viki_kulkarni Sent: Thursday, January 20, 2011 1:01 AM To: [email protected] Subject: Macro not honoring the data retrival settings hi all, I have a macro running on a form that searches for all records on the form which has more than 1000 records. now we have set the max number of records to retrieve = 1000 in the user tools option. what we see is that when we make a search call explicit on that form we get only 1000 records as per the settings but if we perform the same search via a simple search macro we get more than 1000 records in fact we get the actual number of records. can any one share any idea how to avoid this?? we are on ARS 5.0.1 and user tool is 701. Thanks, Viki _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
