News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Avoid inserting Duplic...

Microsoft Dynamics AX (Archived)

Avoid inserting Duplicate Record in Table

(0) Share

Report

Report

Posted on by Rohin

4,624

Hi All,

I have a table where i am storing recId field from another table. I want there should be no duplicate Recid in field while inserting reciD and it would gives error. what code should be used for this as best practices.

Looking for your suggestion please.

Thank You!

Visvash Walia

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (2)

Verified answer

Vilmos Kintera 46,149 on at

Like (1)

Report

RE: Avoid inserting Duplicate Record in Table in AX 2012R2

It is enough to create the unique index, no additional check required.

If you want, you could override aosValidateWrite() (that one is always called, even if you create a doInsert()) and could provide a custom, more meaningful message for the user about what and why is not allowed to be duplicated in a checkFailed() message.
Verified answer

Mariano Gracia on at

Like (0)

Report
RE: Avoid inserting Duplicate Record in Table in AX 2012R2

What I would do is:

Create an index for the RefRecId field, set the property allow duplicates to false.

Make the RefRecId field mandatory, allowEdit property set to false, allowOnCreate property to true.

Allways check duplicates before insertion, something like if (Table::exists(RefRecId value) == false) insert.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,784 Super User 2024 Season 2

#2

Martin Dráb 230,476 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans