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


History

VersionStatusNotes
10.2UpdatedIf the database contain summary records data records aren't modified, and propagation starts over after a summary record.
10.0UpdatedCarried over from Panorama 6.0, but can now be combined with the FillAll statement to modify both visible and invisible records.