Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

How to check existence of a record while inserting data in to a table ?

Posted on by Microsoft Employee

Hi all,

I am importing some data from a CSV File and then inserting the same into a Table.

Now While inserting I want the program to Stop when the record already exists in the same table. 

Please Provide me some sample code ..

*This post is locked for comments

  • Verified answer
    Sohaib Cheema Profile Picture
    Sohaib Cheema 46,610 User Group Leader on at
    RE: How to check existence of a record while inserting data in to a table ?

    You can write a select statement based on primarykey of your table.

    Suppose your Table has PrimaaryKeyABC with one field inside that key you can write something as under

    Select firstonly tableNameBuffer

                                    Where tableNameBuffer.FielldNameofPk == _SomeValue;

    If(!tableNameBuffer) //if does not exists !

                    {

                                    //insert

          }

     

     

    Similarly if your Table has a composite primary key, write statement accordingly.

    Select firstonly tableNameBuffer

                                    Where tableNameBuffer.Fielld_1_NameofPk == _SomeValue

                                                    && tableNameBuffer. Fielld_2_NameofPk == _someOtherValue;

                    If(!tableNameBuffer) //if does not exists !

                    {

                                    //insert

    }

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans