Show Contents List

Summary

REP008 - Virtual Fields

Important Observations

• Virtual fields must be first be defined in the Repository. The virtual fields can then be added to the file definition.

• Calculation virtuals can only be defined as Derive value when record is read. The other virtuals can use be defined as Derive value when record is read and Populate real field when writing to the file.

• Virtual fields can have validation rules just like real fields.

Tips and Techniques

• The Multi-add fields feature can add both real and virtual fields.

• Virtual fields cannot be used as key fields.

• Triggers provide another option for defining virtual fields in a file when more complex coding is required.

What I Should Know

• What are the different types of virtual fields.

• How to add virtual fields to a file.

Show Contents List