Problem with 2 users editing the same record
We have a script that performs some maintenance scripts in the background , it runs every 2 mins on a spare pc we have
Sometimes it tries to amend a record that someone is already working on via a different pc, at this point the script on the maintenance pc fails (we get this record is being modified by ****** with options send message or cancel)
I realise the is a protection facility on fm that guards database integrity, however i was wondering if there was anyway of being able to check if someone was already using that record before attempting to modify it? or any other solution that could possibly help?
Thanks in advance