Purpose:
Used to lock a DataView or Action Parameter.
Overview:
A Lock requires a stored procedure that returns either 1 for locked or 0 for not locked.
If the stored procedure contains parameters, these become the Lock Parameters
Usage:
A Lock is used by attaching it to either an Action Parameter or DataView Parameter. If the Lock contains Lock Parameters, these can be mapped to other parameters or defaulted.
Configuration:
Lock Name:
The name by which the Lock will be known within FrameworX.
(Hint) Use meaningful names as this will help identify the Lock when used elsewhere in FrameworX.
Description:
(Optional) Brief description of the Lock.
Database Connection:
The Database Connection containing the stored procedure to be used for the Lock.
Stored Procedure:
The name of the stored procedure to be used for the Lock.
The last select in the stored procedure becomes the result of the Lock.
Cached:
Switches caching on or off for the Lock result based on Lock Parameter combinations.
Cache Lifetime:
If cacheing is enabled, the lifetime (in seconds) determines how long the Lock result is held in cache. A value of 0 causes the Lock result to be held in the cache permanently for the Lock Parameter combination.