A table is displayed in a table window.
A table consists of columns, records and fields. Schematically, this looks like:
Fields of editable source columns can be edited.
You can edit:
This topic deals with editing single fields and describes the behaviour for various column domains.
The editing of multiple fields is performed via a dialog box. For more information, refer to:
Note: You cannot edit:
For more information, see ILWIS objects : columns.
In short:
If a column is not wide enough to the contents of the fields, stars * appear. You can enlarge the width of the column by dragging the right side of the column button to the right.
Using the keyboard to move through fields of a table:
If you want to edit many fields in a table, it is advised not to use the Enter key on the keyboard, instead:
Whenever you move to another field, the previously edited field is directly stored on disk. You can stop editing by pressing Enter or Esc.
To edit columns using a value domain:
When the column uses a value domain:
If the value you typed does not fit in the value range of the column, the undefined value is assigned represented by a question mark. Values are rounded so that fit the precision of the column. To have column values displayed with more decimals or less decimals, change the Decimals option in the Column Properties dialog box.
To edit columns using an ID domain:
When the column uses an ID domain:
If the ID you typed is not yet present in the domain of the column, a question is asked whether this ID should be added to the domain.
To edit columns using a class domain:
When the column uses a class domain:
By mouse:
By keyboard:
You can add a new class to the domain, by selecting the <new> item in the list.
To edit columns using the Bool or the Yes/No domain:
A column which uses system domain Bool can contain the values True, False and ? (undefined).
A column which uses system domain Yes/No can contain the values Yes, No and ? (undefined).
In a field of a column that uses the Bool or Yes/No domain:
To edit columns using the Color domain:
Fields in a column that uses the Color domain can store colors as (Red, Green, Blue) values. The minimum value for Red, Green, and Blue is 0; the maximum value for Red, Green and Blue is 255.
( 0, 0, 0) |
represents black |
(255,255,255) |
represents white |
(255, 0, 0) |
represents red, etc. |
If width of the column is not wide enough to display Red, Green and Blue values, the Red, Green and Blue values are shown in hexadecimal notation. If you like, you can edit colors in this hexadecimal notation (where 000000 is black, FFFFFF is white, FF0000 is red, etc.). However, if you wish to see RGB values between 0 and 255: enlarge the width of the column.
Tip:
There are many more keys on the keyboard that you can use in a table window. For more information, see Appendices : keyboard shortcuts.
In principle, fields of dependent columns and fields of table-owned columns in dependent tables are not editable in order to protect the results of a calculation or an operation.
If you need to edit fields of a dependent column, you first have to break the dependency links of the dependent column in the Column Properties dialog box of the dependent column.
If you need to edit fields of a table-owned column in a dependent table, you first have to break the dependency links of the dependent table in the Table Properties sheet of the dependent table.
See also:
Edit fields in a single column