Difference between revisions of "SQL Syntax Highlighting"
From Apache OpenOffice Wiki
| Line 8: | Line 8: | ||
{{issue|67961}} | {{issue|67961}} | ||
| − | ==People involved== | + | ==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=== | ||
| + | |||
| + | {| class="prettytable" border="1" | ||
| + | |||
| + | |- | ||
| + | |||
| + | ! 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=== | ||
{| class="prettytable" border="1" | {| class="prettytable" border="1" | ||
| Line 27: | Line 58: | ||
! developer | ! developer | ||
|} | |} | ||
| − | |||
| − | |||
| − | |||
==stuff not to forget== | ==stuff not to forget== | ||
* "Tools" - "Options" - "Fonts": | * "Tools" - "Options" - "Fonts": | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
* color settings in "Tools" - "Options" – "Appearance" | * color settings in "Tools" - "Options" – "Appearance" | ||
Revision as of 14:36, 10 July 2008
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