$RlcUsr: Difference between revisions

From m204wiki
Jump to navigation Jump to search
m (Added "as a five digit STRING with leading zeros")
m (Mlarocca moved page $RLCUSR to $RlcUsr: Lower case change)
(No difference)

Revision as of 14:25, 29 July 2014

The $RLCUSR function returns the user number of the user with which the request conflicted when the last record locking conflict occurred. This function is most useful when used within an ON FIND CONFLICT or ON RECORD LOCKING CONFLICT unit.

At the beginning of a request, $RLCUSR is set to null values. After a record locking conflict occurs, $RLCUSR returns the user number of the conflicting user as a five digit STRING with leading zeros. The $RLCUSR function takes no arguments.

Example

This request prints the user number of the user that invokes the ON RECORD LOCKING CONFLICT unit:

BEGIN ON RECORD LOCKING CONFLICT PRINT 'UNABLE TO COMPLETE' PRINT 'CONFLICTING WITH USER # ' WITH $RLCUSR END ON GET.NAME: FOR EACH RECORD WITH - FULLNAME LIKE 'BAKER*,DEROUCHE,TANGO*' CHANGE AGENT TO CASOLA END FOR END