fillall
The fillall statement modifies the operation of the following fill statement so that all records are modified, not just visible records.
Parameters
No parameters.
Description
The fillall statement modifies the operation of the following fill statement so that all records are modified, not just visible records. It should only be used immediately before one of these statements: FormulaFill, FormulaFillAllFields, Propagate, Unpropagate, PropagateUp or UnPropagateUp.
There are certain situations where you would like to modify all records even if they aren’t all visible. For example, suppose you want to duplicate the current field. Here is a procedure that will do this:
local fname,fproperties,dfname
getfieldproperties "","",fproperties
fname=info("fieldname")
dbname="Copy of "+fname
fieldname dfname
insertfield fname
setfieldproperties fproperties
formulafill datavalue(dfname+"")
There is one problem though – if not all records are selected, not all of the data in the field will be copied. One solution would be to select all records first, but perhaps you would like to preserve the current selection. The answer is to use the fillall statement. Just change the last line of the procedure like this:
fillall formulafill datavalue(dfname+"")
With this modification, the formulafill statement will modify all records, both visible and invisible.
Note: The fillall statement doesn’t have to be on the same line as the formulafill statement – it could be on the previous line. Just make sure that there are no other statements in between the two.
See Also
- 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.
- 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.
- 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.
- 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
| 10.0 | New | New in this version. |