SET( ) Function
Returns the status of various SET commands.
SET(cSETCommand [, 1 | cExpression | 2 | 3 | 4])
Parameters
cSETCommand
Specifies a character expression of the SET command for which you want to return information. The current setting of the specified command is returned as a character or numeric string.1 | cExpression| 2 | 3 | 4
Specifies additional information to return about a SET command. The values 1 and cExpression are identical. cExpression can be any expression that evaluates to a character type value.Note
Including an argument does not return additional information for all SET commands. Only those that specify values of 1, 2, 3, or 4 in the following table return additional information.
SET command
Value returned
ALTERNATE
ON or OFF
ALTERNATE, 1
FileName
ANSI
ON or OFF
ASSERTS
ON or OFF
AUTOINCERROR
ON or OFF
AUTOSAVE
ON or OFF
BELL, 1
cWAVFileName
BLOCKSIZE
nBlockSize
BROWSEIME
ON or OFF
CARRY
ON or OFF
CENTURY
ON or OFF
CENTURY, 1
nCentury
CENTURY, 2
ROLLOVER nYear
CENTURY, 3
System Regional Calendar setting
CLASSLIB
cClassLibName
CLOCK
ON or OFF
CLOCK, 1
nRow and nColumn
COLLATE
ON or OFF
COLOR OF SCHEME
cR, cG, cB
COLOR SET
cNameOfColorSet
COMPATIBLE
ON or OFF
COMPATIBLE, 1
PROMPT or NOPROMPT
CONFIRM
ON or OFF
CONSOLE
ON or OFF
COVERAGE
ON or OFF
COVERAGE, 1
FileName
CPCOMPILE
nCodePage
CPDIALOG
ON or OFF
CURRENCY
LEFT or RIGHT
CURRENCY, 1
cCurrencySymbol
CURSOR
ON or OFF
DATABASE
cDatabase
DATASESSION
nDataSession
DATE
AMERICAN, ANSI, BRITISH/FRENCH, GERMAN, ITALIAN, JAPAN, USA, MDY, DMY, or YMD
DATE, 1
Date Ordering:0 – MDY1 – DMY2 – YMD
DEBUG
ON or OFF
DEBUGOUT
cFileName
DECIMALS
nDecimals
DEFAULT
cDirectory
DELETED
ON or OFF
DELIMITERS
ON or OFF
DELIMITERS, 1
cDelimiters
DEVELOPMENT
ON or OFF
DEVICE
SCREEN, PRINTER, or FILE
DEVICE, 1
cFileName
ENGINEBEHAVIOR
nVersionNumber
ESCAPE
ON or OFF
EVENTLIST
comma delimited list of events
EVENTTRACKING
ON or OFF
EVENTTRACKING, 1
FileName
EXACT
ON or OFF
EXCLUSIVE
ON or OFF
FDOW
nDayofWeek
FIELDS
ON or OFF
FIELDS, 1
FieldName1, FieldName2, ...
FIELDS, 2
LOCAL or GLOBAL
FILTER
cFilterExpression
FIXED
ON or OFF
FULLPATH
ON or OFF
FWEEK
nWeekNumber
HEADINGS
ON or OFF
HELP
ON or OFF
HELP, 1
cFileName
HELP, 2
cCollectionURL
HELP, 3
SYSTEM
HOURS
12 or 24
INDEX
cIndexExpression
KEY
eExpression2, eExpression3
KEY, 1
eExpression2
KEY, 2
eExpression3
KEYCOMP
DOS or WINDOWS
LIBRARY
cNameOfLibrary
LOCK
ON or OFF
LOGERRORS
ON or OFF
MACKEY
cKey
MARGIN
nMargin
MEMOWIDTH
nWidth
MESSAGE
nRow
MESSAGE, 1
cMessageText
MOUSE
ON or OFF
MOUSE, 1
nSensitivity
MULTILOCKS
ON or OFF
NEAR
ON or OFF
NOCPTRANS
comma delimited list of fields
NOTIFY
ON or OFF
NOTIFY, 1
ON or OFF
NULL
ON or OFF
NULLDISPLAY
cDisplayString
ODOMETER
nNumberOfRecords
OLEOBJECT
ON or OFF
OPTIMIZE
ON or OFF
ORDER
TAG TagName OF CDXFileName, IDXFileName, or blank
PALETTE
ON or OFF
PATH
cPath
PDSETUP
cPrinterDriverName
POINT
cDecimalPtChar
PRINTER
ON or OFF
PRINTER, 1
FileName or PortName
PRINTER, 2
Default Windows printer name
PRINTER, 3
Default Visual FoxPro printer name(specified in the Visual FoxPro Print or Print Setup dialog boxes)
PROCEDURE
cPathAndName
READBORDER
ON or OFF
REFRESH
nSeconds1
REFRESH, 1
nseconds2
REPORTBEHAVIOR
nVersionNumber
REPROCESS
Current session setting
REPROCESS, 1
System session setting
REPROCESS, 2
Current session setting type
0 is returned if REPROCESS is set to attempts.
1 is returned if REPROCESS is set to seconds.
REPROCESS, 3
System session setting type
0 is returned if REPROCESS is set to attempts.
1 is returned if REPROCESS is set to seconds.
RESOURCE
ON or OFF
RESOURCE, 1
FileName
SAFETY
ON or OFF
SECONDS
ON or OFF
SEPARATOR
cSeparatorChar
SPACE
ON or OFF
SQLBUFFERING
ON or OFF
STATUS
ON or OFF
STATUS BAR
ON or OFF
STRICTDATE
ON or OFF
SYSFORMATS
ON or OFF
SYSMENU
ON, OFF, or AUTOMATIC
TABLEPROMPT
ON or OFF
TABLEVALIDATE
nLevel
TALK
ON or OFF
TALK, 1
WINDOW, NOWINDOW or WindowName
TEXTMERGE
ON or OFF
TEXTMERGE, 1
cLeftDelimiter and cRightDelimiter
TEXTMERGE, 2
cFileName
TEXTMERGE, 3
SHOW/NOSHOW
TEXTMERGE, 4
Evaluate source of TEXT ... ENDTEXT call and return TEXTMERGE nesting level.
TOPIC
cHelpTopicName | lExpression
TOPIC, 1
NContextID
UDFPARMS
VALUE or REFERENCE
UNIQUE
ON or OFF
Return Value
Character or Numeric data type. SET( ) returns the value of a SET command.
Remarks
SET( ) recognizes the 4-character abbreviation for all Visual FoxPro SET keywords, with the exception of HELPFILTER, which can be abbreviated to 5 characters. For example, you can use STAT and PRIN for SET STATUS and SET PRINTER, respectively.
The SET( ) function is identical to SYS(2001).
See Also
Reference
SYS(2001) - SET ... Command Status