Tuesday, February 6, 2007
Tip of the Day: Finding Table/View Locks Programmatically
Supported Versions:
. R:BASE 7.6 for Windows (Build: 7.6.1.30206 or higher)
. R:BASE C/S:I 7.6 for Windows (Build: 7.6.1.30206 or higher)
. R:BASE Turbo V-8 for Windows (Build: 8.0.15.30206 or higher)
Did you know that you can find the table or view locks using
the new (GETVAL('GetLock','tableviewname')) function in R:BASE?
Here's how:
SET VARIABLE vCheckLock TEXT = NULL
SET VARIABLE vCheckLock = (GETVAL('GetLock','tableviewname'))
Where:
GetLock is the first required parameter and the tableviewname is
the name of table or view.
The variable vCheckLock will return the text value of ON or OFF.
Have fun!
Very Best R:egards,
Razzak.
