Adding a column
Use this procedure to add a column in the database interface.
- In the Table pane, select Columns Node from the list.
- Click Add. The Column Details pane is displayed. The default column name always begins with the current prefix, for example, MM.
-
Specify this information:
- Name
- Specify a new Field name in this table, with the chosen field prefix.
- Field heading
- Specify the field heading connected to the field or browse a field heading using the Field Headings window. The field heading is retrieved from the language file that is valid according to a language search order.
- Type
- Select the type of the field data. These types are possible:
-
String
-
Decimal
-
- Length
- Specify a new value for the length of the field.
- Decimals
- Specify the number of decimals in the field if it is a decimal field.
- Edit code
- Select the edit code that is to be used for the field. The code controls how the field is presented in panels and lists. It is the base for the field properties displayed in Screen Designer.
- Press CTRL+S to save the changes. The column is added to the table.