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


History

VersionStatusNotes
10.0NewNew in this version.