63.1. Introduction

All the tools for modifying the values or structure of one table.

In the case of attribute tables, the edition must begin from the View. In the case of alphanumeric tables begins from the Table document.

These tools are available from “Table” menu and its relevant button bar..

The available edition tools are:

63.2. Add column

To add a new column to the table.

This tool is available from the “Table” menu and its relevant button bar.

It shows one window to select the characteristics of the column.

• Field name

• Type. Dropdown with the available types.

• Length. Field length. Maximum is 254.

• Precision. Number of decimals for the numeric fields (double).

• Default value. It is possible to set a default value for all the records of the table.

63.3. Column manager

To add, remove or rename fields.

This tool is available from the “Table” menu and its relevant button bar.

The interface is:

• List with all the fields of the table and with their characteristics.

• The available buttons allow to create, rename or delete one field.

63.4. Field calculator

To make calculations with the fields of the table.

This tool is available from the “Table” menu and its relevant button bar.

It is possible to execute in all the records if none is selected, or in the selected fields.

The interface is:

1. Information about the selected “Field” or “Command”

2. Filed. List of the fields. Double click on the field to add the expression.

3. Type. Depending on the selected type, the available “Commands” are updated.

4. Commands. List of the available commands depending on the selected “Type”. Double click on the expression to apply.

5. Expression. Operation which will be applied to the selected field. It is possible to type it directly.

The “Advanced” tab is for using one expression saved in one file.

The interface is:

• Load script with the expression.

• Save script with the expression.

• Run script to test the expression.

Some usual commands are: