-------------------------------------------- FOXPRO SET COMMANDS (UNDOCUMENTED) June 2021 -------------------------------------------- CCB 1. THE SET COMMANDS (from dv_foxhelp9.chm): Visual FoxPro Advanced (10.0.0.0) Language Reference. SET Commands Overview The SET command performs different operations when used with various keywords. SET [ [cSetCommand] [ON | OFF] | TO [eSetting] ] Remarks When no arguments are passed, SET opens the Data Session window. The Data Session window provides an easy way to open tables, establish relations, or change different Microsoft Visual FoxPro settings. For more information, see Data Session Window. The following table lists other operations that the SET command performs. ------------------------------------------------------------------------------------------------------------------------------------------- | SET Command | Description and Default Setting | ------------------------------------------------------------------------------------------------------------------------------------------- | SET ALTERNATE Command | Directs screen or printer output created with the ?, ??, DISPLAY, or LIST commands to a text file. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET ANSI Command | Determines how comparisons between strings of different lengths are made with the = operator in | | | Visual FoxPro SQL commands. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET APLABOUT Command??? | Included for backward compatibility with FoxPro/Mac. | | | The setting is always "DISABLED". | ------------------------------------------------------------------------------------------------------------------------------------------- | SET ASSERTS Command | Specifies if ASSERT commands are evaluated or ignored. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET ATTRIBUTES Command??? | Included for backward compatibility. | | | The setting is always "N/W*,W+/BG*,N/N && W/W*,N/W*,W/W*,W+/BG*,N/W*". | ------------------------------------------------------------------------------------------------------------------------------------------- | SET AUTOINCERROR Command | Specifies whether attempts to update values in a field using autoincrementing generate an error or | | | fail silently and proceed. | | | The default setting is ON. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET AUTOSAVE Command | Determines whether Visual FoxPro flushes data buffers to disk when you exit a READ or return to the | | | Command window. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET BELL Command | Turns the computer bell on or off and sets the bell attributes. | | | The default setting is ON. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET BLINK Command??? | Included for backward compatibility. | | | Decide whether to flash or high-density display. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET BLOCKSIZE Command | Specifies how Visual FoxPro allocates disk space for the storage of memo fields. | | | The default setting is 64 (SET("BLOCKSIZE")=64). | | | SET BLOCKSIZE TO nBytes, | | | if nBytes=0, SET("BLOCKSIZE")=1, | | | if nBytes>=1 and nBytes<=32, SET("BLOCKSIZE")=nBytes*256, | | | if nBytes>=33 and nBytes<=32768, SET("BLOCKSIZE")=nBytes. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET BORDER Command??? | Included for backward compatibility. Use the BorderStyle Property instead. | | | For boxes created with @ ... TO, menus created with DEFINE POPUP, and windows created with DEFINE | | | WINDOW, this command defines a border for them. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET BROWSEIME Command | Specifies if the Input Method Editor is opened when you navigate to a text box in a Browse window. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET BROWSEIMECONTROL Command | Same as the SET BROWSEIME Command. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET BRSTATUS Command??? | Included for backward compatibility. Use the StatusBarText Property instead. | | | Control the display of the status bar in the browse window. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET CARRY Command | Determines whether Visual FoxPro carries data forward from the current record to a new record | | | created with INSERT, APPEND, and BROWSE. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET CATALOG Command??? | Included for backward compatibility with dBase IV. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET CENTURY Command | Determines whether Microsoft Visual FoxPro displays the century portion of date expressions and how | | | Visual FoxPro interprets dates that specify only 2 digit years. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET CLASSLIB Command | Opens a visual class library (.vcx) containing class definitions. | | | The default setting is an empty string. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET CLEAR Command??? | Included for backward compatibility. Use the Refresh Method instead. | | | Decide whether to clean up the main Visual FoxPro window after issuing the SET FORMAT command. | | | The default setting is ON. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET CLOCK Command | Determines whether Visual FoxPro displays the system clock and specifies the clock location on the | | | main Visual FoxPro window. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET COLLATE Command | Specifies a collation sequence for character fields in subsequent indexing and sorting operations. | | | The default setting is "MACHINE". | ------------------------------------------------------------------------------------------------------------------------------------------- | SET COLOR OF SCHEME Command | Specifies the colors of a color scheme or copies one color scheme to another color scheme. | | | The default setting is "N/W*,N/W*,W". | ------------------------------------------------------------------------------------------------------------------------------------------- | SET COLOR SET Command | Loads a previously defined color set. | | | The default setting is an empty string. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET COMPATIBLE Command | Controls compatibility with Microsoft FoxBASE+ and other FoxPro languages. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET CONFIRM Command | Specifies whether the user can exit a text box by typing past the last character in the text box. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET CONSOLE Command | Enables or disables output to the main Visual FoxPro window or to the active user-defined window | | | from within programs. | | | The default setting is ON. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET COVERAGE Command | Turns code coverage on or off, or specifies a text file to which code coverage information is | | | directed. | | | The default setting is an empty string. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET CPCOMPILE Command | Specifies the code page for compiled programs. | | | The default setting is the current operating system code page (CPCURRENT()). | ------------------------------------------------------------------------------------------------------------------------------------------- | SET CPDIALOG Command | Specifies whether the Code Page dialog box is displayed when a table is opened. | | | The default setting is ON. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET CURRENCY Command | Defines the currency symbol and specifies its position in the display of numeric, currency, float, | | | and double expressions. | | | The default setting is "LEFT". | ------------------------------------------------------------------------------------------------------------------------------------------- | SET CURSOR Command | Determines whether the insertion point is displayed when Visual FoxPro waits for input. | | | The default setting is ON. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET DATABASE Command | Specifies the current database. | | | The default setting is an empty string. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET DATASESSION Command | Activates the specified form's data session. | | | The default setting is data session 1 (the Global data session). | ------------------------------------------------------------------------------------------------------------------------------------------- | SET DATE Command | Specifies the format for the display of Date and DateTime expressions. | | | The default setting is "AMERICAN". | ------------------------------------------------------------------------------------------------------------------------------------------- | SET DBTRAP Command??? | Included for backward compatibility with dBase IV. | | | The setting is always ON. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET DEBUG Command | Included for backward compatibility. Makes the Debug and Trace windows either available or | | | unavailable from the Visual FoxPro menu system in versions prior to 5.0. | | | The default setting is ON. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET DEBUGOUT Command | Directs debugging output to a file. | | | The default setting is an empty string. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET DECIMALS Command | Specifies the number of decimal places displayed in numeric expressions. | | | The default setting is 2. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET DEFAULT Command | Specifies the default drive and directory. | | | The default setting is SYS(5)+SYS(2003). | ------------------------------------------------------------------------------------------------------------------------------------------- | SET DELETED Command | Specifies whether Visual FoxPro processes records marked for deletion and whether they are | | | available for use in other commands. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET DELIMITERS Command??? | Included for backward compatibility. Use the Format Property instead. | | | Specify whether to separate the text box. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET DESIGN Command??? | Included for backward compatibility with dBase IV. | | | The setting is always ON. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET DEVELOPMENT Command | Causes Visual FoxPro to compare the creation date and time of a program with those of its compiled | | | object file when the program is run. | | | The default setting is ON. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET DEVICE Command | Directs output from @ ... SAY to the screen, a printer, or a file. | | | The default setting is "SCREEN". | ------------------------------------------------------------------------------------------------------------------------------------------- | SET DIRECTORY Command??? | Same as the SET DEFAULT Command. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET DISPLAY Command | Included for backward compatibility. | | | The default setting is "VGA25". | ------------------------------------------------------------------------------------------------------------------------------------------- | SET DOHISTORY Command | Included for backward compatibility. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET ECHO Command | Opens the Trace window for program debugging. Included for backward compatibility. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET ENGINEBEHAVIOR Command | Enables SQL data engine compatibility with Visual FoxPro 7.0, 8.0, or 9.0. | | | The default setting is 90. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET ENCRYPTION Command??? | Included for backward compatibility. | | | The setting is always OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET ESCAPE Command | Determines whether pressing the ESC key interrupts program and command execution. | | | The default setting is ON. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET EVENTLIST Command | Specifies events to track in the Debug Output window or in a file specified with SET EVENTTRACKING. | | | The default setting is an empty string. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET EVENTTRACKING Command | Turns event tracking on or off or specifies a text file to which event tracking information is | | | directed. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET EXACT Command | Specifies the rules Visual FoxPro uses when comparing two strings of different lengths. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET EXCLUSIVE Command | Specifies whether Visual FoxPro opens table files for exclusive or shared use on a network. | | | The default setting is ON for the system data session and the global data session. | | | The default setting is OFF for a private data session. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET FDOW Command | Specifies the first day of the week. | | | The default setting is 1. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET FIELDS Command | Specifies which fields in a table can be accessed. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET FILTER Command | Specifies a condition that records in the current table must meet to be accessible. | | | The default setting is an empty string. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET FIXED Command | Specifies if the number of decimal places used in the display of numeric data is fixed. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET FORMAT Command??? | Included for backward compatibility. Use the Format Property instead. | | | Open the format file for APPEND, CHANGE, EDIT and INSERT. | | | The default setting is an empty string. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET FULLPATH Command | Specifies if CDX( ), DBF( ), MDX( ), and NDX( ) return the path in a file name. | | | The default setting is ON. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET FUNCTION Command | Assigns an expression (keyboard macro) to a function key or key combination. | | | The default setting is an empty string. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET FWEEK Command | Specifies the requirements for the first week of the year. | | | The default setting is 1. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET HEADINGS Command | Determines whether column headings are displayed for fields and whether file information is | | | included when TYPE is issued to display the contents of a file. | | | The default setting is ON. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET HELP Command | Enables or disables Microsoft Visual FoxPro online Help or specifies a Help file. | | | The default setting is ON. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET HELPFILTER Command??? | Included for backward compatibility. | | | Enables Visual FoxPro to display a subset of .DBF-style Help topics in the Help window. | | | The default setting is an empty string. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET HISTORY Command??? | Included for backward compatibility. | | | The default setting is ON. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET HOURS Command | Sets the system clock to a 12- or 24-hour time format. | | | The default setting is 12. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET IBLOCK Command??? | Included for backward compatibility with dBase IV. | | | The setting is always 0. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET INDEX Command | Opens one or more index files for use with the current table. | | | The default setting is an empty string. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET INSTRUCT Command??? | Included for backward compatibility with dBase IV. | | | The setting is always OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET INTENSITY Command??? | Included for backward compatibility. Use SET COLOR OF SCHEME instead. | | | Determine whether Visual FoxPro uses the enhanced screen color attribute to display the field. | | | The default setting is ON. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET KEY Command | Specifies access to a range of records based on their index keys. | | | The default setting is an empty string. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET KEYCOMP Command | Controls Visual FoxPro keystroke navigation. | | | The default setting is "WINDOWS". | ------------------------------------------------------------------------------------------------------------------------------------------- | SET LDCHECK Command??? | Included for backward compatibility with dBase IV. | | | The setting is always OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET LIBRARY Command | Opens an external API (application programming interface) library file. | | | The default setting is an empty string. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET LOCK Command | Enables or disables automatic file locking in certain commands. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET LOGERRORS Command | Determines whether Visual FoxPro sends compilation error messages to a text file. | | | The default setting is ON. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET MACDESKTOP Command??? | Included for backward compatibility with FoxPro/Mac. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET MACHELP Command??? | Included for backward compatibility with FoxPro/Mac. | | | The setting is always "DISABLED". | ------------------------------------------------------------------------------------------------------------------------------------------- | SET MACKEY Command | Specifies a key or key combination that displays the Macro Key Definition dialog box. | | | The default setting is an empty string. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET MARGIN Command | Sets the left printer margin and affects all output directed to the printer. | | | The default setting is 0. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET MARK OF Command | Specifies a mark character for menu titles or menu items, or displays or clears the mark character. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET MARK TO Command | Specifies a delimiter for the display of date expressions. | | | The default setting is "/". | ------------------------------------------------------------------------------------------------------------------------------------------- | SET MBLOCK Command??? | Specifies how Visual FoxPro allocates disk space for the storage of memo fields. | | | Included for backward compatibility with dBase IV. | | | The default setting is 1 (SET("MBLOCK")=1, SET("BLOCKSIZE")=64). | | | SET MBLOCK TO nBytes, | | | if nBytes>=1 and nBytes<=256, SET("BLOCKSIZE")=nBytes*64, | | | if nBytes>=257 and nBytes<=32768, SET("BLOCKSIZE")=nBytes. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET MEMOWIDTH Command | Specifies the displayed width of memo fields and character expressions. | | | The default setting is 50. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET MENU Command??? | Included for backward compatibility. | | | The default setting is ON. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET MESSAGE Command | Defines a message for display in the main Visual FoxPro window or in the graphical status bar, or | | | specifies the location of messages for user-defined menu bars and menu commands. | | | The default setting is an empty string. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET MOUSE Command??? | Included for backward compatibility. | | | Set whether the mouse can be used, and control the sensitivity of the mouse. | | | The default setting is ON. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET MULTILOCKS Command | Determines whether you can lock multiple records using LOCK( ) or RLOCK( ). | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET NEAR Command | Determines where the record pointer is positioned after FIND or SEEK unsuccessfully searches for a | | | record. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET NOCPTRANS Command | Prevents translation to a different code page for selected fields in an open table. | | | The default setting is an empty string. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET NOTIFY Command | Enables or disables the display of certain system messages. | | | The default setting is ON. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET NULL Command | Determines how null values are supported by the ALTER TABLE, CREATE TABLE and INSERT - SQL commands. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET NULLDISPLAY Command | Specifies the text displayed for null values. | | | The default setting is ".NULL.". | ------------------------------------------------------------------------------------------------------------------------------------------- | SET ODOMETER Command | Specifies the reporting interval of the record counter for commands that process records. | | | In VFP 9.0 and earlier versions, the default setting is 100 records. | | | In VFP Advanced 32-bit version, the default setting is 10000 records. | | | In VFP Advanced 64-bit version, the default setting is 10000 records. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET OLEOBJECT Command | Specifies whether Visual FoxPro searches the OLE Registry when an object cannot be located. | | | The default setting is ON. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET OLEOBJECTS Command | Same as the SET OLEOBJECT Command. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET OPTIMIZE Command | Enables or disables Rushmore Query Optimization. | | | The default setting is ON. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET ORDER Command | Designates a controlling index file or tag for a table. | | | The default setting is an empty string. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET PALETTE Command | Specifies whether the Visual FoxPro default color palette is used. | | | The default setting is ON. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET PATH Command | Specifies a path for file searches. | | | The default setting is an empty string. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET PAUSE Command??? | Included for backward compatibility. | | | The setting is always ON. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET PDSETUP Command | Loads a printer driver setup or clears the current printer driver setup. | | | The default setting is an empty string. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET POINT Command | Determines the decimal point character used in the display of numeric and currency expressions. | | | The default setting is ".". | ------------------------------------------------------------------------------------------------------------------------------------------- | SET PRECISION Command??? | Included for backward compatibility with dBase IV. | | | The setting is always 16. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET PRINTER Command | Enables or disables output to the printer, or routes output to a file, port, or network printer. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET PROCEDURE Command | Opens a procedure file. | | | The default setting is an empty string. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET READBORDER Command | Determines whether borders are placed around text boxes created with @ ... GET. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET REFRESH Command | Determines whether and how often a Browse window is updated with changes made to records by other | | | users on the network. | | | The default setting is 0. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET RELATION Command | Establishes a relationship between two open tables. | | | The default setting is an empty string. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET RELATION OFF Command | Breaks an established relationship between the parent table in the currently selected work area, | | | and a related child table. | | | The default setting is an empty string. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET REPORTBEHAVIOR Command | Specifies the kind of report engine processing Visual FoxPro uses when executing traditional REPORT | | | FORM and LABEL commands. | | | The default setting is 80. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET REPROCESS Command | Specifies how many times and for how long Visual FoxPro attempts to lock a file or record after an | | | unsuccessful locking attempt. | | | The default setting is 0. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET RESOURCE Command | Updates or specifies a resource file. | | | In VFP 9.0 and earlier versions, the default setting is ON. | | | In VFP Advanced 32-bit version IDE, the default setting is ON. | | | In VFP Advanced 32-bit version Runtime, the default setting is OFF. | | | In VFP Advanced 32-bit version Multi-threaded Runtime, the default setting is OFF. | | | In VFP Advanced 64-bit version IDE, the default setting is ON. | | | In VFP Advanced 64-bit version Runtime, the default setting is OFF. | | | In VFP Advanced 64-bit version Multi-threaded Runtime, the default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET SAFETY Command | Determines whether Visual FoxPro displays a dialog box before overwriting an existing file, or | | | whether table or field rules, default values, and error messages are evaluated when changes | | | are made in the Table Designer or with ALTER TABLE. | | | In VFP 9.0 and earlier versions, the default setting is ON. | | | In VFP Advanced 32-bit version and VFP Advanced 64-bit version, | | | the default setting is ON for the system data session and the global data session, | | | the default setting is OFF for a private data session. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET SCOREBOARD Command??? | Included for backward compatibility. | | | Specify where Visual FoxPro displays the state of keys such as Num Lock, Caps Lock, and Insert. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET SECONDS Command | Specifies whether seconds are displayed in the time portion of a DateTime value. | | | The default setting is ON. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET SEPARATOR Command | Specifies the character used to separate each group of three digits to the left of the decimal | | | point in displaying numeric and currency expressions. | | | The default setting is ",". | ------------------------------------------------------------------------------------------------------------------------------------------- | SET SHADOWS Command??? | Included for backward compatibility. | | | Put shadows on user-defined windows, system windows, menus, dialog boxes and warning messages. | | | The default setting is ON. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET SKIP Command | Creates a one-to-many relationship among tables. | | | The default setting is an empty string. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET SKIP OF Command | Enables or disables a menu, menu bar, menu title, or menu item for user-defined menus or the | | | Microsoft Visual FoxPro system menu. | | | The default setting is an empty string. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET SPACE Command | Determines whether a space is displayed between fields or expressions when you use the ? or ?? | | | command. | | | The default setting is ON. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET SQL Command??? | Included for backward compatibility with dBase IV. | | | The setting is always ON. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET SQLBUFFERING Command | Determines whether data in a SQL SELECT statement is based on buffered data or data written to disk. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET STATUS Command | Displays or removes the character-based status bar. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET STATUS BAR Command | Displays or removes the graphical status bar. | | | The default setting is ON. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET STEP Command | Opens the Trace window and suspends program execution for debugging. | | | The default setting is ON. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET STICKY Command??? | Included for backward compatibility. | | | Specifies that the menu remains pulled down until a menu item is selected, the Esc key is pressed, | | | or the mouse is clicked outside the menu area. | | | The default setting is ON. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET STRICTDATE Command | Specifies if ambiguous Date and DateTime constants generate errors. | | | The default setting is 1. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET SYSFORMATS Command | Specifies whether Visual FoxPro for Windows system settings are updated with the current Microsoft | | | Windows system settings. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET SYSMENU Command | Enables or disables the Visual FoxPro system menu bar during program execution, and allows you to | | | reconfigure it. | | | The default setting is "AUTOMATIC". | ------------------------------------------------------------------------------------------------------------------------------------------- | SET SYSMENUS Command | Same as the SET SYSMENU Command. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET TABLEPROMPT Command | Enables or disables file open dialog from appearing when table cannot be located during execution | | | of a data command such as SELECT - SQL Command. | | | The default setting is ON. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET TABLEVALIDATE Command | Specifies the level of table validation to perform. | | | The default setting is 3. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET TALK Command | Determines whether Visual FoxPro displays command results. | | | In VFP 9.0 and earlier versions, the default setting is ON. | | | In VFP Advanced 32-bit version and VFP Advanced 64-bit version, | | | the default setting is ON for the system data session and the global data session, | | | the default setting is OFF for a private data session. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET TEXTMERGE Command | Enables or disables the evaluation of fields, variables, array elements, functions, or expressions | | | that are surrounded by text-merge delimiters, and lets you specify text-merge | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET TEXTMERGE DELIMITERS Command | Specifies the text-merge delimiters. | | | The default setting is "<<>>". | ------------------------------------------------------------------------------------------------------------------------------------------- | SET TITLE Command??? | Included for backward compatibility. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET TITLES Command??? | Same as the SET TITLE Command. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET TOPIC Command | Specifies the Help topic or topics to open when you invoke the Visual FoxPro Help system. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET TOPIC ID Command | Specifies the Help topic to display when you invoke the Visual FoxPro Help system. The Help topic | | | is based on the topic's context ID. | | | The default setting is 0. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET TRAP Command??? | Included for backward compatibility with dBase IV. | | | The setting is always ON. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET TRBETWEEN Command | Enables or disables tracing between breakpoints in the Trace Window. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET TYPEAHEAD Command | Specifies the maximum number of characters that can be stored in the type-ahead buffer. | | | The default setting is 20. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET UDFPARMS Command | Specifies if Microsoft Visual FoxPro passes parameters to a user-defined function (UDF) by value or | | | by reference. | | | The default setting is "VALUE". | ------------------------------------------------------------------------------------------------------------------------------------------- | SET UNIQUE Command | Specifies whether records with duplicate index key values are maintained in an index file. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET VARCHARMAPPING Command | Controls mapping of Character expressions to Varchar data types in result sets of queries and views. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET VIEW Command | Opens or closes the Data Session window or restores the Visual FoxPro environment from a view file. | | | The default setting is OFF. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET VOLUME Command | Maps MS-DOS drive designators (A:, B:, C:, and so on) to volumes or folders in FoxPro for Macintosh. | | | The default setting is an empty string. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET WINDOW OF MEMO Command | Included for backward compatibility. | | | The default setting is an empty string. | ------------------------------------------------------------------------------------------------------------------------------------------- | SET XCMDFILE Command??? | Included for backward compatibility with FoxPro/Mac. | | | The default setting is an empty string. | ------------------------------------------------------------------------------------------------------------------------------------------- 2. REFERENCE WEBSITES: 1, baiyujia.com: http://www.baiyujia.com http://www.baiyujia.com/vfpdocuments/f_vfp9fix11.asp http://www.baiyujia.com/vfpdocuments/f_vfp9fix22.asp http://www.baiyujia.com/vfpdocuments/f_vfp9fix174.asp 2, github.io: https://hackfox.github.io/section4/s4g393.html https://hackfox.github.io/section4/s4g689.html https://hackfox.github.io/section4/s4g896.html 3, lafox.org: http://lafox.org/newsletter/archives/2000/July2000.htm http://lafox.org/files/undocumented.rtf 4, microsoft.com: https://docs.microsoft.com/en-us/sql/odbc/microsoft/unsupported-visual-foxpro-commands-and-functions-visual-foxpro-odbc-driver 3. OTHER: For reference only, there is no guarantees. Any questions or suggestions, please send me an email at ccb2000@163.com. |