Perform Find/Replace confusion

[ron G]

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...

[Raybaudi]

Aren't you using the wrong script step?

Look at:

Replace Field Contents [ ]

under the Fields group.

[ron G]

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

[LaRetta]

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. :^)