Adding a column

Use this procedure to add a column in the database interface.

  1. In the Table pane, select Columns Node from the list.
  2. Click Add. The Column Details pane is displayed. The default column name always begins with the current prefix, for example, MM.
  3. 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.
  4. Press CTRL+S to save the changes. The column is added to the table.