I created a subset of my Members table. It holds PK_ID and Type

I collect into $$PriorType the value of the PRIOR value of the selected 'Type'.

I collect into $$NewType the value of the CURRENT valaue (collected on EXIT) of the 'Type'

From a script, everything works as expected until I get to the Replace command:

At best, I can change the first Type in the first record. Additional Types remain unchanged.

I am not real clear on the optional settings on Find/Replace but I have tried all the different combinations and permutations with frustrating results.

I can 'see' in debug that everything is working as expected. But, when I get to Find/Replace, I am unable to get all the 'found set' to be changed.

Also, I can see the cursor in the top record in the Type field. The record below remains unchanged. If that isn't weird enough, Close Window does not close the window? huh...

Aren't you using the wrong script step?

Look at:

Replace Field Contents [ ]

under the Fields group.

Aren't you using the wrong script step?

Look at:

Replace Field Contents [ ]

under the Fields group.

Thank you for the suggestion.

However, it turns out that the $$NewType was set when I closed a window which triggered an ON EXIT script. I never thought that closing a window would trigger such an event; but it does. Mystery solved.

However, I still had to 'guestimate' my way through the meaning of the various Replace dialog options. And, I can't find anything on the FM web site that provides anything but the barest of explanations. Got any ideas?

Ron

However, I still had to 'guestimate' my way through the meaning of the various Replace dialog options.

Uhm, as Daniele was saying, you are using the wrong script step -

If you want, as you say, "I can change the first Type in the first record. Additional Types remain unchanged." then I think you need to use Replace Field Contents[]. It is common to get those two mixed up the first time; we've all gone through it. :^)