Friday 30 March 2012

Deleting duplicate records in Table through code in X++

Hi friends ,

We are going to see how to delete duplicate records on the Table through code by using X++

static void DeleteDuplicate(Args _args)
Set fieldset = new set(types::Integer);

// create dictindex from unique index

DictIndex dictIndex = new dictIndex (tablenum(PurchTable), indexnum(PurchTable,PurchIdx));


// these are fields from index

// add them to set

fieldset.add(fieldnum(PurchTable ,OrderAccount));


// set allow duplicates


//reenable duplicates


info("Deletion done");


Vivek Chirumamilla

No comments:

Post a Comment