i had the same issue.. i solved it by scripting a command named Exact()
I would be very interested in learning how you made Exact() work for finding a specific part number. Exact() as defined in FM documentation returns a 1/true or 0/False when the evaluation is performed. How the this result producepart number match?
if you go into find mode, enter "==Whatever" in a col/field and perform find the result set will be ONLY those rows in where the contents of the column contain exactly "Whatever".
The find operator "==" means case sensitive character by character match.
You will have to explain what you mean by "field is shaded" and post the entire script.
Am not experienced enough to answer you on that.. :/
But this is how i coded mine. (it might help)
I built a DB that stores server passwords for our IT department. so am having some security that need to be passed before the password is shown.
This code simply checks if the written password is correct. is an exact match with the password stored in my user database. caps and all.
I have no idea if its a good written code or not, but it works =) only thing that counts for me =D
"Learning by doing"
The OP mentions he is using/trying to use find mode.
You script does not use find mode.
Might be confusing to the OP
Instead of Perform Find [restore], try...
Enter find mode
Set field [ yourfield ; "==" & $$yourpartnumber ]
Thanks to all of you for your suggestions..... Will try them today..... I am a newbie so takes me a bit of time to do this