DDEditor - Field table right-mouse menu¶
Data dictionary editor - Field table right-mouse menu
Operations within the main field table are controlled by a right-mouse menu, opened by a right click on any field in the table. The menu options displayed vary according to whether or not one or more fields are currently selected, and the position of the field clicked on.
If the field is unselected, is highlighted until the menu closes, using a different colour from that used for selected lines. It remains unselected.
If the field is selected it remains selected, and its colour remains unchanged.
No operation that involves the moving of fields can be carried out if it would result in a subscripted field (one with a Dims value greater than 1) being moved to a key field position.
Insert field above this field¶
Insert a new field above the field clicked on.
The new field is given the following properties:
Key/data |
Data, unless the field is inserted above a key field. |
Name |
The first available name in the series Field1, Field2, Field3…. |
Type |
The type assigned as the default on the Configure window. |
Size |
The default size for the type. The Real and Unsigned types have only one valid size; defaults for the other types are assigned on the Configure window. |
Dims |
|
LT |
If the type is Number, the logical type Money is assigned. This is compulsory for Number type fields. Otherwise no logical type is assigned. |
All other field properties are left blank.
The option can be used to add a field with these properties at the end of the existing fields - right-click on the first blank line to activate the menu. A new field can also be added by entering a valid field name in the first blank line.
Delete field¶
Delete the field clicked on. No prompt is issued unless the field is included in one or more secondary indexes. If the user confirms the deletion in response to this prompt, the field is also deleted from all secondary indexes that contain it. If the field is the only one in a secondary index, the index is not deleted; it is legal, though useless, to retain a secondary index which contains no fields.
If there is only one key field, it cannot be deleted.
A deleted field cannot be recovered.
Paste selected fields above this field¶
Only displayed if one or more fields have been selected. Paste all selected fields above the field clicked on. If a field’s’ Key/data status would be invalid in the new position, it is changed. Fields are selected by clicking in the field number column at the left of the table, SHIFT-CLICK and CTRL-CLICK having their usual functionality.
Move this field down¶
Move the field down one row.
Move this field up¶
Move the field up one row.
Add field to secondary index¶
Add the field to the currently displayed secondary index. If the field is subscripted, the first element is added.
Create a new index for this field¶
Create a new secondary index, consisting of this field. If the field is subscripted, the first element is used. The index is given the default name of alt_1, alt_2… the suffix being the lowest unused. The name can be amended, and more fields added if required.
Expand field details¶
Open the Field details screen, which displays all the properties of the field clicked on. This option is equivalent to pressing the Field Details button.
RELATED TOPICS |