Microsoft Dynamics AX (Archived)

UPDATE WMSPALLET thought x++

(0) Share

Report

Posted on by MartaDiazVila

135

Hi everyone,

I need to change a field value of a record of WMSPallet table. I tried:

select forupdate wmsPallet
            where wmsPallet.wMSPalletId == PalletId.text();
        wmsPallet.wMSLocationId = Ubication.text();
        wmsPallet.inventLocationId = Location.text();
        wmsPallet.update();

But i had netx error: "Can't edit record on WMSPallet. The update must be done within a transaction"

I don't know whats this exactly means. How can i do the update? There is some example somewhere?

Thanks.

*This post is locked for comments

All responses (3)

Answers (1)

André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at

Like (0)

Report

RE: UPDATE WMSPALLET thought x++

Don't worry. I will not inform your boss. He is able to read the forum himself :) lol
MartaDiazVila 135 on at

Like (0)

Report

RE: UPDATE WMSPALLET thought x++

Ok, what a silly mistake. Don't tell my boss hahaha

Thanks André.
Verified answer

André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at

Like (0)

Report
RE: UPDATE WMSPALLET thought x++

Hi MartaDiazVila,

This error message means that you forgot to use the statements ttsbegin and ttscommit. You can try it using the next example:

ttsbegin; select forupdate wmsPallet where wmsPallet.wMSPalletId == PalletId.text(); wmsPallet.wMSLocationId = Ubication.text(); wmsPallet.inventLocationId = Location.text(); wmsPallet.update(); ttscommit;