Subject | How to prevent update conflict in multiuser app? |
---|---|
Author | kj01135 |
Post date | 2002-11-16T08:04Z |
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
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