SET Command 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
SET ALTERNATE Command	Directs screen or printer output created with the ?, ??, DISPLAY, or LIST commands to a text file.
SET ANSI Command	Determines how comparisons between strings of different lengths are made with the = operator in Visual FoxPro SQL commands.
SET ASSERTS Command	Specifies if ASSERT commands are evaluated or ignored.
SET AUTOINCERROR Command	Specifies whether attempts to update values in a field using autoincrementing generate an error or fail silently and proceed.
SET AUTOSAVE Command	Determines whether Visual FoxPro flushes data buffers to disk when you exit a READ or return to the Command window.
SET BELL Command	Turns the computer bell on or off and sets the bell attributes.
SET BLOCKSIZE Command	Specifies how Visual FoxPro allocates disk space for the storage of memo fields.
SET BROWSEIME Command	Specifies if the Input Method Editor is opened when you navigate to a text box in a Browse window.
SET CARRY Command	Determines whether Visual FoxPro carries data forward from the current record to a new record created with INSERT, APPEND, and BROWSE.
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.
SET CLASSLIB Command	Opens a visual class library (.vcx) containing class definitions.
SET CLOCK Command	Determines whether Visual FoxPro displays the system clock and specifies the clock location on the main Visual FoxPro window.
SET COLLATE Command	Specifies a collation sequence for character fields in subsequent indexing and sorting operations.
SET COLOR OF SCHEME Command	Specifies the colors of a color scheme or copies one color scheme to another color scheme.
SET COLOR SET Command	Loads a previously defined color set.
SET COMPATIBLE Command	Controls compatibility with Microsoft FoxBASE+ and other FoxPro languages.
SET CONFIRM Command	Specifies whether the user can exit a text box by typing past the last character in the text box.
SET CONSOLE Command	Enables or disables output to the main Visual FoxPro window or to the active user-defined window from within programs.
SET COVERAGE Command	Turns code coverage on or off, or specifies a text file to which code coverage information is directed.
SET CPCOMPILE Command	Specifies the code page for compiled programs.
SET CPDIALOG Command	Specifies whether the Code Page dialog box is displayed when a table is opened.
SET CURRENCY Command	Defines the currency symbol and specifies its position in the display of numeric, currency, float, and double expressions.
SET CURSOR Command	Determines whether the insertion point is displayed when Visual FoxPro waits for input.
SET DATABASE Command	Specifies the current database.
SET DATASESSION Command	Activates the specified form's data session.
SET DATE Command	Specifies the format for the display of Date and DateTime expressions.
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.
SET DEBUGOUT Command	Directs debugging output to a file.
SET DECIMALS Command	Specifies the number of decimal places displayed in numeric expressions.
SET DEFAULT Command	Specifies the default drive and directory.
SET DELETED Command	Specifies whether Visual FoxPro processes records marked for deletion and whether they are available for use in other commands.
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.
SET DEVICE Command	Directs output from @ ... SAY to the screen, a printer, or a file.
SET DISPLAY Command	Included for backward compatibility.
SET DOHISTORY Command	Included for backward compatibility.
SET ECHO Command	Opens the Trace window for program debugging. Included for backward compatibility.
SET ENGINEBEHAVIOR Command	Enables SQL data engine compatibility with Visual FoxPro 7.0, 8.0, or 9.0.
SET ESCAPE Command	Determines whether pressing the ESC key interrupts program and command execution.
SET EVENTLIST Command	Specifies events to track in the Debug Output window or in a file specified with SET EVENTTRACKING.
SET EVENTTRACKING Command	Turns event tracking on or off or specifies a text file to which event tracking information is directed.
SET EXACT Command	Specifies the rules Visual FoxPro uses when comparing two strings of different lengths.
SET EXCLUSIVE Command	Specifies whether Visual FoxPro opens table files for exclusive or shared use on a network.
SET FDOW Command	Specifies the first day of the week.
SET FIELDS Command	Specifies which fields in a table can be accessed.
SET FILTER Command	Specifies a condition that records in the current table must meet to be accessible.
SET FIXED Command	Specifies if the number of decimal places used in the display of numeric data is fixed.
SET FULLPATH Command	Specifies if CDX( ), DBF( ), MDX( ), and NDX( ) return the path in a file name.
SET FUNCTION Command	Assigns an expression (keyboard macro) to a function key or key combination.
SET FWEEK Command	Specifies the requirements for the first week of the year.
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.
SET HELP Command	Enables or disables Microsoft Visual FoxPro online Help or specifies a Help file.
SET HOURS Command	Sets the system clock to a 12- or 24-hour time format.
SET INDEX Command	Opens one or more index files for use with the current table.
SET KEY Command	Specifies access to a range of records based on their index keys.
SET KEYCOMP Command	Controls Visual FoxPro keystroke navigation.
SET LIBRARY Command	Opens an external API (application programming interface) library file.
SET LOCK Command	Enables or disables automatic file locking in certain commands.
SET LOGERRORS Command	Determines whether Visual FoxPro sends compilation error messages to a text file.
SET MACKEY Command	Specifies a key or key combination that displays the Macro Key Definition dialog box.
SET MARGIN Command	Sets the left printer margin and affects all output directed to the printer.
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.
SET MEMOWIDTH Command	Specifies the displayed width of memo fields and character expressions.
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.
SET MULTILOCKS Command	Determines whether you can lock multiple records using LOCK( ) or RLOCK( ).
SET NEAR Command	Determines where the record pointer is positioned after FIND or SEEK unsuccessfully searches for a record.
SET NOCPTRANS Command	Prevents translation to a different code page for selected fields in an open table.
SET NOTIFY Command	Enables or disables the display of certain system messages.
SET NULL Command	Determines how null values are supported by the ALTER TABLE, CREATE TABLE and INSERT - SQL commands.
SET NULLDISPLAY Command	Specifies the text displayed for null values.
SET ODOMETER Command	Specifies the reporting interval of the record counter for commands that process records.
SET OLEOBJECT Command	Specifies whether Visual FoxPro searches the OLE Registry when an object cannot be located.
SET OPTIMIZE Command	Enables or disables Rushmore Query Optimization.
SET ORDER Command	Designates a controlling index file or tag for a table.
SET PALETTE Command	Specifies whether the Visual FoxPro default color palette is used.
SET PATH Command	Specifies a path for file searches.
SET PDSETUP Command	Loads a printer driver setup or clears the current printer driver setup.
SET POINT Command	Determines the decimal point character used in the display of numeric and currency expressions.
SET PRINTER Command	Enables or disables output to the printer, or routes output to a file, port, or network printer.
SET PROCEDURE Command	Opens a procedure file.
SET READBORDER Command	Determines whether borders are placed around text boxes created with @ ... GET.
SET REFRESH Command	Determines whether and how often a Browse window is updated with changes made to records by other users on the network.
SET RELATION Command	Establishes a relationship between two open tables.
SET RELATION OFF Command	Breaks an established relationship between the parent table in the currently selected work area, and a related child table.
SET REPORTBEHAVIOR Command	Specifies the kind of report engine processing Visual FoxPro uses when executing traditional REPORT FORM and LABEL commands.
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.
SET RESOURCE Command	Updates or specifies a resource file.
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.
SET SECONDS Command	Specifies whether seconds are displayed in the time portion of a DateTime value.
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.
SET SKIP Command	Creates a one-to-many relationship among tables.
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.
SET SPACE Command	Determines whether a space is displayed between fields or expressions when you use the ? or ?? command.
SET SQLBUFFERING Command	Determines whether data in a SQL SELECT statement is based on buffered data or data written to disk.
SET STATUS Command	Displays or removes the character-based status bar.
SET STATUS BAR Command	Displays or removes the graphical status bar.
SET STEP Command	Opens the Trace window and suspends program execution for debugging.
SET STRICTDATE Command	Specifies if ambiguous Date and DateTime constants generate errors.
SET SYSFORMATS Command	Specifies whether Visual FoxPro for Windows system settings are updated with the current Microsoft Windows system settings.
SET SYSMENU Command	Enables or disables the Visual FoxPro system menu bar during program execution, and allows you to reconfigure it.
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.
SET TABLEVALIDATE Command	Specifies the level of table validation to perform.
SET TALK Command	Determines whether Visual FoxPro displays command results.
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 output.
SET TEXTMERGE DELIMITERS Command	Specifies the text-merge delimiters.
SET TOPIC Command	Specifies the Help topic or topics to open when you invoke the Visual FoxPro Help system.
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.
SET TRBETWEEN Command	Enables or disables tracing between breakpoints in the Trace Window.
SET TYPEAHEAD Command	Specifies the maximum number of characters that can be stored in the type-ahead buffer.
SET UDFPARMS Command	Specifies if Microsoft Visual FoxPro passes parameters to a user-defined function (UDF) by value or by reference.
SET UNIQUE Command	Specifies whether records with duplicate index key values are maintained in an index file.
SET VARCHARMAPPING Command	Controls mapping of Character expressions to Varchar data types in result sets of queries and views.
SET VIEW Command	Opens or closes the Data Session window or restores the Visual FoxPro environment from a view file.
SET VOLUME Command	Maps MS-DOS drive designators (A:, B:, C:, and so on) to volumes or folders in FoxPro for Macintosh.
SET WINDOW OF MEMO Command	Included for backward compatibility.

See Also

Reference

Commands that Scope to a Data Session

Other Resources

Commands (Visual FoxPro)