SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[SA 9.0.166 Pro] Show DDL pane shows some code green[FIXED]

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[SA 9.0.166 Pro] Show DDL pane shows some code green[FIXED]
Author Message
Mindflux



Joined: 25 May 2013
Posts: 616
Country: United States

Post [SA 9.0.166 Pro] Show DDL pane shows some code green[FIXED] Reply with quote
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 View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 1397

Post Reply with quote
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 View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 616
Country: United States

Post Reply with quote
gemisigo wrote:
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6502

Post Reply with quote
Thank you for reporting it. I have logged this bug under #SA0029891
Tue Oct 18, 2016 12:14 pm View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 616
Country: United States

Post Reply with quote
Code:

/*
 *
 *
 */
breaks the highlighting in "Show DDL" even more; The more lines the worse the 'logic creep' gets.

Conversion to:
Code:

-- multi
-- line
-- comments
-- like
-- this
-- don't
-- expose
-- problem


Also works OK
Tue Oct 18, 2016 4:31 pm View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 616
Country: United States

Post Reply with quote
This is fixed! yay!
Thu Nov 10, 2016 4:27 pm 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.