Real-Time Stock Upate Issue in Multi-User Order Application

(1) Share

Report

Posted on by CU28111146-0

Hi guys i have some issue in my orders app in updating the multiple stock values.Let me explain my issue.

Initial State:
- Stock for "Apples" is 10 in the Products table.
- Two users, User A and User B, place orders at the same time:
  - User A orders 6 apples.
  - User B orders 5 apples.
Problem:
- Without synchronization, both users might see the initial stock as 10.
- Orders might process independently, resulting in overselling (6 + 5 = 11) when the stock should only allow up to 10 apples.
Expected Behavior:
- If User A confirms their order first, the stock should update to 4.
- User B should only be able to order up to 4 apples.
- If User B tries to order 5 apples after User A’s order, the app should prevent it.

This is my code

Set(myorder,orderid.Run().orderid);

Patch(

Orders,LookUp(Orders,Title=myorder),

{

'Item Count': Value(Label21.Text),

'Total Amount': Value(Label9.Text)

}

);

ForAll(

Gallery2.AllItems,

Patch(

'product Items',

Defaults('product Items'),

{

Title: ThisRecord.Label5.Text,

Quantity: ThisRecord.Label6.Text,

Amount: ThisRecord.Label7.Text,

'Order ID':{Value:"",Id:LookUp(Orders,Title=myorder,ID)}

}

)

);

ForAll(

Gallery2.AllItems,

Patch(

Products,LookUp(Products,Title=Label5.Text),{Stock:Value(ThisRecord.Label6_1.Text)})

);

Refresh(Products);

UpdateContext({varplace:true});

Categories:

I have the same question (0)

All responses (2)

Answers (1)