amypaulsmom Posted February 25, 2002 Posted February 25, 2002 I am trying to re-set a find within a script. I have done the find before I enter the scriptmaker. Then I go into the script and look at it and close it. When I close it - I tell it to replace the Find Requests. What am I missing - it is stuck on the original found set!!! I have tried it with restore find requests both on and off. Help.
LiveOak Posted February 26, 2002 Posted February 26, 2002 You must have restore on. This is an option in both the script steps "Enter Find Mode (restore)" and "Perform Find (restore)". If you are just doing a canned fine, use ONLY "Perform Find (restore)". As a general rule, is is best not to ever use the restore option. It is not self documenting, the only way to see what find the script is performing is to either run it then do a restore and look or to print the script. It is a much better practice to always do finds explicitly: Enter Find Mode () Set Field (...,...) Set Field (...,...) . . . Set Field (...,...) Perform Find () Then there is no mystery what find is being performed. -bd
amypaulsmom Posted February 26, 2002 Author Posted February 26, 2002 Okay - so here is the script I created Enter Find Mode () Set Field (Terms, Terms = "NET 30") Set Field (Days Since Invoice Posted, Days Since Invoice Posted > 30) Preform Find () Sort (Restore, No Dialog) It Enters the Find mode fine, but then tries to put a 0 in the Terms field, not NET 30. And then I get a No Records Match this Request and have to manually complete the loop. What am I missing?? Thanks for the help.
Fitch Posted February 26, 2002 Posted February 26, 2002 Is the Term field a text field? That's the only way something like "NET 30" can work properly. Is Days Since Invoice Posted a number field? Set Field() won't work with symbols like "> 30" -- try Insert Calculated Result(), and be sure to put it in quotes. Put a Pause Script before the Perform Find so you can verify the Find Requests are as you intended. That's step one in troubleshooting; take out the Pause once it's working.
amypaulsmom Posted February 26, 2002 Author Posted February 26, 2002 Good morning and thank you That seemed to take care of my find problem within that script. Have my meeting today with my client. Let's hope and pray they like the changes I have made.
Recommended Posts
This topic is 8310 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