Specifies whether a table associated with a Cursor object is opened exclusively. Available at design time; read/write at run time.
DataEnvironment.Cursor.Exclusive[ = lExpr] |
Return Value
- lExpr
-
The settings for the Exclusive property are:
Setting Description True (.T.)
(Default) The table associated with the Cursor is opened exclusively when the data environment is loaded.
False (.F.)
The table associated with the cursor is not opened exclusively when the data environment is loaded.
Remarks
Applies To: Cursor Object
Note: |
---|
When the Cursor object is accessed using CURSORSETPROP(), the Exclusive property is read-only at run time. |
When the data environment is loaded, each table associated with a Cursor can be opened exclusively (no other user in a multiuser environment can access the table) or in shared mode. Use the Exclusive property to specify how the table is accessed.
Note: |
---|
If you set the DataSession property to 2 (Private Data Session), the default setting of the Exclusive property for all Cursor objects in the data environment is changed to false (.F.). |
For views, the View object itself is always opened in shared mode. However, the tables that define the view are affected by the Exclusive property. For local views, the Visual FoxPro tables that define the view are opened in exclusive or shared mode, depending on the setting of the Exclusive property. The Exclusive property has no effect on remote views.
The Exclusive property mimics the behavior of the USE command's EXCLUSIVE and SHARE clauses.