AfterUpdate Event

Occurs immediately after an update operation for a record is performed.

Note

If batch updating is used, that is, the CursorAdapter BatchUpdateCount property is greater than 1, AfterUpdate does not occur.

PROCEDURE Object.AfterUpdate
LPARAMETERS cFldState, lForce, nUpdateType, UpdateInsertCmd, DeleteCmd, lResult

Parameters

cFldState
Specifies the field states of the row being processed. This is the same value as obtained from calling the following function:
```
GETFLDSTATE(-1)
```
For example, this value can be a character string consisting of deletion and edit status values for all fields in the table or cursor. If a table has five fields and only the first field has been edited, GETFLDSTATE( ) returns a value of 121111. The number 1 in the first position indicates the deletion status has not been changed.
lForce
Specifies the value of the lForce parameter from the TABLEUPDATE( ) function.
nUpdateType
Specifies the value of the nUpdateType parameter from the BeforeUpdate event.
UpdateInsertCmd
Specifies the value of the UpdateInsertCmd parameter from the BeforeUpdate event.
DeleteCmd
Specifies the value of the DeleteCmd parameter from the BeforeUpdate event.
lResult
Specifies the value returned by running TABLEUPDATE( ) for this record.

The following table describes values for lResult.

lResult

Description

True (.T.)

Clears field states for the record.

False (.F.)

Does not clear field states for the record.

You can change the value of lResult to override the result as returned.

lResult	Description
True (.T.)	Clears field states for the record.
False (.F.)	Does not clear field states for the record.

You can call the AERROR( ) function to retrieve errors from upstream data sources.

In Visual FoxPro 9.0, the target record is kept current in an ADODB.Recordset during the AfterUpdate event.