SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
FEATURE: Selecting table functions from pop-up

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
FEATURE: Selecting table functions from pop-up
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 2109

Post FEATURE: Selecting table functions from pop-up Reply with quote
After typing SELECT and selecting a table-valued function from the pop-up, we can see a result eg. like this one:

Code:

SELECT
   oi.[schema_name],
   oi.table_name,
   oi.index_name1,
   oi.index_name2,
   oi.column_name,
   oi.column_pos
FROM
   util.ft_overlapping_indices oi


It would be nice if it could also add the brackets and optionally the input parameters too so that the result would be something like this:

Code:

SELECT
   oi.[schema_name],
   oi.table_name,
   oi.index_name1,
   oi.index_name2,
   oi.column_name,
   oi.column_pos
FROM
   util.ft_overlapping_indices(@param1, @param2) oi


I guess that could be achieved by tinkering with DB Queries but I don't know where to start and neither have time to experiment with it right now.
Mon Mar 28, 2011 6:39 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7849

Post Reply with quote
That is going to be the default behavior in the next version :-)
I'm running an internal pre-beta version which is already supporting that
Tue Mar 29, 2011 1:16 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2109

Post Reply with quote
Excellent :) I'm looking forward to seeing it. Any info on release date?
Tue Mar 29, 2011 2:18 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7849

Post Reply with quote
Sorry, no official date yet. So far we are expecting public beta to start in 2 to 3 weeks. But please don't take my word for that.
Thu Mar 31, 2011 8:32 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.