Column type and name:

Column "column name": the column is an editable source column.

Also, when the column is part of a dependent table and stores results of an operation (column is table owned).

Column Calculate "column name": the column is the result of a TabCalc formula without using aggregations, joins, cumulative or a least squares fit (dependent column).

Dependent column "column name": the column is the result of a column operation, i.e. aggregation, join, cumulative, least squares fit (dependent column).

Object date and time:

Date and time when this column was last changed.

Column is table owned:

For a column that is part of a dependent table, i.e. the column stores the result of an operation, it is stated that this column is table-owned. Table-owned columns are always read only and cannot be edited. For more information, see ILWIS objects : columns.

Read-only:

For columns that are not table owned: select this check box when you want that the fields in this column are read-only and thus not editable. Clear this check box when the fields in the column should not be read-only.

Expression:

For dependent columns, the expression by which this column is created, i.e. the column definition. For Column Calculate columns, you can edit the TabCalc formula by which this column is created.

Domain:

While calculating with columns (TabCalc or column operations), accept the default domain for the output column, or select or create a domain which reflects the values that you want to store in this column. When calculating with value columns, you can generally accept the default system Value domain.

For table-owned columns and for read-only columns, the name and type of the domain used by this column is merely shown.

For source columns, you can change the domain of this column (advanced).

Defaults:

For Column Calculate columns, click this button to obtain a default domain, and for value domains, a default value range and precision. Or when you changed the default domain, value range or precision, click this button to obtain the defaults again.

Value Range:

While calculating with columns (TabCalc or column operations) and when the column uses a value domain, accept the default value range used to store the values in this column, or specify your own range of possible values for the column (a liberal estimate will do).

For source columns using a value domain, you can edit the value range of the column.

For table-owned columns and for read-only columns using a value domain, the value range of the column is merely shown.

Precision:

While calculating with columns (TabCalc or column operations) and when the column uses a value domain, accept the default precision used to store the values in this column, or specify your own precision for the column.

For source columns using a value domain, you can edit the precision of the column.

For table-owned columns and for read-only columns using a value domain, the precision of the column is merely shown.

Minimum/Maximum:

If this column uses a value domain, the minimum and maximum values as occurring in this column are listed.

For dependent columns:

Depends on:

The names of columns on which this column depends.

Up-to-date or not:

Lists whether this column is up-to-date or not. If not, the name of the column which was changed last is shown including that column's date and time.

For all columns:

Position:

Accept or change the position of the column in the table. Position 3 means that this is the third column in the table.

Width:

Accept or change the width of the column.

Decimals:

In case of a value column: accept or change the number of decimals used to show this column. You can always change this option to show the values in a column with more decimals or with fewer decimals.

Description:

Description of the column; freely editable for source columns and dependent columns. The description of a column appears on the status bar of a table window when moving the mouse pointer over fields of the column or over the column name. Furthermore, column descriptions appear in the Column Management dialog box.

Handling properties of dependent columns:

Make Up-to-Date:

When the column is not up-to-date anymore,

i.e. when one or more columns on which this column depends have been changed:

• click this button to check all columns on which this column depends, see if these are up-to-date, if not, check all columns below, etc.,
• recalculate all changed columns on which this column depends, and finally recalculate this column using all new changed columns.

To make all columns of the table up-to-date, you can also select the Update All Columns command on the Columns menu.

Break Dependency Link:

Whether this column is Up-to-Date or not:

• click this button to break the dependency link between this column and the columns on which it depends. This column will become an editable source column.

Do not break the dependency link if you wish to be able to update this column in a later stage on the basis of changed input columns.

Additional Info:

When a dependent column is the result of a Least Squares Fit column operation: click this button to see the resulting least squares fit formula.

For string columns:

Create new domain from Strings:

Click this button to convert the strings in this column into a classes or IDs of a class or ID domain. A Create Domain from Strings dialog box will appear in which you can specify a new class or ID domain.