Applying script to all records

[kevino]

I have a simple script that copies data from one field into another. I'd like to apply this script to all of the records in the database. How can I make the script advance through each record?

[aldipalo]

If I understand you correctly you want to copy the contents of FieldA to FieldB in each record within your database?

Allow User Abort (Off)

Go To Record/Request/First

Loop

If(IsEmpty(FieldB))

Set Field(FieldB;FieldA)

EndIF

Go To Record/Request/Next; Exit after Last

End Loop

A few comments/Cautions:

The If statement is there only if there may already be data in FieldB in some records that you do not want to change.

If the database is large it will run for several minutes.

MAKE A BACKUP of your files before running this script!

If this is not what you need let us know.

hth

[Lee Smith]

I would remmend against using a Abort Scrft Step.

Lee

[kevino]

Thanks for the help. That did exactly what I needed it to. Now I know how to use the Go to Record/Request/Page command.

[Vaughan]

The Replace script step will also work. The conditional can be specified in the calculation.