Display pane

Saturday, 17 April 2010 22:17

The display pane is divided into three sections: the SQL Console, the Table Data and the Details pane. The latter two panes are tabbed in order to provide more display functions. Each of these functions is described in their respective sections below.

Sql console

SQL Console is the main working space. It is composed of a large text area.

In this area all the sql queries are to be inserted. After inputting the query, select it and hit the CTRL-RETURN shortcut in order to run the query. You can either select the text to be executed as a query, or simply run the line the cursor is at.

Parameters

You can add parameters to your queries using symbols '[', ']'. You can put the name or a short description of the parameter inside. Before executing the sql, a dialog will rise with the input field for the value of the parameter. You can put as many parameters as you need in the query.
These queries can also be saved as sqlmarks.
Examples:

select * from table_name where id = [value]

select * from table_name where colname like '[colname starts with]%'