dvalley Posted April 26, 2007 Posted April 26, 2007 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
Fitch Posted April 27, 2007 Posted April 27, 2007 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?
dvalley Posted April 27, 2007 Author Posted April 27, 2007 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.
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now