Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Syntax Highlighting

Jason210's profile image Jason210 posted 5 months ago in General Permalink

Hi

How is the syntax highlighting determined in HeidiSQL? Can it be edited?

I'm mostly interested in the SQL and procedural keywords. The procedural words are a different color to the standard MySQL words which are light blue. Is this standard to standard blue SQL keywords? I mean, is there a resource which I can look at which distinguishes these two categories of keywords?

Many thanks, Jason

ansgar's profile image ansgar posted 5 months ago Permalink

The color settings can be customized in Preferences > SQL:

Description

Jason210's profile image Jason210 posted 5 months ago Permalink

Thanks for the reply. I know about the preferences but wanted to know if there is anyway to customise this beyond using the GUI. I am confused by the PL/SQL setting and want to see which keywords are included in this category. I feel I should be able to edit this category.

Since I am using MySQL, I think there are some differences in the procedural syntax compared to PL/SQL, which is what is used with Oracle and PostgreSQL.

ansgar's profile image ansgar posted 5 months ago Permalink

These keywords are hardcoded in the SynEdit component. You can look them up in SynHighlighterSQL.pas on the SynEdit project on GitHub. There is no way for the user to edit them directly. I could change them for HeidiSQL, but if there are mistakes it would be better you send them a pull request with a fix.

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.