VP SET FIELD

Home

4D v19

VP SET FIELD


VP SET FIELD ( rangeObj ; field {; formatPattern} )

Parameter	Type	Description
rangeObj	Object	Range object
field	Pointer	Reference to field in virtual structure
formatPattern	Text	Format of field

Description

The VP SET FIELD command assigns a specified 4D database field to a designated cell range.

In rangeObj, pass a range of the cell(s) whose value you want to specify. If rangeObj includes multiple cells, the specified field will be linked in each cell.

The field parameter specifies a 4D database field to be assigned to the rangeObj. The virtual structure name for field can be viewed in the formula bar. For information about the supported field types and the virtual structure, see Field references. If any of the cells in rangeObj have existing content, it will be replaced by field.

The optional formatPattern defines a pattern for the field parameter. Pass any custom format (for information on patterns and formatting characters, please refer to the 4D View Pro Cell Format section).

Example

VP SET FIELD(VP Cell("ViewProArea";5;2);->[TableName]Field)