runfieldcalculations
The runfieldcalculations statement performs any automatic calculations associated with the current field.
Parameters
No parameters.
Description
This statement performs any calculations that normally occur when data in this field is edited. Note: This statement operates only on the currently active record, not on all selected records.
In this example, the field Amount is set to 34.78. If there are any automatic calculations for the Amount field, they are calculated.
field Amount
Amount = 34.78
runfieldcalculations
That is, suppose field Tax has a formula Amount*05. The new amount for Tax will be assigned when runfield calculations executes. This statement does not run any automatic procedure associated with this field. If you want to run automatic procedures as well, use the runfieldsideeffects statement.
See Also
- addrecord -- adds a new record at the end of the current database.
- change -- replaces text with new text in the current field (selected records only).
- changeword -- replaces one word with another in the current field (selected records only).
- changewordexact -- replaces one word with another in the current field (selected records only).
- clearcell -- deletes the contents of the current field.
- clearrecord -- deletes the currently selected record.
- copycell -- copies the contents of the current field onto the clipboard,
replacing anything previously on the clipboard.
- copyrecord -- copies the contents of the current record onto the clipboard.
- cutcell -- delete the contents of the current cell and places the deleted data on the clipboard.
- cutline -- copies the current record to the clipboard and deletes it.
- cutrecord -- copies the current record to the clipboard and deletes it.
- Data Input Validation -- validation of data entry (checking for duplicates, etc.)
- deleteabove -- copies the current record to the clipboard and deletes it, then moves to the record above.
- deleteall -- removes all records, leaving a single blank record.
- deleterecord -- deletes the currently selected record.
- duplicaterecord -- duplicates the current record.
- editcell -- opens the edit window for the currently active field (or cell), highlighting the data, and allows you to edit that field.
- editcellstop -- opens the edit window for the currently active field (or cell), highlighting the data, and allows you to edit that field.
- editcellwith -- opens the edit window for the currently active field (or cell), using the supplied alternate text.
- emptyfill -- fills every empty visible cell in the active field with the specified value.
- fill -- fills every visible cell in the active field with the specified value.
- fillall -- modifies the operation of the following *fill* statement so that all records are modified, not just visible records.
- formulafill -- fills every visible cell in the active field with the result of the specified formula.
- formulafillallfields -- fills every visible cell in all fields with the result of the specified formula.
- insertbelow -- inserts a new record below the current record.
- insertbelowcarriagereturn -- inserts a new record below the current record and moves to the first column.
- insertrecord -- inserts a new record above the current record.
- moverecorddown -- moves the current record down one line.
- moverecordup -- moves the current record up one line.
- outlinelevel -- expands or collapses the entire database to show a specific level of data or summary level.
- pastecell -- pastes the contents of the clipboard into the current cell.
- pasteline -- inserts a new record containing the contents of the clipboard.
- pasterecord -- inserts a new record containing the contents of the clipboard.
- post -- assigns a value to a field in another database.
- propagate -- fills all the empty cells in the current field. Each empty cell is filled with the value of the first non-empty cell above it.
- propagateup -- fills all the empty cells in the current field. Each empty cell is filled with the value of the first non-empty cell below it.
- removeselected -- deletes all selected records from the database.
- removeunselected -- deletes all unselected records from the database.
- resetallrecordidts -- resets the internal record id and time stamps for every record in the current database.
- runfieldsideeffects -- performs any side effects associated with the current field (calculations, procedures, etc.).
- runningdifference -- calculates the running difference for the current field.
- runningtotal -- calculates the running total for the current field.
- sequence -- fills every visible cell in the current field with a numeric sequence.
- speedcopy -- copies multiple adjacent fields from a record in one database to a record in another.
- summarylevel -- changes the summary level of the current line.
- unpropagate -- removes repeating data from the currently selected field. If several records in a row contain the same data, this statement erases all but the first (top) value.
- unpropagateup -- removes repeating data from the currently selected field. If several records in a row contain the same data, this statement erases all but the last (bottom) value.
History
| 10.0 | New | New in this version. |