Data Viewer

All data are displayed here. Data in the meaning of:

Changes in Data Viewer are handled in separate transaction. So you have to click Commit or Rollback buttons to promote them into database file.

Important

Transactions in the Data Viewer are separated from SQL Editor. You cannot commit your changes by COMMIT in the SQL Editor.

Data changes are available only for tables (invoked in Schema Browser). There is no way to edit data returned by SQL statement yet.

Data Viewer/Browser

Insert Row

Create new and empty record in the table. Default values are prefilled. Commit Action is required to make this permanent.

Delete Row

Delete current row from the table. Commit Action is required to make this permanent.

Delete All from table

Delete all records from table. Commit Action is required to make this permanent.

Note

Remember that this action does not "truncate" the table. You should use VACUUM if you need to reduce file size.

Commit

Promote changes from Data Viewer into database.

Rollback

Reject changes in Data Viewer.

Blob Preview

Open or close BLOB preview widget. Some binary data stored in BLOB cells can be examined and used as images. These values are shown then.

Data Export

Open the Data Export dialog. You can export currently selected data in various formats. See Data Export documentation.

Table Snapshot

Duplicate current result table into new read only window. You can compare data versions etc. with it.

Display Types

Full View

Display data as a table. It's the most common view on SQL results.

Item View

Display data as record after record. You will see only one record at all. This view is read only now.

Script Output

Describe action results and Run As Script from SQL Editor results are listed in this tab.

Data Editor

Basic data editation is handled directly in the table cell. Editation is invoked by double-click or Ctrl+Space.

Important

Remember that Sqlite recognizes NULL and empty string as two independent values. So inserting an empty strings does not mean you are inserting a NULL. Use NULL buttons to do it.

When the cell value is a multi line text or it is recognized as a BLOB, the Advanced Editor is opened automatically.

Simple Data Editor

Line edit.

Simple strings can be edited in this widget.

Set NULL Ctrl+Alt+N

Set the cell to the real NULL value.

Advanced Editor Ctrl+Alt+E

Open advanced editor. It allows you to edit multi line texts, BLOBs and the others special data formats.

Advanced Editor

This dialog is designed because the Simple Editor cannot handle advanced features comfortably. In some cases (BLOB, multiple lines of text in cell) is this dialog opened automatically when user requests editation.

Advanced Data Editor

When you accept changes in this dialog with OK button, only result of active tab will be promoted to the Data Viewer (to press the Commit button is required again). If is the Insert NULL option checked, only NULL is inserted.

Text tab

Full plain text editor. There is no rich text support.

Blob tab

Content of chosen file will be transferred into the cell as is. No data transformations are performed. Original value of the cell can be saved into local file with Save... button.

Date to String tab

A helper wizard for storing date and time in string values.

Important

Consult Sqlite manual for date and time problematics.

The Date item in this form can be set with pop-up calendar.

The String Format should be set with date time transform mask. Consult Qt4 documentation to explain its codes.

Example 7.2. Date to String

dd.MM.yyyy hh:mm.ss will produce e.g. "24.12.2007 18:30:45"

Fetching the data

Sqliteman uses progressive (step-by-step) fetching of data in the result set. It means that you don't need to wait until all data are transferred from database file to this result table.

When you call a select statement from table with e.g. thousands of records only the first part of records is physically fetched. Remaining records are available on demand - scrolling down in the result table will perform next fetch.

Message in the error log widget will inform you about this situation:

More rows can be fetched. Scroll the result set for more rows and/or read the documentation.