The Mass Update command allows you to modify the values of one or more columns of all selected records at one time. A column must be designated as capable of being updated by mass update by selecting the Mass Updatable? check box in the Data Window tab of the User Control Properties dialog box.

When you select this command the application displays a dialog box. The left side of this dialog box shows all the columns in the table that can be updated. The right side of the dialog box provides a field to enter (or select) the value to which the selected columns will be set. (After entering the value in the field, the application places a check mark in the Modified? check box on the left side to indicate that the column's value will be changed.)

Note:  For location-referenced data tables, type NULL in the field to set the selected column's value to NULL. For list data tables, select the Set to Null check box.

Calculations Involving Numeric Columns

For numeric columns ("R" view type), you can set all selected records either to some constant or use a Groovy script. The script may include the column ID of any numeric column in the table, not just the column that is being updated. Examples of update expressions are shown below:

IRI_IND*1.5+IRI_OLD [column updated using the values in two columns]

Math.log(COL_1) [uses Math Functions from Java.Math Library]

Note: When evaluating formulas, the original data from the data window (before opening the dialog box) is used. For example, if the formula for COL_1 is COL_2 + 1 and formula for COL_2 is COL_1 * 3, the original values for COL_1 and COL_2 are used to evaluate both formulas.
  • No labels

Provide Feedback