IF the script works for a single record, you can LOOP the script:
Go to Record (first)
Perform script (your script here)
Exit loop if ( Get ( FoundCount ) = Get ( RecordNumber ) // stop after process last )
Go to Record (next)
I have bunged that in and run it. Its rather slow, but I think it may be working. I will know once it has finished doing its loop of all the records. Will report back then.
If the script just contains a simple calculation then you could use the "Replace field contents" function.
Put the cursor in the field and then click
and that will replace the field contents with the calculation you specify.
Thanks Carl, it was quite complex to be fair. I haunt clocked before, but it was updating around 20 records at a time, so it was quicker than I thought. All done in around 3 minutes and all worked perfectly!
The other option for "batch updates" of large numbers of records is to use Replace Field Contents. There's a calculation option that can assign a different, calculated value to each record.
You might also have simply defined a calculation field. That field would have evaluated on each record the moment you left Manage | Database after adding that field and its calculation.
This is the kind of script that would benefit from being performed on the Server, either through the Perform Script on Server (PSoS) or a scheduled script.