The problem seems to be with the find script.
scripting error (101) at "Middle School RoAs_ : Update info from GI: Set Field".
scripting error (400) at "Middle School RoAs_ : Update info from GI: Perform Find".
script wise I've got the following:
Setfield[GIpup::Year,3] - which is giving the error 100.
Perform Find which is giving Error 400,
When doing the search I am in the right context. The scripts work fine in a regular fmp client.
Thank you for your post.
A listing of error messages can be found in the help file. Search for "error codes", and look at the article "FileMaker Pro error codes".
Error 101 - Record is missing
Therefore, your script gave the error 101 because you were trying to set a field where no record existed. You may want to make sure a record is found prior to this script step. That is:
If [Get (FoundCount) > 0]
Error 400 - Find criteria are empty
This means there was no criteria in the Find. If you were referencing a field or variable, make sure it isn't null before setting the field.
Well we think we have found the problem. We have two FileMaker servers, Server 1 (hosting 115 files) and Server 2 (hosting about 60 files).
The problem seems to be on Server 2, when doing a find through a relationship to data which is stored on Server 1 (On a TO). I dont think it can perform the find in the schedule (i've tried running the script manually which works fine).
We have a similar script in another file hosted on server 1. This seems to execute correctly under an fm9 schedule.