Script to Change Value in Value List

[hociman]

I am using FileMaker 8.0. I have a database with a value list field whose options are "Yes" or "No". I would like to write a script that will go through all records in the database and change any instances of "Yes" to "No". Is this possible? I tried doing it the following way but was unsuccessful.

Show All Records

Go to Field [Contact::RSVP]

Set Field [Contact::RSVP; Contact::RSVP = "Yes"]

Go to Field [Contact::RSVP]

Perform Find/Replace [No dialog; Contact::RSVP = "Yes"; Contact::RSVP = "No"; Replace]

Thanks for reading!

[Vaughan]

Here is but one way of doing it:

Show All Records

Go to Record/Request [ first ]

Loop

If [ field = "Yes" ]

Set Field [ field ; "No" ]

End If

Go to Record/Request [ next ; exit after last ]

End Loop

[hociman]

Vaughan,

Thank you so much! I had tried a loop previously, but was unsuccessful. Cheers!