How do I find which colour to change in visual studio?

Question

0.00/5 (No votes)

See more:

VS2019

I have files in Visual Studio 2019 that have an SQL extension. The SQL contained within them is SQLite dialect. An example statement might be this:

INSERT INTO EstimateRevisions ( PK_id, revision, total_value, breakdown )
VALUES ( NULL, '', 0.0, '' ),

My problem is that the non-quoted value 0.0 appears as a fairly unreadable dark-red colour, but I can't find the appropriate setting in Tools | Options | Fonts and Colours to change this.

Can anyone suggest what the setting might be?

What I have tried:

I tried the ones prefixed 'SQL'.

I have tried clicking on every item in the list. There must be over a hundred now so I may have missed it. (By the way, am I the only one who thinks this part of VS is long overdue a big improvement? Listing all the colour settings in one long list is getting plain silly now there are so many.)

Posted 18-Jul-19 2:06am

Patrick Skelton

Updated 18-Jul-19 2:31am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2019-07-18T02:32:00

Solution 1

Check the extension type: VS "knows about" .SQL files, and will syntax highlight them correctly - for me, 0.0 comes up as black-on-white, which it inherits from the standard "Number" setting under "Tools...options...Environment...Fonts and Colours", "Display items: Number"

If your extension type is different, it may be considering it as a specific type, and overwriting it (for example, there is also "Display items: U-SQL - Number" which is separately configurable).

Posted 18-Jul-19 2:32am

OriginalGriff

v2

Comments

Patrick Skelton 19-Jul-19 3:47am

I'm not sure what you mean by the first part of your answer, the bit about 'knows about', but the 'Display Items: Numbers' did the trick. I must have missed it. I do think this list is getting stupidly long and needs a completely new interface. I also need to learn to read, maybe. :-|

Anyway, thank you! Problem solved and my eyes already feel better!

OriginalGriff 19-Jul-19 4:03am

:laugh:
It's getting kinda unwieldy, isn't it? I'm guessing that job was given to the intern, and devs at MS don't fiddle so they never noticed just how bad it is ...