Change History and SQLinForm formatting

[Craig Healey]

I’ve not seen the exact issue mentioned here. I have the new Change History on and I quite like it. But when I use the SQLinForm plugin to format and highlight SQL, instead of a coloured sidebar, it changes the page’s background colour to orange/green. It also applies that formatting to all other pages going forward. I can restart NP++ to get back to a white background, but I lose my SQL text highlighting, though not the formatting.

Is this a bug in NP++, or SQLinForm? Their forum only suggests turning Display Change History completely off. Is there a setting that I’ve missed that will stop the page background being changed and just allow border highlighting from Change History, and text highlighting from the plugin?

[Alan Kilborn]

@Craig-Healey

Probably that plugin uses some of the same Scintilla resources that change-history uses?

Notepad++ had to change some of this stuff around, e.g. the “bookmark” id had to change, to avoid a conflict.

It seems as if the plugin authors of your plugin will have to do the same, if they are inclined to.

[Craig Healey]

@Alan-Kilborn OK, so it seems like I have to keep an eye out for plugin updates. Thanks

[Michael Vincent]

@Craig-Healey said in Change History and SQLinForm formatting:

OK, so it seems like I have to keep an eye out for plugin updates. Thanks

Seems the code is not public? It requires a paid license? I could quickly look at the code to see if it uses markers 21-24 which is usually the cause of this. And since it’s orange, my guess would be 23. Could also be use of inline indicators during the SQL lexing that is triggering this, though Notepad++ does not have Change History indicators turned on by default (only the margin markers).

Cheers.

[mpheath]

@Craig-Healey

The image in the link shows the margin in Notepad++ as hidden. Doing this hides the (Change History) margin markers and so the markers are shown as SC_MARK_BACKGROUND background colour in the document lines. Why the plugin may cause the margin to hide is questionable. I do not have the plugin to test.

Hiding or showing this margin does not seem to be in Notepad++ Preferences without turning off Change History. NppExec can change the width setting of the margin.

To show margin number 2

sci_sendmsg SCI_SETMARGINWIDTHN 2 9

or SCI_SETMARGINWIDTHN as a number reference if not recognized:

sci_sendmsg 2242 2 9

To hide the margin, set the 9 to 0. 9 is an estimate size to the original margin size.

Tested on Notepad++ v8.4.7 with NppExec v0.8.2 .

[Robert Rodriguez]

Just proposes turning Show Change History totally off. Is there a setting that I’ve missed

[Alan Kilborn]

@Robert-Rodriguez said in Change History and SQLinForm formatting:

turning Show Change History totally off. Is there a setting that I’ve missed

Consult the Change History FAQ.