Microsoft Dynamics AX (Archived)

Select For update

(0) Share

Report

Posted on by Derik

110

Running this code shows"

Cannot edit a record in Inventory module parameters (InventTableModule).
The record has never been selected.

This error

while select * from CopyOfInventTableModule {
ItemId=CopyOfInventTableModule.itemid;
select forUpdate InventTableModule group by InventTableModule.ItemId where InventTableModule.ItemId== ItemId;
ttsBegin;
InventTableModule.Price=CopyOfInventTableModule.Price;
InventTableModule.UnitId=CopyOfInventTableModule.UnitId;
InventTableModule.ModuleType=CopyOfInventTableModule.ModuleType;
InventTableModule.PriceDate=CopyOfInventTableModule.PriceDate;
InventTableModule.PriceQty=CopyOfInventTableModule.PriceQty;
InventTableModule.PriceUnit =CopyOfInventTableModule.PriceUnit;
InventTableModule.update();
ttsCommit;

}

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Mea_ 60,284 on at

Like (0)

Report

RE: Select For update

Hi Derik,

Remove "group by InventTableModule.ItemId" and it should work, if you want to update all records with same itemid use update_recordset msdn.microsoft.com/.../aa674382.aspx

Was this reply helpful? Yes No
Derik 110 on at

Like (0)

Report

RE: Select For update

Thank you, Sukrut but it is showing error

Cannot edit a record in Inventory module parameters (InventTableModule). Item number: 000026, Sales order.

The record already exists.

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

RE: Select For update

You need to check unique indexes on this table and be sure that updating a record you not creating duplicates.

Was this reply helpful? Yes No
Suggested answer

Andrew Xu 3,877 on at

Like (0)

Report

RE: Select For update

Try this please,

update_recordset InventTableModule

setting

Price=CopyOfInventTableModule.Price,

UnitId=CopyOfInventTableModule.UnitId,

PriceDate=CopyOfInventTableModule.PriceDate,

PriceQty=CopyOfInventTableModule.PriceQty,

PriceUnit =CopyOfInventTableModule.PriceUnit

join CopyOfInventTableModule

where CopyOfInventTableModule.ItemId == InventTableModule.ItemId

&& InventTableModule.ModuleType == CopyOfInventTableModule.ModuleType;

Was this reply helpful? Yes No
Suggested answer

startax 1,845 on at

Like (0)

Report

RE: Select For update

Hi derik,

You have to use your select for update in while statement

Ex.

while select tableA

{

table.selectforupdate(true)

tableA.field = tableB.field

tbaleA.update()

}

Thanks,

Was this reply helpful? Yes No