Fixed Assets - Registration Product table wrongly defined

Description

Test case:

  • Add one record in "Registration Attributes" window

  • Navigate to "Product" tab and add one record for "Azalea"

  • Add a second record for "Seeder"

  • Now go back to the "Azalea" record and try to change the description and Save

Error: Could not save changes: Update return 2 instead of 1 - [POSaveA_RegistrationPro_7256ec19-42d7-4bdb-9a68-ae51a182dfdc] - A_RegistrationProduct.A_RegistrationAttribute_ID=1000000

This is because the table is wrongly defined.

If is a one-to-one extension table then it must ensure to allow just one record per attribute.
If is a one-to-many children table then it must have a primary key not based just in the parent key (probably a SeqNo?)

Environment

None

Activity

Show:
Anna Fadeeva
June 25, 2020, 8:01 PM

Tested by

Reproduced

Anna Fadeeva
June 25, 2020, 8:01 PM

Product changed after trying to save a description

Mayta Coronel (Maya)
August 22, 2020, 3:14 AM

still reproduced

 

Assignee

Unassigned

Reporter

Carlos Ruiz

Labels

Tested By

Anna Fadeeva

Components

Affects versions

Priority

Major
Configure