The equivalent of SELECT FOR UPDATE

0
hi Standard SQL has SELECT … FOR UPDATE construct that lets you LOCK the Object while you UPDATE it so that other users who are using SELECT FOR UPDATE can get the values of the UPDATE by the first users and decide what to do accordingly. A Use case would be in an inventory system where you check the BALANCE of an Item before you decide if you have enough ITEMS before you satisfy the ORDER. Other users are of course are also trying to take ORDERS on the same ITEM   thank you ammar
asked
1 answers
2

You could have a look at the locking module from the appstore https://marketplace.mendix.com/link/component/109405/Karona-Consulting/Pessimistic-Locking to make sure you do not run into concurrency issues

answered