Hi, I am having a problem with data integrity when more than one user is using a particular script at the same time.
Is there a way to check before a user enters a script to see if another user is already in the middle of it?
When a user starts the script - set a field somewhere - not a global. When the script ends - reset the field.
At the beginning of the script test for the contents of the field.
Wonderful and so simple.
I appreciate your help!
If the script is running on a single record the status field can be in the same table.
If the script is running over a batch of records you should create a utility table with a single record in it and test there.
Retrieving data ...