How to Determine the Application Locking Code of a Function
If you need to find out what type of locking code has been assigned to a function, connect to the database through SQLTalk using the User ID of DELTEK.
Then, issue the following command:
SELECT S_LOCK_MTHD_CD FROM S_APPL_FUNC WHERE FUNC_TITLE_NAME = 'function title';
'function title' must match exactly the name of the function as it appears on the Navigate screen. That means entering the exact spacing and upper- and lower-case letters.
S_LOCK_MTHD_CD must be one of the following:
- N for no locking
- S for single locking
- U for user locking
- R for restart locking
Parent Topic: Application Locking/Dynamic Tables