Follow-On Topics

Related Topics

# Using the Formula Editor

The Formula Editor dialog box is used to create a formula for a table join or Object and is displayed through the methods listed below. Formulas can be used to format data, create new columns or for data type conversion.
|  | Right-clicking on Formula in the OLEDB or ODBC Schema area of the Query tab, contained in the Database Query (OLEDB) or Database Query (ODBC) dialog box and selecting the New Formula option from the drop down menu.
|  | Right-clicking on a table join in the Tables & Joins area of the Query tab, contained in the Database Query (OLEDB) or Database Query (ODBC) dialog and selecting the Convert to Formula option from the drop down menu.
| Click the image to view full size.

The dialog box contains the following:

|  | OLEDB or ODBC Schema

The OLEDB or ODBC Schema area displays a tree of tables and columns available from the database being used by the Database Query Step.

Another area below the tree displays information for the selected table or column.

|  | Formula Editor

When converting a join to a formula, the applicable columns, joined with an equals (`=`) symbol are already added to the Formula Editor area.

When creating a new Object, the area is blank and new columns may be added to build up a formula by either dragging and dropping the column from the OLEDB or ODBCSchema area or double clicking on the chosen column.

|  | Formula Data Type

When creating an Object the data type to be used may be selected from a drop down list. This is particularly useful when using columns in the formula which have different data types.

|  | Description

A description for the formula may be entered here.

|  | Functions

|  | The Functions button displays a list of functions which may be used to join columns and build up the formula required. The operators available depends on the underlying database engine and OLEDB or ODBC driver that is being used. The function set also varies depending on the settings used on the King Task Centre database connection.

|  | When the Use Pass Through option is unchecked in Global configuration then Jet / DAO is invoked. If this option is checked then the connection bypasses the Jet / DAO and use the native function set.

|  | Tables

|  | If you have manually entered a SQL statement in the Formula Editor area, then the tables may be manually selected after the statement is complete.

|  | Selecting the tables button displays the Select Tables dialog box which enables new tables to be added and redundant tables removed.

|  | Parse

|  | Once the formula is complete it may be tested by selecting the parse button which pops up a dialog box to display the results of the test.

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