Difference between revisions of "SQL Syntax Highlighting"
From Apache OpenOffice Wiki
| Line 3: | Line 3: | ||
==Introduction== | ==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 | + | 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 support the users and to make the use more concinient. |
| − | {{issue|67961}} | + | The coresponding issue asking for this enhancement is {{issue|67961}}, while the cws for ongoing implementation is {{CWS|sqlsyntaxhighlighting}} |
| − | + | ||
| − | {{CWS|sqlsyntaxhighlighting}} | + | |
==Detailed Information== | ==Detailed Information== | ||
===Feature Description=== | ===Feature Description=== | ||
| + | |||
| + | Three new features will be implemented: | ||
| + | |||
| + | * Syntax highlighting will be added: SQL keywords, literals and the like will be notable. | ||
| + | * The SQL view will respect the settings from Tools-Options-Fonts, where you can set a font name as well as a font size | ||
| + | * To support users writing complex queries including bracket terms, matching characters will be shortly highlighted when pressing },)," or ' | ||
| − | |||
| Line 68: | Line 71: | ||
===end user=== | ===end user=== | ||
| − | * insert SQL code snippets | + | To further improve the usability, it would be nice to have the possibility to |
| + | |||
| + | * insert various SQL and user code snippets | ||
* code completion including SQL keywords, table and field names | * code completion including SQL keywords, table and field names | ||
| − | |||
===code base=== | ===code base=== | ||
| − | + | If the BASIC IDE as well as HTML source view only need regular MultiLineEdit functionality, the new code could be used for these two cases as well. This would get rid of a lot of code and would make it more maintainable. | |
[[Category:Database]] | [[Category:Database]] | ||
Revision as of 14:58, 15 July 2008
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 support the users and to make the use more concinient.
The coresponding issue asking for this enhancement is Issue 67961 , while the cws for ongoing implementation is CWS sqlsyntaxhighlighting
Detailed Information
Feature Description
Three new features will be implemented:
- Syntax highlighting will be added: SQL keywords, literals and the like will be notable.
- The SQL view will respect the settings from Tools-Options-Fonts, where you can set a font name as well as a font size
- To support users writing complex queries including bracket terms, matching characters will be shortly highlighted when pressing },)," or '
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
- color settings in "Tools" - "Options" – "Appearance"
Future work
end user
To further improve the usability, it would be nice to have the possibility to
- insert various SQL and user code snippets
- code completion including SQL keywords, table and field names
code base
If the BASIC IDE as well as HTML source view only need regular MultiLineEdit functionality, the new code could be used for these two cases as well. This would get rid of a lot of code and would make it more maintainable.
