 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
gemisigo
Joined: 11 Mar 2010 Posts: 2165
|
|
[SA 6] - Select current statement |
|
There is something funny happening when selecting current statement involving a CTE. The editor contains the following:
 |
 |
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 |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Thank you. I will submit a new ticket for this issue.
|
|
Mon Oct 17, 2011 8:35 am |
|
 |
gemisigo
Joined: 11 Mar 2010 Posts: 2165
|
|
|
|
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 |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
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 |
|
 |
|
|
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
|
|
|