November 8, 200025 yr Hi All, I'm trying to write a script for a file that contains sum 100 records. I'd like the script to select all records, go to 5 different fields, and then clear the contents of the fields. I need the script to do this for all 100 records. I've written the script so that it performs a "Find ALl", then a "Go To Field" and then a "Clear Field". It does this for each of the 5 different fields. However, it is only performing this script on the 1st record and then stops. Can anyone tell me how I can get this script to repeat the process on all 5 fields? Thank you for your assistance and comments. Joe T.
November 15, 200025 yr Author Thank you for your help with this. This works and does everything I want it to except that the routine is not hitting the first record of the database. Do you know why this may be happening? Thanks again. Joe quote: Originally posted by dspires: Loop your stuff goto record request page[Exit after last, Next] end loop
November 15, 200025 yr add the line Go to Record/Request First immediatly before the loop. Jeremy ------------------ Filemaker's kind of like a wife; easy to love, yet just so complicated.
November 16, 200025 yr Author Thank you, Jeremy. I appreciate your help. Joe quote: Originally posted by yafreax: add the line Go to Record/Request First immediatly before the loop. Jeremy
November 16, 200025 yr Author Hi Jeremey, I tried this and it still isn't hitting the first record. I must be doing something wrong. If you can help I'd appreciate it. Joe quote: Originally posted by yafreax: add the line Go to Record/Request First immediatly before the loop. Jeremy
November 16, 200025 yr write out the exact syntax of your script for us and let us take a look. . . ( even if it is real long it may lie somewhere at the top of the script ) Jeremy
November 16, 200025 yr Author Will Do. Thank you. quote: Originally posted by yafreax: write out the exact syntax of your script for us and let us take a look. . . ( even if it is real long it may lie somewhere at the top of the script ) Jeremy
November 16, 200025 yr Author Jeremy, Here it is: ENTER BROWSE MODE GO TO LAYOUT PRINT SETUP FIND ALL SORT (RESTORE) LOOP GO TO RECORD/REQUEST/PAGE (EXIT AFTER LAST/NEXT) GO TO FIELD (
November 16, 200025 yr well, on the above, you didn't insert the line Goto record/request (first) insert this line directly in front of the loop If this was just a mistake in the posting, well there's only one more thing to do... put the goto record ( next / exit after last ) as the very last step in the loop This should fix it. Jeremy I keep typing the wrong thing, maybe i should profread! [This message has been edited by yafreax (edited November 16, 2000).] [This message has been edited by yafreax (edited November 16, 2000).]
November 17, 200025 yr Author Thank you. I'll try that. Joe quote: Originally posted by yafreax: well, on the above, you didn't insert the line Goto record/request (first) insert this line directly in front of the loop If this was just a mistake in the posting, well there's only one more thing to do... put the goto record ( next / exit after last ) as the very last step in the loop This should fix it. Jeremy I keep typing the wrong thing, maybe i should profread! [This message has been edited by yafreax (edited November 16, 2000).] [This message has been edited by yafreax (edited November 16, 2000).]
November 20, 200025 yr Author Hi Jeremy, The latter solution fixed it. I placed it at the very end of the loop and before End Loop and Exit Loop. It then worked. Thank you for your help! Joe quote: Originally posted by jtringale: Thank you. I'll try that. Joe
Create an account or sign in to comment