Difference between revisions of "SQL Syntax Highlighting"

From Apache OpenOffice Wiki
Jump to: navigation, search
(Testing)
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:32, 9 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.

Issue 67961

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

Personal tools