SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
CTE in Intellisense

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
CTE in Intellisense
Author Message
ssandu



Joined: 26 Feb 2007
Posts: 95
Country: Romania

Post CTE in Intellisense Reply with quote
I saw another suggestion with the same problem "Intellisense does not suggest the defined CTE as a candidate for table name in the FROM section of the SELECT following the definition of the CTE"
I suggest the same thing.\It would be nice.
Thank's

Sorin
Wed Jul 06, 2011 7:31 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7907

Post Reply with quote
Please try the latest build 6.0.33. That build supports CTE based suggestions. Please let us know if it doesn't work for you.
Wed Jul 06, 2011 8:24 am View user's profile Send private message
ssandu



Joined: 26 Feb 2007
Posts: 95
Country: Romania

Post Reply with quote
SysOp wrote:
Please try the latest build 6.0.33. That build supports CTE based suggestions. Please let us know if it doesn't work for you.

No it doesn't work on build 6.0.33
Sorry
Thu Jul 07, 2011 1:08 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7907

Post Reply with quote
Can you provide an example of non-working CTE suggestion? Perhaps there is some other issue in play.
Thu Jul 07, 2011 8:40 am View user's profile Send private message
ssandu



Joined: 26 Feb 2007
Posts: 95
Country: Romania

Post Reply with quote
Set NOCOUNT ON;
WITH mytest ( name, id )
(
SELECT s.name, s.id FROM syscolumns s --here appear mytest
)
SELECT * FROM mytest --here it not appear mytest if I press SPACE after FROM
Thu Jul 07, 2011 9:18 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.