SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Auto-complete misplaces "AS" keyword for table fun

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Auto-complete misplaces "AS" keyword for table fun
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 2109

Post Auto-complete misplaces "AS" keyword for table fun Reply with quote
When selecting a table function from a popup after SELECT auto-complete misplaces the "AS" keyword. It is put in front of the brackets whereas it should be put between the closing bracket and the alias:
Code:

SELECT
   mtf.column1
   ,mtf.column2
   ,mtf.column3
FROM
   dbo.my_table_function AS() mtf

Tue Jul 24, 2012 4:36 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7849

Post Reply with quote
I'm unable to reproduce this behavior. In my test environment, after selecting a table function, I get the query code generated as in your example and cursor positioned within function brackets, there is no AS()

Code:
SELECT
   ts.record_id,
   ts.record_string
FROM
   dbo.tf_Split( | ) ts



Which exact actions did you take to produce the SQL statement with AS()
Tue Jul 24, 2012 9:47 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2109

Post Reply with quote
Yes, it works properly when you have Auto Add Aliases set to "Yes". Try with "Yes (with AS keyword)". Also, setting it to "No" will omit brackets.
Tue Jul 24, 2012 4:49 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7849

Post Reply with quote
Thank you very much for clarifications. I have submitted new bug report #SA0019977 to address this issue.
Tue Jul 24, 2012 5:43 pm 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.