Assigns a field modification or deletion state value to a field or record in a table or cursor.

SETFLDSTATE(cFieldName | nFieldNumber, nFieldState [, cTableAlias
   | nWorkArea])

Parameters

cFieldName| nFieldNumber

Specifies the name or the number of the field for which the modification or deletion status is assigned. The field number nFieldNumber corresponds to the position of the field in the table or cursor structure. DISPLAY STRUCTURE or FIELD( ) can be used to determine a field's number.

To set the deletion status for the record, include 0 as the field number.

nFieldState

Specifies a value for the field modification or deletion status. The following table lists the field modification or deletion state value and the corresponding modification or deletion status:

nFieldState Modification or deletion status

1

Field has not been modified or deletion status has not changed.

2

Field has been modified or deletion status has changed.

3

Field in an appended record has not been modified or deletion status has not changed for the appended record.

4

Field in an appended record has been modified or deletion status has changed for the appended record.

cTableAlias

Specifies the alias of the table or cursor in which the modification or deletion status is assigned.

nWorkArea

Specifies the work area of the table or cursor in which the modification or deletion status is assigned. The field modification or deletion state value is assigned for the table or cursor open in the currently selected work area if SETFLDSTATE( ) is issued without the optional cTableAlias or nWorkArea arguments.

Expand imageReturn Value

Expand imageRemarks

Expand imageExample

Expand imageSee Also