I need you generous feedback on the below case.
I have a database file on a F.M. server with 10 concurrent connections.
If one of the client triggers a script, the first steps of this script create new records, amending current records, save variables ...etc. What if at the middle of the script execution an accident disconnection occurred, & due to this disconnection the last steps were not completed.
My question is that does the F.M server revert all the created events in order to let the same client repeat the script execution (because the last one had not finished all the required steps)? & if the server can not handle & treat this disconnection, how we can prevent the missing consequences?