Share
ReportHi All,
I have created an entity for a table by adding a new Counter (Int) field and creating an alternate key with the new field included.
After I wanted to build and sync the project it has failed with error message about applying unique index is not allowed because of record duplication. It is true, because the newly created field was empty at the time of applying the new unique index.
I have created a code (lets call it FILLER), which is going to fill the existing record's new Counter field before enabling the index. After that I have enabled the index, and it worked.
But I don't want to do this way. I cannot remove the content of the table, so I would like to run the code FILLER before the synchronization to avoid the error mentioned above.
I am a newbie in AX, and I haven't find a solution for this. (I have heard about a solution in AX6 (releaseupdate), but it is not working in AX7 as far as I know, am I right?). I hope you understand the issue and can provide me a solution for this. Thanks!
Regards,
Szabi
*This post is locked for comments
I have the same question (0)
All responses (
Answers (
2
