TABLEREVERT( ) Function

Discards changes made to a buffered row or a buffered table or cursor and restores the OLDVAL( ) data for remote cursors and the current disk values for local tables and cursors.

NoteNote

On a network, the data currently on disk might differ from the data on the disk when the table was opened or the cursor was created. Other users on the network might have changed the data after the table was opened or the cursor was created.

TABLEREVERT( [lAllRows [, cTableAlias | nWorkArea] ] )

Parameters

lAllRows

Determines whether all changes made to the table or cursor are discarded. The following table describes the values for lAllRows.

lAllRows Description

False (.F.)

If table buffering is enabled, only changes made to the current record in the table or cursor are discarded. (Default)

True (.T.)

If table buffering is enabled, changes made to all records are discarded in the table or cursor.

If row buffering is enabled, Visual FoxPro disregards the value of lAllRows, and changes made to the current record in the table or cursor are discarded.

cTableAlias

Specifies the alias of the table or cursor in which the changes are discarded.

nWorkArea

Specifies the work area of the table or cursor in which the changes are discarded.

Expand imageReturn Value

Expand imageRemarks

Expand imageExample

Expand imageSee Also


© , 1996-2020 • Updated: 11/10/20
Comment or report problem with topic