Specifies whether records are updated pessimistically or optimistically. Available at design time and run time.
Syntax
Object.BufferMode[ = nValue]
Settings
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.