Dynamics Community Forum Thread Details

Job class to update" item model group "in inventModelGroupItem Table i'm facing issues !

Hi every one!I have a requirement to change itemmodelgroup of item from /inventModelGroupItem/ table. Ihave to select UPDATE model group only where item type is /Item/ for all items. Item type is coming from Invent Table so Ihave to join the tables and then select /inventModelGroupItem/ for update.when i run thi class i face the error /Cannot edit a record in Relationship between items and item model groups (InventModelGroupItem). The record has never been selected/. I have added the following code :

 InventModelGroupItem  inventModelGroupItem;        EcoResProduct         ecoresproduct;        InventTable           inventTable;        ttsBegin;                 while select forUpdate inventModelGroupItem            where inventModelGroupItem.ItemId != ''            join inventTable            where inventModelGroupItem.ItemId         == inventTable.ItemId            &&    inventModelGroupItem.ItemDataAreaId == 'QTS'            &&    inventTable.ItemType   == ItemType::Item        inventModelGroupItem.ModelGroupId = 'WA';        inventModelGroupItem.update();            ttsCommit;        info(/completed/);

Categories:

Development / Customization / SDK

while select forUpdate inventModelGroupItem where inventModelGroupItem.ItemId != '' join inventTable where inventModelGroupItem.ItemId == inventTable.ItemId && inventModelGroupItem.ItemDataAreaId == inventTable.DataAreaId && inventTable.ItemType == ItemType::Item { }

Quick Links