BufferModeOverride Property

Applies To   See Also

Specifies whether to override the BufferMode property set at the form or form set level. Available at design time and run time.

Syntax

DataEnvironment.Cursor.BufferModeOverride[ = nValue]

Settings

nValue

The settings for the BufferModeOverride property are listed in the following table:

Setting Description
0 None. No buffering is done.
1 (Default) Use form Setting. Uses the BufferMode property set at the form or form set level.
2 Pessimistic row buffering. Locks the record and buffers the changes until the record pointer moves. You can use TABLEREVERT( ) to undo your changes.
3 Optimistic row buffering. Allows edits to a single record and locks the record only when it is written to disk. You can use TABLEREVERT( ) to undo your changes.
4 Pessimistic table buffering. Locks each record edited, but records are not written to disk until TABLEUPDATE( ) is called. You can use TABLEREVERT( ) to undo your changes.
5 Optimistic table buffering. Allows edits to all records and does not lock them until the records are written to disk with TABLEUPDATE( ). You can use TABLEREVERT( ) to undo your changes.

Remarks

If the cursor is based on a local or remote view, the only BufferModeOverride settings available are 3 and 5. If the form set or form's BufferMode property is set to 1 (Pessimistic), the default setting for BufferModeOverride is 3 (Optimistic row buffering) for cursors based on views.