unpropagateup

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


Parameters

No parameters.


Description

The unpropagateup statement 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. The difference between this statement and the unpropagate statement is that unpropagateup scans the database upwards, from bottom to top.

This example removes duplicate names from a mailing list. If two records have the same name, this procedure will keep the one that was originally closer to the bottom of the database. (If you want to keep the one that was closer to the top of the database, use the unpropagate statement.)

field Name
sortup
unpropagateup
select Name <> ""
removeunselected

This example first uses sortup to bring all of the duplicate records together. It then uses unpropagateup to clear out the duplicate names. Finally, it uses removeunselected to actually remove the duplicate records.

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


See Also


History

VersionStatusNotes
10.0UpdatedCarried over from Panorama 6.0, but can now be combined with the FillAll statement to modify both visible and invisible records.