CVAL
Top  Previous  Next

(CVAL('showkeyword'))

Returns the current value or setting of 'showkeyword'. You must either enclose the SHOW keyword in quotation marks or use a dot variable that has a TEXT data type to which you have assigned the SHOW keyword. You can use all SHOW keywords with CVAL, as well as DATABASE, DBPATH, CURRDIR.

The following keywords can be used for (CVAL('Keyword')):

·AND  
·ANSI  
·AUTOCOMMIT  
·AUTODROP  
·AUTOSKIP  
·BELL  
·BLANK  
·BUILD  
·CASE  
·CLEAR  
·CLIPBOARDTEXT  
·COLOR  
·COMPUTER  
·CONNECTIONS  
·CURRDIR  
·CURRDRV  
·CURRENCY  
·CURRENTPRINTER  
·DATABASE  
·DATE  
·DATE CENTURY  
·DATE FORMAT  
·DATE SEQUENCE  
·DATE YEAR  
·DBPATH  
·DEBUG  
·DELIMIT  
·DRIVES  
·ECHO  
·EDITOR  
·EOFCHAR  
·EQNULL  
·ERROR  
·ERROR DETAIL  
·ERROR VARIABLE  
·ESCAPE  
·EXPLODE  
·FASTFK  
·FASTLOCK  
·FEEDBACK  
·FILES  
·FIXED  
·HEADINGS  
·IDQUOTES  
·INSERT  
·INTENSITY  
·INTERVAL  
·LAST BLOCK TABLE  
·LAST ERROR  
·LAYOUT  
·LINES  
·LINEEND  
·LOOKUP  
·MANOPT  
·MANY  
·MAXTRANS  
·MDI  
·MESSAGES  
·MIRROR  
·MULTI  
·NAME  
·NETUSER  
·NOTE_PAD  
·NULL  
·OLDLINE  
·ONELINE  
·PAGEMODE  
·PASSTHROUGH  
·PLATFORM  
·PLUS  
·POSFIXED  
·PORTS  
·PRINTERS  
·PRN_Status  
·PRN_Orientation  
·PRN_Size  
·PRN_Source  
·PRN_Quality  
·PRN_Copies  
·PRN_ColorMode  
·PRN_DuplexMode  
·PRN_Collation  
·QUALCOLS  
·QUOTES  
·REFRESH  
·REVERSE  
·ROWLOCKS  
·RULES  
·SCRATCH  
·SCREENSIZE  
·SELMARGIN  
·SEMI  
·SERVER  
·SINGLE  
·SORT  
·SORTMENU  
·STATICDB  
·TIME  
·TIME FORMAT  
·TIME SEQUENCE  
·TIMEOUT  
·TOLERANCE  
·TRACE  
·TRANSACT  
·USER  
·USERDOMAIN  
·USERID  
·USERAPP  
·VERIFY  
·VERSION  
·VERSION BITS  
·VERSION BUILD  
·VERSION SYSTEM  
·WAIT  
·WALKMENU  
·WHILEOPT  
·WIDTH  
·WINBEEP  
·WINDOWSPRINTER  
·WRAP  
·WRITECHK  
·ZERO  
·ZOOMEDIT  


Examples:

In the following example, the value of vcval is OFF if the value of MULTI is set to off.

SET VAR vcval = (CVAL('MULTI'))  
 
In the following example, the user keyword is loaded into a variable and then the variable is used in the CVAL function. It returns the current user identifier.

SET VAR vword text = 'USER'  
SET VAR vuser = (CVAL(.vword))  
 
For more information about SHOW keywords, see SHOW.