SQL Syntax Highlighting
From Apache OpenOffice Wiki
Description
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.
stuff not to forget
- "Tools" - "Options" - "Fonts":
Text [ en-US ] = "Font settings for HTML and Basic sources" ;
Text [ en-US ] = "Font settings for HTML, Basic and SQL sources" ;
- color settings in "Tools" - "Options" – "Appearance"
Future work
end user
- insert SQL code snippets
- code completion including SQL keywords, table and field names