News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) How to check existence...

Microsoft Dynamics AX (Archived)

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

(0) Share

Report

Report

Posted on by Community Member 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

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Sohaib Cheema 46,610 User Group Leader on at

Like (2)

Report

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

}

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans