Use these fields and options to create SQL expressions.
| Field | Description |
|---|
| Columns
|
Select the column for which you want to create an expression. To select a field, double click on it, or select it and click
Add Field. The field name displays in the Expression grid.
Calculations can be simple or complex, and can be created using either the
Calculator or the
Use a Condition tool.
All character/string type fields are added to the expression with qualifiers (single quotes) around them when the
Add Column button is used. All numeric type fields are added with no qualifiers.
|
| Calculator
|
The Calculator tool allows you to create simple expressions using numbers and math calculations. In addition to clicking on the Calculator to select a number or symbol, you can also enter the number or symbol directly in the Expression grid.
|
| Expression
|
This field displays the expression that you created. In addition to creating expressions using the Calculator and Use a Condition, you can also enter conditions in this grid.
To insert a column, click
Insert. If you are using the Use a Condition feature, first select the
Expression field for which you want to enter a column, then click
Insert.
Deltek displays a list of columns available for that hub.
To undo the last change you made, click
Undo Last Change.
To clear the expression, click
Clear Expression.
|
