Subject How to prevent update conflict in multiuser app?
Author kj01135
Hi,

I am developing a POS system using IBO v4.2.Ia. Suppose there are a
three terminals on the front-end and each is doing sales order which
in turns update the inventory records to reflect sales (decrease
stock qty). At the same time, a manager is updating 100 inventory
records (including ITEM A) in a batch to increase stock qty.

My concerns is if this update take 5 secs to complete (using SP) and
commit only when the 100 updates is done, if during this 5 secs ITEM
A is sold, will the inventory data shows the correct stock qty? Will
the SP lock the records so that ITEM A cannot be sold until it
commits? What setting do I need in order to do this?

Many thanks!

Kenneth