SoftTree Technologies Technical Support Forums Register • Search • FAQ • Memberlist • Usergroups • Log in Q: OBJECT(...) macro result set order      SoftTree Technologies Forum Index » SQL Assistant View previous topic View next topic Q: OBJECT(...) macro result set order Author Message gemisigo Joined: 11 Mar 2010 Posts: 2165 Q: OBJECT(...) macro result set order I wanted to change the order of the objects in the popup for OBJECT(...) macro and thought that adding ORDER BY to the Objects DB query would do the job. Alas, it seems I was wrong. Which DB query is the result set for OBJECT(...) macro based on? Mon Jun 13, 2022 6:22 pm SysOp Site Admin Joined: 26 Nov 2006 Posts: 7948 I'm pretty sure it's returning cashed data. I'm afraid you would need to use custom query $$..$$ in place of $OBJECT(...)$ Mon Jun 13, 2022 6:32 pm gemisigo Joined: 11 Mar 2010 Posts: 2165 How? I thought the $$...$$ macro was only capable of yielding a result set, I wasn't aware it was interactive and could trigger a popup for the user to choose from. Last edited by gemisigo on Tue Jun 14, 2022 9:09 am; edited 1 time in total Tue Jun 14, 2022 12:16 am SysOp Site Admin Joined: 26 Nov 2006 Posts: 7948 My bad, I think I misunderstood what you're saying. Indeed it's for non-interractive use only. Tue Jun 14, 2022 8:47 am Display posts from previous:  All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year  Oldest FirstNewest First     SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours Page 1 of 1   Jump to:  Select a forum ----------------SQL AssistantDB Audit, DB Mail, DB Tools24x7 Scheduler, Event Server, Automation SuiteTips & Snippets Repository You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum     Powered by phpBB © 2001, 2005 phpBB Group Design by Freestyle XL / Flowers Online.