Why is the equal sign showing up,
I would guess that your script specifies the = sign and it would not appear to be needed for this kind of search. I'd need to see your script in order to suggest a change.
Why is the Find not continuing?
Because your script failed to find any records and you have not used Set Error Capture [on] to suppress the error message that automatically appears when your script fails to find any records.
For examples of scripted finds that you might find helpful: Scripted Find Examples
And if you want to post the script so that others can examine it:
To post a script to the forum:
- You can upload a screen shot of your script by using the Upload an Image controls located just below Post a New Answer.
- You can print a script to a PDF, open the PDF and then select and copy the script as text from the opened PDF to your clipboard for pasting here. (with this approach, you can get multiple script steps on the same line, please edit the pasted text by inserting some returns to separate those steps.)
- If You have FileMaker Advanced, you can generate a database design report and copy the script as text from there.
- If you paste a text form of the script, you can use the Script Pretty box in the Known Bugs List database to paste a version that is single spaced and indented for a more professional and easier to read format.
Screen shot of my script.
Can you upload a screen shot of the dialogs you can open by double clicking Perform Find [Restore] ?
Can you show the expression used in the script parameter for the variable used in this find request?
I want the work order to open that I am requesting to open.
If you look at the specify find requests dialog, you'll see that you have:
try changing that to:
Or you might try one of the alternative methods that I referred you to when I posted a link to here: Scripted Find Examples
Not only does that avoid "burying" the find criteria where you can't see it when you review your script in the script editor, it allows you to use calculations to produce the desired criteria.
That worked! Why? Do variables not require logical comparators in Find requests, or is there an assumed comparator?
ie., < = >
I don't think it was the = operator, but the space between it and the variable. I'd have to test to be sure as I much prefer to use the other method for scripted finds, but if the text shown in your first screen shot, "= 141824" is what your script is producing here, it's not searching for 141824, it's searching for " 1414824" note the leading space.
In both manual and scripted finds, you don't necessarily need any operator. If you enter just text into a text field, you are finding all records where the value in this field starts with that text. I didn't figure you needed that operator given the fact that you are always using the full value of this field as search criteria anyway.