SA-9400

Summary

When editing a row in a Datatable using "Edit data instances" or "Edit and Search", instead of updating the existing row a new row is added to the table.

Error Messages

Not Applicable.

Steps to Reproduce

1. Create a data table, in my case with two columns, the database already Type Workbaskcontains the table:
  2. Set the keys in the class, so PZINSKEY = Type + Workbasket.
3. Set the mapping with the table in database with a database table object.
4. In Data Model - Data Tables page open the datatable ( or icon, same result)
5. Add a new row with the values.
6. Edit this row, in my case : Pilotage 25 -> Pilotage 29:

Root Cause

The administrator has created the datatable using a manual approach. This process is not recommended and supported.

Resolution

Create a Datatable using the provided wizard. When creating a Datatable via the wizard, the administrator can choose which attributes should be the Key of the table. By doing so, user cannot modify the Key values and the rows do not get duplicated.