Follow-On Topics

Related Topics

# About the Columns Pane

The Columns pane is used to specify the columns that are returned in the query. The Columns available are displayed on the left of the dialog in the OLEDB or ODBC Schema. Formula Columns can also be created on the fly to provide manipulation of data whether for formatting or calculations.

Adding Columns to the Query

Columns can be added to the query using two methods:

Method 1

1. Ensure the Columns pane is visible and expanded.
2. Locate the column required in the Schema.
3. Drag the column from the schema on the left to the Columns pane.
4. Drop the column at the required point in the columns that have already been added to the query, thus controlling the order in which the columns are requested. The point at which the column is inserted is indicated by a red "I" bar.

NOTE:

The order in which columns are returned from a query does not always match the order in which they are selected. Some drivers demand that certain types of field are moved to the start or end of the columns returned.

Method 2

1. Ensure the Columns pane is visible, expanded and selected.
2. Locate the column required in the schema.
3. Double-click on the Column within the schema.
4. The Column is appended to the Columns already selected.

If a column is selected more than once, an incrementing number is appended to the column name.

Changing the Column Order

Columns may be re-ordered by dragging and dropping them to the left or right of another column.

Removing a Column

To remove a Column from the Query, right-click on the Column and click Remove from the context menu.

Using Selected Columns in Other Query Panes

|  | It is possible to use the Columns that are already selected within other parts of the query. This eliminates the need to go back to the ODBC Schema or Data Model to locate the columns again.

|  | To use a Column selected in another part of the query, simply drag and drop the Column to the relevant query pane then refer to the help on that pane to proceed from there.

|  | Alternatively, right-clicking on a column displays the following options:

|  | Add to Grouping — Adds the column to the Grouping pane.

|  | Add to Sorting — Adds the column to the Sorting pane.

|  | Add to Criteria — Adds the column to the Criteria pane.

|  | Add to Having — Adds the column to the Having pane.

Copyright © 2018 Quadrant Software B.V. All rights reserved.