Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 6421 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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

Posted

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?

Posted

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.

This topic is 6421 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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