Microsoft Dynamics AX (Archived)

insert when doe snot exist

(0) Share

Report

Posted on by Community Member

I am tring to insert a record in a table only if it doe snot exist already. Can some help me withis

Below is my code

Bom BOM

BOM.LineNum=7;
BOM.ItemId="freight";
BOM.BOMQty=1;
BOM.Calculation=1;

BOM.insert();

if there is alreayd an item with item id freight i do not want to insert if not then I should be able to insert

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Martin Dráb 237,882 Most Valuable Professional on at

Like (0)

Report

First run a select to see if the record doesn't exist. Alternatively, you could try to insert it and then catch the exception.

By the way, don't forget calling validateWrite() before insert() and update() (and checking its return value).

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Martin,

Thanks for the reply. Right now its not throwing error when i insert. Its just inserting duplicates. This is first X++ program , can you please refer to any resources to do this and also how to write validatewrite(). I have noticed there is not much information on X++ online compared C#, that's very disocuraging.

Was this reply helpful? Yes No
Verified answer

Rudi Hansen 4,075 on at

Like (0)

Report
Try this:

static void TestInsertBOM(Args _args) { BOM bom; select firstonly bom where bom.LineNum == 7 && bom.ItemId == "freight"; if(!bom.RecId) { bom.LineNum = 7; bom.ItemId = "freight"; bom.BOMQty = 1; bom.Calculation = 1; bom.insert(); } }

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

you are awesome sir, thank you

Was this reply helpful? Yes No
Martin Dráb 237,882 Most Valuable Professional on at

Like (0)

Report
validateWrite() does some kernel-level checks (namely enforcing reference integrity) and can be overridden to check additional business-logic rules (AX is full of example, just search for them). You shouldn't call insert() on something invalid. For example, you already have a rule saying that duplicate records shouldn't be inserted, but you failed to validate it.

Depending on your requirements, you may skip insert() or throw an exception if validations fail. For example:

if (!bom.validateWrite()) { throw error(...); }

Was this reply helpful? Yes No