SQL Syntax Highlighting
From Apache OpenOffice Wiki
Contents
Introduction
The SQL view of the query designer, which displays, and allows to edit, raw SQL statements, currently is a mere text input field. It would be helpful especially to the unexperienced user to have syntax highlighting here: SQL keywords should be notable, literals should be distinguished, and the like.
Detailed Information
Feature Description
The SQL view will respect the settings from Tools-Options-Fonts, where you can set a font name as well as a font size
String additions and changes
| resource | Old String | New String |
|---|---|---|
| fontsubs.src FL_SOURCEVIEW | "Font settings for HTML and Basic sources" ; | "Font settings for HTML, Basic and SQL sources" ; |
Roadmap
- it is currently planned to have this feature ready for OOoRelease31
People involved
| Name | OOo Nickname | Role |
|---|---|---|
| Max Odendahl | mod | developer |
stuff not to forget
- "Tools" - "Options" - "Fonts":
- color settings in "Tools" - "Options" – "Appearance"
Future work
end user
- insert SQL code snippets
- code completion including SQL keywords, table and field names
