lockcurrentrecord(
lockcurrentrecord()

The lockcurrentrecord( function attempts to lock the current record, returns true if successful, false if failed.

Parameters

No parameters.

Description

This function attempts to lock the current record. It returns true if the record successfully locked, or false if the attempt failed (for example if the record is locked on another computer). Either way, the result is returned immediately, this function does not wait if the record cannot be locked.

    if lockcurrentrecord()
        Quantity = Quantity-1
        unlockrecord
    else
        message "This item is currently being edited by another user, please try again later."
    endif

If you want to find out additional detail about the lock attempt you can use the dbinfo( function with either the lockstatus or lockmessage options.

The lockstatus option returns the status of the last attempt made to lock a record. The possible results are:

- LOCKED - record was successfully locked
- BUSY - could not lock because another user has already locked the record.
- ERROR - could not lock the record because of an error (server disconnected, record missing on server, etc.)

The lockmessage option returns detail information about the last attempt made to lock a record. For example if the record is locked by another user, this message will include that user’s name and their computer name.

In addition to this function, you can also use the lockrecord statement or the lockorstop statement to lock the current record.

History

Version | Status | Notes
10.2 | New | New in this version.