Shared Access to Data Commands and Functions

Article
06/18/2008

These commands and functions make it possible for multiple users on a network to share data from tables.

Use	To
CURSORSETPROP( ) Function	Specify property settings for a Visual FoxPro table or a cursor.
CURVAL( ) Function	Return field values directly from disk for a table or a remote data source.
FLOCK( ) Function	Attempt to lock the current or specified table.
LOCK( ) Function or RLOCK( ) Function	Attempt to lock one or more records in a table.
OLDVAL( ) Function	Return original field values for fields that have been modified but not updated.
SET EXCLUSIVE Command	Open table files for exclusive or shared use on a network.
SET LOCK Command	Enable or disable automatic file locking in certain commands.
SET MULTILOCKS Command	Determine whether you can lock multiple records using LOCK( ) or RLOCK( ).
SET REFRESH Command	To update a browse window or memo editing window, or to refresh local memory buffers with changes from other users on the network.
SET REPROCESS Command	Specify how often and for how long Visual FoxPro attempts to lock a file or record after an unsuccessful locking attempt.
SYS(3051) - Set Lock Retry Interval	Specify the time in milliseconds that Visual FoxPro waits before attempting to lock a record, table, memo, or index file after an unsuccessful locking attempt.
SYS(3052) - Override SET REPROCESS Locking	Specify whether Visual FoxPro uses the SET REPROCESS setting when attempting to lock an index or memo file.
TABLEREVERT( ) Function	Discard 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.
TABLEUPDATE( ) Function	Commit changes made to a buffered row, a buffered table, cursor, or cursor adapter.
UNLOCK Command	Release a record lock, multiple record locks, or a file lock from a table or all open tables.

See Also

Other Resources

Shared Access to Data

Language Categories