AnsweredAssumed Answered

Record locking.

Question asked by malachydevlin on May 27, 2016

Hi all,

I am looping through my products table to update the stock levels.

ie: using set field to adjust the stock level.


I am worried that another user could be editing a product record from another part of the package and cause a lock.

Bo user can actually edit the same field but the whole record could lock.


really i need to have exclusive access over any other user while performing this loop, apart from possibly checking if any users are logged in etc I can't see another solution?