|
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
ssandu
Joined: 26 Feb 2007 Posts: 95 Country: Romania |
|
CTE in Intellisense |
|
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 |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7907
|
|
|
|
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 |
|
|
ssandu
Joined: 26 Feb 2007 Posts: 95 Country: Romania |
|
|
|
|
|
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 |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7907
|
|
|
|
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 |
|
|
ssandu
Joined: 26 Feb 2007 Posts: 95 Country: Romania |
|
|
|
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 |
|
|
|
|
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
|
|
|