4.12. Manual data administration
4.12.6.  Edit/delete data record with PARTdataManager
Prev  Next

4.12.6.  Edit/delete data record with PARTdataManager

After clicking on the button button, the Edit/delete data record [Edit/delete dataset] dialog box appears.

The button is only available with ERP functionality.

See under Section 4.20.1, “ Load additional scripts - erpcustom.cfg -> Block [LOAD]”.

Edit/delete dataset

Edit/delete dataset

  • New key value

    Change the ERP_PDM_NUMBER if desired.

The data view is divided into link data [Link-data] and ERP data.

  • Update dataset

    Click on the value to be changed, change it accordingly and press the Update record [Update dataset] button.

  • Delete link

    Deletes the data of the LINKTABLE.

    Afterward follows an inquiry whether or nor the data of the ERPTABLE should be kept. Confirm/deny the inquiry accordingly.

  • Execute SQL-command

    Opens the window of the same name.

    In the SQL command entry field you can enter any command.

    Example:

    SELECT * FROM ERPTABLE WHERE MAT_NAME='8.8

    Define the maximum number of rows in the result.

    Then click Execute.

    [Note]Note

    Using Browse ... you can display the table names and a selection of SQL commands.

    Execute SQL-command

    Execute SQL-command

  • Close

Prev Up Next
4.12.5.3. Deleting data records  Home 4.13. Complex workflows for data maintenance