serverformulafill
SELECTFORMULA
,
FILLFORMULA

The serverformulafill statement fills a specified subset of records in a shared database.


Parameters

This statement has two parameters:

selectformula – true false formula that specifies which records should be modified.

fillformula – value formula that specifies how the new values of the cells in the current field will be calculated.


Description

This statement fills a specified subset of records in a shared database. The select and fill operations are performed independently on both the local computer and the server. Only the formulas are transmitted to the server, not the actual data values, making this statement potentially faster than a regular formulafill statement. However, the data values will still have to be synchronized later to all computers, so the speed difference may not be significant.

This example finds all records where the Status field contains Paid, and sets the Balance field to 0 for those records.

field Balance
serverformulafill Status="Paid",0

Note: In Panorama 6 and earlier, the select and fill formulas were not allowed to contain variables. This restriction has been eliminated from Panorama X.


See Also


History

VersionStatusNotes
10.2UpdatedCarried over from Panorama 6.0, no longer restricted from using variables in formulas.