Share via

BufferMode Property

  • Article

Specifies whether records are updated pessimistically or optimistically. Available at design time and run time.

Object.BufferMode[ = nValue]

Property Values

  • nValue
    The settings for the BufferMode property are:
    Setting Description
    0 (Default) None. Records are locked when editing begins and fields are written when the record pointer moves. Mimics FoxPro 2.x behavior.
    1 Pessimistic. Records are locked when editing begins and fields are written when the record pointer moves. You can use TABLEREVERT( ) to undo your changes to the current record.
    2 Optimistic. Records are not locked when edited and Visual FoxPro attempts to lock the records when they are written to disk with TABLEUPDATE( ).

Remarks

If BufferMode is set to 1 or 2, any cursor used by a Grid control is enabled for table buffering. Any other control bound to data uses row buffering.

The BufferMode property setting will override any buffering settings made to form cursors prior to the form Init method, including those made in the form Load method.

See Also

BufferModeOverride Property | TABLEREVERT( ) | TABLEUPDATE ( )

Applies To: Form Object | FormSet Object | _SCREEN