propagate
propagate

The propagate statement 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.

Parameters

No parameters.

Description

The propagate statement 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.

This example computes the outstanding balance for each company in an invoice database. It uses the propagate statement to copy the address information from the data records into the newly created summary records.

    field Company
    groupup
    field Balance
    total
    field Address
    propagate
    field City
    propagate
    field State
    propagate
    field Zip
    propagate

Note: When combined with the fillall statement, the propagate statement can modify invisible records as well as visible records. See the FillAll statement for details.

Note: If the database contains summary records, only the summary records will be modified, and the propagation will start over after each summary record. See Propagate & Unpropagate for more details about this.

See Also

- @calculations --
- 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).
- 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.
- outlinelevel -- expands or collapses the entire database to show a specific level of data or summary level.
- 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.
- resetallrecordidts -- resets the internal record id and time stamps for every record in the current database.
- runmodifyfill -- runs the .ModifyFill procedure (if it exists).
- 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.
- slidedata -- slides the columns at and to the right of the current column.
- 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

Version | Status | Notes
10.2 | Updated | If the database contain summary records data records aren't modified, and propagation starts over after a summary record.
10.0 | Updated | Carried over from Panorama 6.0, but can now be combined with the FillAll statement to modify both visible and invisible records.