Updating all records at once

[Rattlesnake]

hi,

Sorry if I am asking a silly question. But i am new to filemaker 5.5 and wanted to know as to how can i update a single field in all records using a script. I tried using the "Replace" command , but it pops up the dialog box where i have to confirm what i want to do(i want to update them immediately). (i used the set field command but it only changes the field in the current record).

Is there any other way to do it?

Thanks

[Lee Smith]

I don't think we have enough information to help you. You need to give us some detail on what it is you want to do. Update can mean a lot of things as you have discovered in your question. Replace means replace this with that. Update can mean, change the contact date for this group to today's date.

Lee

[LaRetta]

Hi Rattlesnake!

It sounds like you might want a script which would loop through a series of records and perform one (or many tasks) at once? If so, to apply changes to All Records, a Found Set, or an Imported Set, you might use a loop similar to below. Everything inside this loop will repeat with each record in the 'set,' as follows:

Go to Record/Request/Page

[ First ]

Freeze Window

Loop

Set [YourField,"NewValue"]

-- Do anything else you might want apply to this particular record --

Go to Record/Request/Page

[Next,Exit after last]

End Loop

Go to Record/Request/Page

[ First ]

If this script is to be applied to all records in the dB, start the script-line with Show All Records. The last line (Go to Record/Request First) leaves you cleanly at Record 1 again when the loops ends, so you can apply a new set of instructions for the 'set,' such as OMIT Found Set. If, at the End Loop, you are ready to exit the script, you can omit that last Record/Request/Page line (outside the loop) because the same line within the loop will automatically exit the script if it's the last record.

As I've been repeatedly reminded on this Forum (thank God), back up before applying any new process; particularly something I suggest (although I always test my suggestions first). I'm quite new to scripting but most of my scripts look like this. I also suggest checking out CobaltSky & Looping Scripts!! His assistance during my Data Conversion was particularly helpful to me

LaRetta

[SteveB]

You can use the replace command. At the bottom of the window there is a checkbox that says perform without dialog.