Chapter 7. Features and Dialogs

Table of Contents

Preferences
Look and Feel
Data Display
SQL Editor
Create Table
Alter Table
Steps to alter table
Import Table Data
Populate Table
Column Settings
View related dialogs
Create Index
Constraint Triggers
Attached Databases
Schema Browser
Pragma Editor
SQL Editor
Data Viewer
Display Types
Data Editor
Advanced Editor
Fetching the data
Export Data
Supported Formats

Preferences

Preferences dialog allows you to customize Sqliteman to fit your needs better.

Look and Feel

You can set GUI behavior in in this section. Remember that Language and Style settings require Sqliteman restart to take effect. Some of these preferences can be overridden by the application command line parameters.

Preferences: Look and Feel

GUI Language

Allow to choose one of the translations for user interface.

Caution

Remember that translations are provide by group of volunteers (not by Sqliteman developers). It's better to contact translation authors in the case of bug.

GUI Style

Change the application "skin". Available styles are depending on platform. Default style should be good choice.

Recently Used Databases

Specify the count of items in the File Recent Databases menu.

Open Last Database on Start

When it's checked, the last used database will be opened on the next Sqliteman start.

Data Display

Change settings of the data result viewer here. There is no application restart required here. Viewer features are described in its own section.

Preferences: Data Display

NULL handling

There is no difference in displaying NULL value and an empty string if is this option disabled.

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.

BLOB handling

If is this option disabled, you will get unfiltered binary content of the BLOB cell.

If you enable this feature, you can set the background color and the substitution string to highlight real BLOB value.

Limit Text Length Display

If it is enabled, the long data will be shortened in the result grid.

SQL Editor

Change settings of the SQL editor here. There is no application restart required here. SQL Editor features are described in its own section.

Preferences: SQL Editor

Font

Specify font and font size. It's common and clever to use a non-proportional font for source code editor.

Use Active Line Highlighting

The active line will be highlighted if is this feature set. Change its color with Color... button.

Use Maximum Text Width Mark

When is this option set, the vertical line at the given column position will be shown. It's useful to keep coding standards.

Use Code Completion With Length

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.

Use Editor Shortcuts

The editor shortcuts mechanism will be allowed if is this feature set. Pressing Define... button will open a shortcut definition dialog.

You can define shortcuts and expansion in this sub-dialog:

Preferences: Editor Shortcuts

Syntax Colors

Custom syntax highlighting colors can be defined here. Every button sets its syntax color. All is shown in the sample SQL statement preview.