| True DataControl 8.0 Reference > Field Object > Field Object Properties > CalculatedExpression Property |
Specifies the expression used to calculate field values.
Field.CalculatedExpression= variant
Read/Write at run time and design time. Property applies to Field object.
This property specifies the expression used to calculate the field's value. It is normally used for calculated fields, but data fields can also have calculated expressions, in which case the field's value changes whenever one of the fields referenced in the expression changes.
If your algorithm for calculating fields is too complex to be represented by expressions, you can use the CalcFields event to determine the values of calculated fields.
See True DataControl Fields for information about data fields and calculated fields. See True DataControl Expressions for general information about expressions. Evaluation rules for CalculatedExpression are as follows:
Expression Level: Record level
Synchronous Evaluation: Evaluated after a record has been fetched from the database.
Asynchronous Evaluation: Updates the field value.
This property has associated applicability condition in the CalcConditionExpression.