SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[SA 6] - Select current statement

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[SA 6] - Select current statement
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 2109

Post [SA 6] - Select current statement Reply with quote
There is something funny happening when selecting current statement involving a CTE. The editor contains the following:
Code:

INSERT INTO @hova
(
   p1
   ,p2
)
VALUES
(41 ,1),(11020 ,2),(20497 ,3),(11022 ,6)


;
WITH my_cte AS (
   SELECT

.
.
.
)
SELECT * FROM my_cte AS mc

I have the cursor after SELECT. Pressing the hotkey for selecting current statement will select the INSERT statement instead of the SELECT within WITH, the WITH itself or the SELECT at the bottom.
Mon Oct 17, 2011 3:06 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7849

Post Reply with quote
Thank you. I will submit a new ticket for this issue.
Mon Oct 17, 2011 8:35 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2109

Post Reply with quote
Thank you. I have noticed that it selects commented lines after the current statement as well. Could you check that too, please?
Wed Oct 19, 2011 5:04 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7849

Post Reply with quote
Thank you. For the reference, ticket #SA16105 - based on notes in the ticket, a fix has been implemented, but not yet tested, currently waiting for testing and release, most likely as part of 6.1 maintenance release
Wed Oct 19, 2011 9:06 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.