A script-enabled browser is required for this page to function properly.

Deleting a defined column (Query Builder)

To delete a defined column from a query:

  1. In the Query window, click the Define Column button in the Icon Bar to display the Define Column dialog box.
  2. Click the name of the column to be deleted.
  3. Click Remove.

Defined (and computed) column example

Suppose you wanted to project a budget for next year's net pay (NET_PAY_NEXT) assuming a 10% salary increase. You could enter the following in the Expression field:

 (SALARY*1.1) + COMMISSION

Or, if you wanted to review a 10% increase in both salary and commission, you could enter:

 (SALARY+COMMISSION) * 1.1

Since NET_PAY is SALARY+COMMISSION, this is the same as:

 NET_PAY * 1.1

You can also create a defined column that displays the difference between the current net pay and next year's projections. Call this column VARIANCE, and define it as:

 NET_PAY_NEXT - NET_PAY

When you define new columns, the base columns described in your expression need not exist in the underlying database, although they should ultimately be derived from columns in the underlying table. VARIANCE, for example, is the same as:

 ((SALARY+COMMISSION) * 1.1) - (SALARY+COMMISSION)

See also

About defined (and computed) columns (Query Builder)

Creating a defined column (Query Builder)