Get(ModifiedFields)

Returns a list of fields that have been modified in the current record of the current table.

Format

Get ( ModifiedFields )

Parameters

None

Data type returned

text

Originated in version

13.0

Description

Returns a list of fields modified since the last time the record was committed. The list includes stored calculation fields that are dependent on one or more fields that have been modified. Field names are separated by carriage returns.

For a new record, the list is always empty because the record has never been committed.

Example 1

When the Invoices::Customer Name and Invoices::Company fields are modified and the record is open, Get(ModifiedFields) returns:

Customer Name Company