Jump to content
Sign in to follow this  
dvalley

Script Steps ignored

Recommended Posts

This is a new one to me. I have two scripts which now do not work correctly. The first script is a basic duplicate parent and child record (s). The parent duplicates fine, but when it gets to the child records, something strange happens. The script is a looping duplicate, change key field (using a global to hold the new key data), go back to the first record and omit. This is supposed to run until the key field matches the global, then exit the loop. It works fine until the fourth or fifth record, the the go to record/ request(First) step is ignored as is the omit step. The loop exits with only a few records duplicated.

The second script is a looping set field xxx to "". (Clears out data from child records now duplicated. This script works fine until the third record, then fails to go to next record. It stays on the third record forever. I restarted FileMaker, but the scripts still fail. I have used these same type scripts throughout my solutions and they work fine. Does anyone have any idea what is happening?

Script1.pdf

Script2.pdf

Share this post


Link to post
Share on other sites

Try disabling your Set Error Capture [On] step, and in your Commit step, don't skip validation and see what happens. Turn on the debugger and step through it. Any luck?

Share this post


Link to post
Share on other sites

I added the commit step on the script where it got stuck on a given record. That helped as there was a validation it was hanging on. Restarting the computer helped the other problem.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.