SQL Lexer Style Question

[pjlasl]

SQL Lexer Style Question

[pjlasl]

OK...I figured out that I should be using Style.SQL.Identifier. Setting that to blue worked.

[jacobslusser]

The default style would be anything that doesn't get styled/classified in some other way. Most lexers are pretty comprehensive and will style nearly everything in the document in some way, leaving very little text in the default style. Most often this means the only unstyled/default text left by the lexer is whitespace.

Try making whitespace visible and see if that is where your default style is going:

scintilla.ViewWhitespace = WhitespaceMode.VisibleAlways;

[pjlasl]

I used the style.sql.identifier and it worked properly. I did have a question about style.sql.user1.... How do I get custom words like (COUNT, MAX) into that list so that I can use a different color on those?

[jacobslusser]

See the wiki article Automatic Syntax Highlighting. It contains a section on setting keywords. Following those instructions you would arrive at the possible keyword lists supported by the SQL lexer:

"Keywords",
"Database Objects",
"PLDoc",
"SQL*Plus",
"User Keywords 1",
"User Keywords 2",
"User Keywords 3",
"User Keywords 4"

i.e. keywords in list index 4 ("User Keywords 1") would be styled by Style.Sql.User1, etc...

[pjlasl]

Thank you. I saw the article and it worked great!