SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Q: OBJECT(...) macro result set order

 
Reply to topic    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: 2108

Post Q: OBJECT(...) macro result set order Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7847

Post Reply with quote
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 View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2108

Post Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7847

Post Reply with quote
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 View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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.