I have several instances where I will go to a "backend" layout (a layout only used by the system for record operations), and change, delete, add records to perform a specific function.
Most of the time, this is for manipulating records related to the current table/layout the user is on.
I am concerned about record locking.
What if a script opens a new window, performs a find to get specific records, then replaces or updates all of the found set's specific field with a new value.....all the while one of the records is currently being edited by another user??
What does filemaker do? What can I do to error proof my script so that I am sure the ALL records were updated, including the one that was currently in use by another user?