Flock Function |  |
Lock an opened and shared database file.
Namespace: XSharp.RT
Assembly: XSharp.RT (in XSharp.RT.dll) Version: 2.21
SyntaxRemarks
If a database file is opened in shared mode, you must obtain a file lock before attempting any operation that updates the database file with a scope or a condition.
For each invocation of FLock(), there is one attempt to lock the database file (and other related files, such as index and memo files), and the result is returned as a logical value.
A file lock fails if another process currently has a file or record lock for the same database file. If FLock() is successful, the file lock is locked and other processes are prevented from making updates until the lock is released. FLock() provides a shared lock, allowing other users read-only access to the locked file while allowing only the current process to modify it. A file lock remains in effect until you close the database, explicitly unlock it (with DBUnLock(), for example), or attempt another file or record lock (with RLock() or DBRLock()).
By default, this function operates on the currently selected work area.
It can be made to operate on an unselected work area by specifying it within an aliased expression or by calling the overload that accepts a workarea parameter (a workarea number or alias ).
This feature is useful since FLock() does not automatically attempt a file lock for related files.
A file lock fails if another process currently has a file or record lock for the same database file. If FLock() is successful, the file lock is locked and other processes are prevented from making updates until the lock is released. FLock() provides a shared lock, allowing other users read-only access to the locked file while allowing only the current process to modify it. A file lock remains in effect until you close the database, explicitly unlock it (with DBUnLock(), for example), or attempt another file or record lock (with RLock() or DBRLock()).
By default, this function operates on the currently selected work area.
It can be made to operate on an unselected work area by specifying it within an aliased expression or by calling the overload that accepts a workarea parameter (a workarea number or alias ).
This feature is useful since FLock() does not automatically attempt a file lock for related files.
Examples
This example uses FLock() for a batch update of prices in INVENTORY.DBF:
This example attempts a file lock in an unselected work area:
X#
1USE inventory SHARED NEW 2IF Inventory->FLock() 3 REPLACE ALL Inventory->Price WITH ; 4 Inventory->Price * 1.1 5ELSE 6 QOut("File not available") 7ENDIF
X#
1USE sales NEW 2USE customer NEW 3IF !Sales->FLock() 4 QOut("Sales is in use") 5ENDIF
See Also