DBLockRecord()

DBLockRecord locks the current record in the current database. If you've already locked the file using DBLockDB or previously locked the record, FileFlex returns success. FileFlex automatically unlocks every other record or file (except the subject record's own file) when a new DBLockRecord is called. This technology also helps to prevent deadlocks.

When you're done using that record (and you should keep the record locked for as short a time as possible), call DBUnlock to free it up.

Some notes on multi-user files: FileFlex will attempt to access a locked file or record at approximately one second intervals. It will continue to do so until it gains access. If we find this becomes a problem, in a future version we may allow you to set the number of access attempts or time. Also, to prevent conflict or "deadlock", be sure that all users always lock and unlock records and files in exactly the same order.

put DBLockRecord() into theResult