search

google-code-export / notepad2-mod

Automatically exported from code.google.com/p/notepad2-mod
Other
2 stars 1 forks source link

Syntax hinghlight error on MS SQL temp tables #80

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
Enter sample script like this^

SELECT *
FROM (
  SELECT ID
  FROM Table m WITH(NOLOCK)
    LEFT JOIN (SELECT ID FROM #Table WHERE ID > 0) t ON t.ID = m.ID
) t

and move to the first brace "(". It seems to be an error matching brace. But is 
we rewrite script like

SELECT *
FROM (
  SELECT ID
  FROM Table m WITH(NOLOCK)
    LEFT JOIN (SELECT ID FROM #Table WHERE ID > 0
  ) t ON t.ID = m.ID
) t

it'll be all correct

Noteapd2-mod v.4.2.25 rev. 735
MS Windows XP SP3

Original issue reported on code.google.com by alexey.b...@gmail.com on 29 May 2012 at 6:44

GoogleCodeExporter commented 9 years ago 
Not something specific to Notepad2-mod. Probably a Scintilla issue which means 
you should report such problems to them not to me.

Original comment by XhmikosR on 29 May 2012 at 11:31

GoogleCodeExporter commented 9 years ago 
Thnx, will send request to them ;-)

Original comment by alexey.b...@gmail.com on 29 May 2012 at 5:28

GoogleCodeExporter commented 9 years ago 
Already resolved by 
http://sourceforge.net/tracker/index.php?func=detail&aid=3098071&group_id=2439&a
tid=352439

Couldn't you add support for lexer.sql.numbersign.comment?

...Committed but with the name changed to lexer.sql.numbersign.comment since
properties that start with lexer.<lexerName> will be automatically found by
the scripts that update SciteProps.cxx and SciTEDoc.html...

Best regards, me

Original comment by alexey.b...@gmail.com on 29 May 2012 at 5:42

GoogleCodeExporter commented 9 years ago 
I'll see what I can do but 1) this lexer is intact from Notepad2 and 2) I don't 
use it myself

Original comment by XhmikosR on 29 May 2012 at 9:46

GoogleCodeExporter commented 9 years ago 
If you have a look at the source you will see that this property was already 
enabled.

http://code.google.com/p/notepad2-mod/source/browse/trunk/src/Styles.c#2004

Something is wrong in Notepad2's code since this happens with other lexers. 
Feel free to provide a patch or bug Florian Balmer, the Notepad2 author.

Original comment by XhmikosR on 24 Jul 2012 at 4:58

GoogleCodeExporter commented 9 years ago

Original comment by XhmikosR on 24 Jul 2012 at 4:59