Quick info

The QuickInfo feature allows you to define what additional information can be displayed for a selected column in the Results window. The QuickInfo is a query defined for a particular column that is executed when the Quick Info command is run for the column.

Review how to:

Define new Quick Info Query
Use already defined Quick Info Query

Creating a Quick Info Query

To create the new Quick Info query select the Manage Quick Info Options command from the Tools menu or click the button on the Tools toolbar

The Quick Info Management dialog box allows you to create, edit or delete Quick Info queries. Each Quick Info Query is defined by providing the following information:

Columns	A column name (or columns names) for which a Quick Info query is defined. The EmployeeID is used in the example below
Name	A Name of the Quick Info query that will be displayed in the list of Quick Info Queries
Query	SQL statements that will be executed when the Quick Info Query command is run

It is possible to use two tags that are replaced by the appropriate value when a Quick Info query is executed:

{Value}

{<ColumnName>}

The '{Value}' tag will insert the selected cell value from the Quick Info column into the query.

The {<ColumnName>} tag allows you to refer to another column for the current row in the results set. The {ColumnName>} is replaced by the value of typed column for the row for which the Quick Info query is executed.

In this example we use the following query:

SELECT * from Employees where Employeeid = {value}

The example above looks for records from the 'Employees' table where the EmployeeID column is equal to the value of the EmployeeID for the row currently selected in the Results window.

It is possible to add many columns for which the same Quick Info query is defined using the for the Query edit box in the Quick Info management dialog box. The QuickInfoColumn Collection Editor allows you to add/remove additional columns for the Quick Info query:

Note: Only one Quick Info query can be defined for each column. But several columns can have defined the same Quick Info query.

Using Quick Info

To use the Quick Info query, simply right click a cell in a column for which the Quick Info query has been already defined and select the Quick Info command from the context menu as shown below.

Note: The Quick Info command is inactive if a column does not have the quick info query defined.

When the Quick Info command is executed, the following dialog is shown.

If the Leave Open option is selected then the Quick Info dialog box is always displayed on top. It is possible to click any cell in the results window and see the Quick Info query results updated immediately.