/usr/share/doc/sqliteman/en/ch07.html is in sqliteman-doc 1.2.2-0ubuntu6.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | <html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Chapter 7. Features and Dialogs</title><link rel="stylesheet" href="kde-default.css" type="text/css"><meta name="generator" content="DocBook XSL Stylesheets V1.67.2"><meta name="keywords" content="Sqliteman, SQL, Sqlite, development, database"><link rel="start" href="index.html" title="The Sqliteman Handbook"><link rel="up" href="index.html" title="The Sqliteman Handbook"><link rel="prev" href="ch06s05.html" title="The Help Menu"><link rel="next" href="ch07s02.html" title="Create Table"></head><body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">Chapter 7. Features and Dialogs</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="ch06s05.html">Prev</a> </td><th width="60%" align="center"> </th><td width="20%" align="right"> <a accesskey="n" href="ch07s02.html">Next</a></td></tr></table><hr></div><div class="chapter" lang="en"><div class="titlepage"><div><div><h2 class="title"><a name="id2525350"></a>Chapter 7. Features and Dialogs</h2></div></div></div><div class="toc"><p><b>Table of Contents</b></p><dl><dt><span class="sect1"><a href="ch07.html#preferences">Preferences</a></span></dt><dd><dl><dt><span class="sect2"><a href="ch07.html#id2525375">Look and Feel</a></span></dt><dt><span class="sect2"><a href="ch07.html#preferences-dataViewer">Data Display</a></span></dt><dt><span class="sect2"><a href="ch07.html#preferences-sqlEditor">SQL Editor</a></span></dt></dl></dd><dt><span class="sect1"><a href="ch07s02.html">Create Table</a></span></dt><dt><span class="sect1"><a href="ch07s03.html">Alter Table</a></span></dt><dd><dl><dt><span class="sect2"><a href="ch07s03.html#id2526118">Steps to alter table</a></span></dt></dl></dd><dt><span class="sect1"><a href="ch07s04.html">Import Table Data</a></span></dt><dt><span class="sect1"><a href="ch07s05.html">Populate Table</a></span></dt><dd><dl><dt><span class="sect2"><a href="ch07s05.html#id2526493">Column Settings</a></span></dt></dl></dd><dt><span class="sect1"><a href="ch07s06.html">View related dialogs</a></span></dt><dt><span class="sect1"><a href="ch07s07.html">Create Index</a></span></dt><dt><span class="sect1"><a href="ch07s08.html">Constraint Triggers</a></span></dt><dt><span class="sect1"><a href="ch07s09.html">Attached Databases</a></span></dt><dt><span class="sect1"><a href="ch07s10.html">Schema Browser</a></span></dt><dd><dl><dt><span class="sect2"><a href="ch07s10.html#pragmaEditor">Pragma Editor</a></span></dt></dl></dd><dt><span class="sect1"><a href="ch07s11.html">SQL Editor</a></span></dt><dt><span class="sect1"><a href="ch07s12.html">Data Viewer</a></span></dt><dd><dl><dt><span class="sect2"><a href="ch07s12.html#id2527777">Display Types</a></span></dt><dt><span class="sect2"><a href="ch07s12.html#dataViewer-editor">Data Editor</a></span></dt><dt><span class="sect2"><a href="ch07s12.html#dataViewer-advanced">Advanced Editor</a></span></dt><dt><span class="sect2"><a href="ch07s12.html#dataViewer-fetching">Fetching the data</a></span></dt></dl></dd><dt><span class="sect1"><a href="ch07s13.html">Export Data</a></span></dt><dd><dl><dt><span class="sect2"><a href="ch07s13.html#id2528452">Supported Formats</a></span></dt></dl></dd></dl></div><div class="sect1" lang="en"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a name="preferences"></a>Preferences</h2></div></div></div><p>Preferences dialog allows you to customize <span class="application">Sqliteman</span> to fit your needs better.</p><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a name="id2525375"></a>Look and Feel</h3></div></div></div><p>You can set GUI behavior in in this section. Remember that Language and Style settings require <span class="application">Sqliteman</span> restart to take effect. Some of these preferences can be overridden by the application
<a href="ch03.html#options" title="options">command line parameters</a>.</p><p>
</p><div class="screenshot"><div class="mediaobject"><img src="preferences-lnf.png" alt="Preferences: Look and Feel"></div></div><p>
</p><div class="variablelist"><dl><dt><span class="term">GUI Language</span></dt><dd><p>Allow to choose one of the translations for user interface.
</p><div class="caution" style="margin-left: 0.5in; margin-right: 0.5in;"><h3 class="title">Caution</h3><p>Remember that translations are provide by group of volunteers (not by <span class="application">Sqliteman</span> developers). It's better <a href="ch09.html" title="Chapter 9. Credits and License">to contact translation authors</a> in the case of bug.</p></div></dd><dt><span class="term">GUI Style</span></dt><dd><p>Change the application "skin". Available styles are depending on platform. Default style should be good choice.</p></dd><dt><span class="term">Recently Used Databases</span></dt><dd><p>Specify the count of items in the <span class="guimenu">File</span> <span class="guimenuitem">Recent Databases</span> menu.</p></dd><dt><span class="term">Open Last Database on Start</span></dt><dd><p>When it's checked, the last used database will be opened on the next <span class="application">Sqliteman</span> start.</p></dd></dl></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a name="preferences-dataViewer"></a>Data Display</h3></div></div></div><p>Change settings of the data result viewer here. There is no application restart required here.
Viewer features are <a href="ch07s12.html" title="Data Viewer">described in its own section</a>.</p><p>
</p><div class="screenshot"><div class="mediaobject"><img src="preferences-display.png" alt="Preferences: Data Display"></div></div><p>
</p><div class="variablelist"><dl><dt><span class="term">NULL handling</span></dt><dd><p>There is no difference in displaying NULL value and an empty string if is this option disabled.</p><p>If you enable this feature, you can set the background color and the substitution
string to highlight real NULL value. The empty string display is unchanged.</p></dd><dt><span class="term">BLOB handling</span></dt><dd><p>If is this option disabled, you will get unfiltered binary content of
the BLOB cell.</p><p>If you enable this feature, you can set the background color and the substitution
string to highlight real BLOB value.</p></dd><dt><span class="term">Limit Text Length Display</span></dt><dd><p>If it is enabled, the long data will be shortened in the result grid.</p></dd></dl></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a name="preferences-sqlEditor"></a>SQL Editor</h3></div></div></div><p>Change settings of the SQL editor here. There is no application restart required here.
SQL Editor features are <a href="ch07s11.html" title="SQL Editor">described in its own section</a>.</p><p>
</p><div class="screenshot"><div class="mediaobject"><img src="preferences-editor.png" alt="Preferences: SQL Editor"></div></div><p>
</p><div class="variablelist"><dl><dt><span class="term">Font</span></dt><dd><p>Specify font and font size. It's common and clever to use a non-proportional font for source code editor.</p></dd><dt><span class="term">Use Active Line Highlighting</span></dt><dd><p>The active line will be highlighted if is this feature set. Change its color with <span class="guibutton">Color...</span> button.</p></dd><dt><span class="term">Use Maximum Text Width Mark</span></dt><dd><p>When is this option set, the vertical line at the given column position will be shown. It's useful to keep coding standards.</p></dd><dt><span class="term">Use Code Completion With Length</span></dt><dd><p>The code completion will be allowed if is this feature set. The editor will show pop-up menu with matching words when the currently edited word grows on the threshold length.</p></dd><dt><span class="term">Use Editor Shortcuts</span></dt><dd><p>The editor shortcuts mechanism will be allowed if is this feature set.
Pressing <span class="guibutton">Define...</span> button will open a shortcut definition dialog.</p><p>You can define shortcuts and expansion in this sub-dialog:</p><p>
</p><div class="screenshot"><div class="mediaobject"><img src="preferences-shortcuts.png" alt="Preferences: Editor Shortcuts"></div></div><p>
</p></dd><dt><span class="term">Syntax Colors</span></dt><dd><p>Custom syntax highlighting colors can be defined here. Every button sets its syntax color. All is shown in the sample SQL statement preview.</p></dd></dl></div></div></div></div><div class="navfooter"><hr><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="ch06s05.html">Prev</a> </td><td width="20%" align="center"> </td><td width="40%" align="right"> <a accesskey="n" href="ch07s02.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">The <span class="guimenu">Help</span> Menu </td><td width="20%" align="center"><a accesskey="h" href="index.html">Contents</a></td><td width="40%" align="right" valign="top"> Create Table</td></tr></table></div></body></html>
|