Friday, March 16, 2007
Tip of the Day #2: Using New CHKCUR Function in R:BASE
Supported Versions:
. R:BASE Turbo V-8 for Windows (Build: 8.0.15.30316 or higher)
. R:BASE 7.6 for Windows (Build: 7.6.1.30316 or higher)
. R:BASE C/S:I 7.6 for Windows (Build: 7.6.1.30316 or higher)
If you need to know whether a CURSOR is already DECLAREd or
DROPped, now you may use the CHKCUR function to find the
current status of a given cursor name.
Here's how:
SET VARIABLE vCheckCuror = (CHKCUR('cursorname'))
Function CHKCUR checks to see if a cursor is declared and
is not dropped. The function returns an integer value of 1
if the cursor exists and is not dropped, and 0 if it is not
declared or dropped.
The variable vCheckCursor will return a value of 1 or 0.
Have fun!
Very Best R:egards,
Razzak.
