October 9, 200916 yr I have a layout, which is pretty basic. By choosing some global variables, then clicking "save" it will increment a count in the table for that day. Multiple users will be using this... where I am seeing some issues, is if 2 or more people click the "save" button at the same time... it will still execute, but give them an error message about locked record, until the other person finishes. Is there a command or step in the script that can accomodate if multiple users try to run the script at the same time, without flagging any errors?
October 9, 200916 yr The Open Record step is probably what you are looking for. You will need to combine this with setting ErrorCapture to ON in your script. Basically if you try to Open the record and it yields an error then the record is already locked by another user. Display a dialog box to advise the user. Don't forget to Commit Record at the end of your script.
October 9, 200916 yr See: http://forum-en.filemaker.com/fm/board/message?board.id=FM-en-4&thread.id=27297
Create an account or sign in to comment