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?