2 Replies Latest reply on Mar 7, 2010 7:39 AM by Celshader

    Help with a script to modify multiple records



      Help with a script to modify multiple records


      I have created a script that will perform a calculation on a singe record to fix some data in a database that I administer...


      Currently I just perform that script on the records as I use them. Is there a way to loop this script, so that I fixes every entry in the database in 1 pass?


      For simplicities sake, Here is an example:


      Lets say I have a variable called "X" and three records. In those records that variable is assigned the value of 1, 2, and 3.

      If I want to create a script that performs a calculation, say multiply the value by 3, how would I do this automatically with a script for all three records at once and result in those values being 3, 6, 9.


      Thanks for the help.


      I am using FM pro 8.5 on XP.

      I am completely self tought, so any concrete example would be very helpful.