4.3.2.  Add database column with PARTlinkManager

The following explains how to add database columns with PARTlinkManager.

  1. Log into the database under File menu -> Connect.

    [Note]Note

    The "Add columns" process accesses the database directly.

    Standard administration login for the PLINKDB:

    • User: sa

    • Password: (according to the password assignment during database creation)

  2. Select in PARTlinkManager -> Extras menu -> Database -> Change/create database columns [Modify/create database columns].

    -> The Create/remove database columns dialog box opens.

  3. Column [Column name] name:

    Define a name of your choice.

  4. Column type:

    Select a column type in the list field:

    VARCHAR (variable character length is often better than CHAR to avoid problems), CHAR, SMALLINT, INT, DECIMAL

  5. Length:

    A character string length must also be specified for text fields

    Default value: Optional

  6. Activate Create ERP column.

    If you want to edit the column in the PARTlinkManager in the Configure column display [Modify column display] dialog box (i.e. not only create it in the database itself, but also enter it in the corresponding configuration files), check the box. This is the recommended procedure.

  7. Confirm with OK.

    -> The column has been added.

  8. Open the Configure dialog box via Tools [Extras] menu -> Configure ERP environment.

    The column you have just created is displayed in the Configure column display [Modify column display] dialog area.

    The column is also visible in the PARTlinkManager table.