Follow-On Topics

Related Topics

# About Formula Columns

Formula Columns enable the user to return information in the Query that is not available in the database. The feature can be used to transform Columns that exist in the database by performing data type conversions, formatting or calculations of almost limitless complexity.

Creating a Formula Column

1. Right-click on the Formulas node at the top of the ODBC Schema.
2. Select the New Formula option on the context menu.
3. Type a name for the formula. Press OK

   Names matching a word reserved by the ODBC driver or containing an illegal character are not allowed, and a warning displayed to that effect.

   1. Press OK
   2. Repeat Step 3 with another name.
4. The Formula Editor dialog box is displayed.
5. Specify the Formula Data Type to indicate the type of data the Column provides.
6. Create the formula for the Column.
7. Press OK.
8. Add the Column to the query.

Editing a Formula Column

1. Right click on the Formula Column.
2. Select Edit from the context menu.
3. The Formula Editor dialog box is displayed.
4. Adjust the configuration as required.
5. Press OK.

Renaming a Formula Column

1. Right click on the Formula Column.
2. Select Rename from the context menu.
3. The Choose Formula Column Name is displayed.
4. Adjust the configuration as required.
5. Press OK.

The new Formula Column is displayed both in the ODBC Schema and any instances of the Formula Column in the Query.

Deleting a Formula Column

1. Right-click the Formula Column
2. Click Delete on the context menu
3. If the Formula Column is in use in the query, the delete is not permitted and a message displayed to that effect.
   1. Press OK.
   2. Remove all instances of the Formula Column from the Query
4. Repeat Step 1

The Formula column deleted.

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