4. Menus

4.1 Desktop menu

4.1.1 JDBC

Connect

Opens the connection dialog, allowing you to make a (new) connection to the database server.

4.1.2 Tools

Quick Query

Opens the Quick Query tool, allowing you to quickly execute a one-line query

Quick Builder

Opens the Quick Builder tool for simple interactive query design.

Query Builder

Opens the Query Builder tool for advanced interactive query design.

Custom Query

Opens the Custom Query window, allowing you to execute larger queries and load text files.

Files

A list of files in the base path of the Custom Query window. If a file is slected, its contents are sent to the database as a query.

Main table

Opens the main table

New Table

Opens a new, empty table.

File Reader

Opens the File Reader dialog

Options

Opens the dialog for editing program-wide options.

4.1.3 Desktop

Shows a list with all the windows that are open on the desktop. Selecting on will bring it to the front.

4.2 Table menu

4.2.1 Options

Load File

Loads a delimited text file into the table.

Save File

Saves the data in the table to a delimited text file.

Save to DB

Save the data in the table to the database.

Clear

Clears the content of the table.

Remove duplicates

Removes the duplicate record, based on id number. I.e. if there are two records with the same id number, the last one is removed.

Gather to disk

Brings up the Gather dialog, used to collect the files in the table from their different medaia, and copy them to the harddisk.

Append mode

Indicates whether the table is in append mode. If in append mode, subsequent selections into the table are appended after the last record. Otherwise, the table is cleared before each new selection.

4.2.2 Database

DB Sync

Selects the table to where updates are comitted.

Update

Commits all changes made to the database.

Clear History

Deletes all updates from the queue, without comitting them to the database. Not however, that the contents of the table are not restored.