agaperrk Posted September 11, 2007 Share Posted September 11, 2007 I am using FM 5.5 I need to find the same records in two different files. When I use the Script I created it just keeps looping to infinity. I have records with a select checkbox in one record, the same checkbox in the second file, I can do the finds seperatly but when I try to implement them in a script it just loops. Thanks in advance. Link to comment Share on other sites More sharing options...
AudioFreak Posted September 11, 2007 Share Posted September 11, 2007 Hi, Create a relationship between the two fields you are doing the finds on. Then create a script and use the step Go To Related Record. If you need more explanation let me know. Michael Link to comment Share on other sites More sharing options...
agaperrk Posted September 11, 2007 Author Share Posted September 11, 2007 I already have a relationship and I can get them to go to individual records of what I find, I would like to find the same list so i can print or view a group of records. Link to comment Share on other sites More sharing options...
AudioFreak Posted September 11, 2007 Share Posted September 11, 2007 If you can find the records you want to print then you have most of it. "I would like to find the same list so i can print or view a group of records." Are you trying to print one record per page or multiple records on one page? I guess that would explain why you are using a loop if it's the 1st. Could you post a copy of the script you are using so we can figure out why it is stuck in the loop? Michael Link to comment Share on other sites More sharing options...
agaperrk Posted September 12, 2007 Author Share Posted September 12, 2007 The Script, there are two files one is student and the other is forms I have a field that is called select which resides on the forms file, I have put it on the student file list layout. the script start with perform find(restore, replace) Go to layout list perform Script (external script forms find mark) the find just finds all the yes's in the select field I use a check box When I go do the finds individually I can get it to work, when I try to automate it, it just loops. Link to comment Share on other sites More sharing options...
AudioFreak Posted September 12, 2007 Share Posted September 12, 2007 What does the external script do? Obviously that is where the loop is contained. Anyway you can post a copy of the file? Would make this much easier. Michael Link to comment Share on other sites More sharing options...
agaperrk Posted September 12, 2007 Author Share Posted September 12, 2007 The Script goes to the forms table and States Perform Find (restore,) the find criteria is looking for the check in the checkbox, Then goes to a list layout. Link to comment Share on other sites More sharing options...
AudioFreak Posted September 13, 2007 Share Posted September 13, 2007 I still don't see a loop. Or how you are getting stuck in a loop. A script that performs a find and then calls another find script in another file isn't going to "Loop". Are you getting a "No records match this find request" error? If so, is it in the First script or the External Script? Is that ALL of both scripts? One thing you can try yourself is insert Pause Steps(eg...right before a find is performed, after a sort....etc) in both of the scripts to try and see where the problem might be. You can always remove them after you get it working. BTW IF you have access to the Developer Version, you can use the Script Debugger Instead of the pauses. Michael Link to comment Share on other sites More sharing options...
agaperrk Posted September 14, 2007 Author Share Posted September 14, 2007 Yes I will give that a try, I do not have many steps and there is no reason to loop. I get no error it just give the command symbol over and over. I will try the debugger. Link to comment Share on other sites More sharing options...
agaperrk Posted September 19, 2007 Author Share Posted September 19, 2007 When I took the steps one by one, the problem occurred when the script tried to switch files, when it went to open the new file and Run it. I change the way it open the file and I will have to live with it. Thanks for the help. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6191 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