LOCKED BY

LOCKED BY ( {aTable ;} process ; 4Duser ; sessionUser ; processName )

Parameter	Type		Description
aTable	Table	🡒	Table to check for record locked, or Default table, if omitted
process	Longint	🡘	Process reference number
4Duser	String	🡘	4D user name
sessionUser	String	🡘	Name of user that opened work-session
processName	String	🡘	Process name

Description

LOCKED BY returns information about the user and process that have locked a record. The process number(*), the user name in the 4D application and in the system as well as the process name are returned in the process, 4Duser, sessionUser, and processName variables. You can use this information in a custom dialog box to warn the user when a record is locked.

(*) This is the number of the process on the machine where the code that actually locked the record is executed. In the case of a trigger or a method that is executed on the server, the number of the "twin" process on the server machine is returned. In the case of a method that is executed on a remote application, the number of the process on the remote machine is returned.

If the record is not locked, process returns 0 and 4Duser, sessionUser, and processName return empty strings. If the record you try to load in read/write has been deleted, process returns -1 and 4Duser, sessionUser, and processName return empty strings.

The 4Duser parameter returned is the user name from the 4D password system or the user alias as defined with the SET USER ALIAS (if any). If there is no password system or alias defined, “Designer” is returned.

The sessionUser parameter returned corresponds to the name of the user that opened the session on the client machine (this name is displayed more particularly in the 4D Server administration window for each open process).

If the record has been locked by a $lock REST request:

• process returns -2
• 4Duser returns ""
• sessionUser returns ""
• processName returns the IP address of the locker, e.g. "127.0.0.1"

See also

Locked
Record Locking