Shared Access to Data Commands and Functions

JavaScript Editor js editor     Web development 



Main Page

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



JavaScript Editor js editor     Web development