![SoftTree Technologies](templates/GreenTech/images/logo.gif) |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
Mindflux
Joined: 25 May 2013 Posts: 812 Country: United States |
|
[SA 9.0.166 Pro] Show DDL pane shows some code green[FIXED] |
|
I'm working on a new stored proc and when I use "show ddl" on the proc there are parts of the DDL window that are green that maybe shouldn't be and parts that are not green that should be.
You can see here that "BEG" in BEGIN TRY is green, it follows a comment.
Likewise you can see that --RMQ is not green, but the rest of that comment is. Likewise the "SE" in the first SELECT statement is green (again it follows a comment).
Then if you go a bit further down you'll see it repeats itself in that fashion.
It's almost like the comment parser gets confused at times?
It gets even funkier further down my SPROC.
You can see here, UP is green, the E at the end of false and the closing quotation mark is green, then the FR in FROM is green.. even further down (not shown) another E and quotation mark are green in that same statement.
Last edited by Mindflux on Thu Nov 10, 2016 4:26 pm; edited 1 time in total |
|
Tue Oct 18, 2016 10:05 am |
|
![](templates/GreenTech/images/spacer.gif) |
gemisigo
Joined: 11 Mar 2010 Posts: 2109
|
|
|
|
It only shows that some parts of your code aren't ripe yet :)
But heck, mine either. Have you tried that with code not containing any comments?
|
|
Tue Oct 18, 2016 10:11 am |
|
![](templates/GreenTech/images/spacer.gif) |
Mindflux
Joined: 25 May 2013 Posts: 812 Country: United States |
|
|
|
![](templates/GreenTech/images/quote_header.gif) |
![](templates/GreenTech/images/spacer.gif) |
It only shows that some parts of your code aren't ripe yet :)
But heck, mine either. Have you tried that with code not containing any comments? |
Not yet.
*Edit: if I take the block comment out from the top of the SPROC (the SQL Assistant refactor comment) the rest of the code seems to now parse correctly in the Show DDL window.
|
|
Tue Oct 18, 2016 10:12 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
Thank you for reporting it. I have logged this bug under #SA0029891
|
|
Tue Oct 18, 2016 12:14 pm |
|
![](templates/GreenTech/images/spacer.gif) |
Mindflux
Joined: 25 May 2013 Posts: 812 Country: United States |
|
|
|
![](templates/GreenTech/images/code_header.gif) |
![](templates/GreenTech/images/spacer.gif) |
/*
*
*
*/
|
breaks the highlighting in "Show DDL" even more; The more lines the worse the 'logic creep' gets.
Conversion to:
![](templates/GreenTech/images/code_header.gif) |
![](templates/GreenTech/images/spacer.gif) |
-- multi
-- line
-- comments
-- like
-- this
-- don't
-- expose
-- problem
|
Also works OK
|
|
Tue Oct 18, 2016 4:31 pm |
|
![](templates/GreenTech/images/spacer.gif) |
Mindflux
Joined: 25 May 2013 Posts: 812 Country: United States |
|
|
|
This is fixed! yay!
|
|
Thu Nov 10, 2016 4:27 pm |
|
![](templates/GreenTech/images/spacer.gif) |
|
|
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
|
|
|