Difference between revisions of "SQL Syntax Highlighting"
From Apache OpenOffice Wiki
(→Introduction) |
|||
Line 51: | Line 51: | ||
===code base=== | ===code base=== | ||
+ | ==Testing== | ||
+ | <source lang="mysql">select * from Table1 where field="neindanke" and field2=12</source> | ||
+ | <source lang="sql">select * from Table1 where field="neindanke" and field2=12</source> | ||
[[Category:Database]] | [[Category:Database]] |
Revision as of 18:31, 9 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 have syntax highlighting here: SQL keywords should be notable, literals should be distinguished, and the like.
People involved
Name | OOo Nickname | Role |
---|---|---|
Max Odendahl | mod | developer |
Roadmap
- it is currently planned to have this feature ready for OOoRelease31
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
code base
Testing
select * from Table1 where field="neindanke" and field2=12
SELECT * FROM Table1 WHERE FIELD="neindanke" AND field2=12