| onerecord | A record set consisting of a single record. |
| value | The value to return. This may be any expression yielding a value. |
| Return: | EVALUATE returns a single value. |
The EVALUATE function returns the value evaluated in the context of the onerecord set (which must be a single record, only). This function typically uses indexing to select a single record for the onerecord recordset. The usage is to return a value from a specific child record when operating at the parent record's scope level. The advantage that EVALUATE has over using recordset indexing into a single field is that the value returned can be any expression and not just a single field from the child dataset.