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 |
---|---|
Directs screen or printer output created with the ?, ??, DISPLAY, or LIST commands to a text file. |
|
Determines how comparisons between strings of different lengths are made with the = operator in Visual FoxPro SQL commands. |
|
Specifies if ASSERT commands are evaluated or ignored. |
|
Specifies whether attempts to update values in a field using autoincrementing generate an error or fail silently and proceed. |
|
Determines whether Visual FoxPro flushes data buffers to disk when you exit a READ or return to the Command window. |
|
Turns the computer bell on or off and sets the bell attributes. |
|
Specifies how Visual FoxPro allocates disk space for the storage of memo fields. |
|
Specifies if the Input Method Editor is opened when you navigate to a text box in a Browse window. |
|
Determines whether Visual FoxPro carries data forward from the current record to a new record created with INSERT, APPEND, and BROWSE. |
|
Determines whether Microsoft Visual FoxPro displays the century portion of date expressions and how Visual FoxPro interprets dates that specify only 2 digit years. |
|
Opens a visual class library (.vcx) containing class definitions. |
|
Determines whether Visual FoxPro displays the system clock and specifies the clock location on the main Visual FoxPro window. |
|
Specifies a collation sequence for character fields in subsequent indexing and sorting operations. |
|
Specifies the colors of a color scheme or copies one color scheme to another color scheme. |
|
Loads a previously defined color set. |
|
Controls compatibility with Microsoft FoxBASE+ and other FoxPro languages. |
|
Specifies whether the user can exit a text box by typing past the last character in the text box. |
|
Enables or disables output to the main Visual FoxPro window or to the active user-defined window from within programs. |
|
Turns code coverage on or off, or specifies a text file to which code coverage information is directed. |
|
Specifies the code page for compiled programs. |
|
Specifies whether the Code Page dialog box is displayed when a table is opened. |
|
Defines the currency symbol and specifies its position in the display of numeric, currency, float, and double expressions. |
|
Determines whether the insertion point is displayed when Visual FoxPro waits for input. |
|
Specifies the current database. |
|
Activates the specified form's data session. |
|
Specifies the format for the display of Date and DateTime expressions. |
|
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. |
|
Directs debugging output to a file. |
|
Specifies the number of decimal places displayed in numeric expressions. |
|
Specifies the default drive and directory. |
|
Specifies whether Visual FoxPro processes records marked for deletion and whether they are available for use in other commands. |
|
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. |
|
Directs output from @В ...В SAY to the screen, a printer, or a file. |
|
Included for backward compatibility. |
|
Included for backward compatibility. |
|
Opens the Trace window for program debugging. Included for backward compatibility. |
|
Enables SQL data engine compatibility with Visual FoxPro 7.0, 8.0, or 9.0. |
|
Determines whether pressing the ESC key interrupts program and command execution. |
|
Specifies events to track in the Debug Output window or in a file specified with SET EVENTTRACKING. |
|
Turns event tracking on or off or specifies a text file to which event tracking information is directed. |
|
Specifies the rules Visual FoxPro uses when comparing two strings of different lengths. |
|
Specifies whether Visual FoxPro opens table files for exclusive or shared use on a network. |
|
Specifies the first day of the week. |
|
Specifies which fields in a table can be accessed. |
|
Specifies a condition that records in the current table must meet to be accessible. |
|
Specifies if the number of decimal places used in the display of numeric data is fixed. |
|
Specifies if CDX(В ), DBF(В ), MDX(В ), and NDX(В ) return the path in a file name. |
|
Assigns an expression (keyboard macro) to a function key or key combination. |
|
Specifies the requirements for the first week of the year. |
|
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. |
|
Enables or disables Microsoft Visual FoxPro online Help or specifies a Help file. |
|
Sets the system clock to a 12- or 24-hour time format. |
|
Opens one or more index files for use with the current table. |
|
Specifies access to a range of records based on their index keys. |
|
Controls Visual FoxPro keystroke navigation. |
|
Opens an external API (application programming interface) library file. |
|
Enables or disables automatic file locking in certain commands. |
|
Determines whether Visual FoxPro sends compilation error messages to a text file. |
|
Specifies a key or key combination that displays the Macro Key Definition dialog box. |
|
Sets the left printer margin and affects all output directed to the printer. |
|
Specifies a mark character for menu titles or menu items, or displays or clears the mark character. |
|
Specifies a delimiter for the display of date expressions. |
|
Specifies the displayed width of memo fields and character expressions. |
|
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. |
|
Determines whether you can lock multiple records using LOCK(В ) or RLOCK(В ). |
|
Determines where the record pointer is positioned after FIND or SEEK unsuccessfully searches for a record. |
|
Prevents translation to a different code page for selected fields in an open table. |
|
Enables or disables the display of certain system messages. |
|
Determines how null values are supported by the ALTER TABLE, CREATE TABLE and INSERT - SQL commands. |
|
Specifies the text displayed for null values. |
|
Specifies the reporting interval of the record counter for commands that process records. |
|
Specifies whether Visual FoxPro searches the OLE Registry when an object cannot be located. |
|
Enables or disables Rushmore Query Optimization. |
|
Designates a controlling index file or tag for a table. |
|
Specifies whether the Visual FoxPro default color palette is used. |
|
Specifies a path for file searches. |
|
Loads a printer driver setup or clears the current printer driver setup. |
|
Determines the decimal point character used in the display of numeric and currency expressions. |
|
Enables or disables output to the printer, or routes output to a file, port, or network printer. |
|
Opens a procedure file. |
|
Determines whether borders are placed around text boxes created with @В ...В GET. |
|
Determines whether and how often a Browse window is updated with changes made to records by other users on the network. |
|
Establishes a relationship between two open tables. |
|
Breaks an established relationship between the parent table in the currently selected work area, and a related child table. |
|
Specifies the kind of report engine processing Visual FoxPro uses when executing traditional REPORT FORM and LABEL commands. |
|
Specifies how many times and for how long Visual FoxPro attempts to lock a file or record after an unsuccessful locking attempt. |
|
Updates or specifies a resource file. |
|
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. |
|
Specifies whether seconds are displayed in the time portion of a DateTime value. |
|
Specifies the character used to separate each group of three digits to the left of the decimal point in displaying numeric and currency expressions. |
|
Creates a one-to-many relationship among tables. |
|
Enables or disables a menu, menu bar, menu title, or menu item for user-defined menus or the Microsoft Visual FoxPro system menu. |
|
Determines whether a space is displayed between fields or expressions when you use the ? or ?? command. |
|
Determines whether data in a SQL SELECT statement is based on buffered data or data written to disk. |
|
Displays or removes the character-based status bar. |
|
Displays or removes the graphical status bar. |
|
Opens the Trace window and suspends program execution for debugging. |
|
Specifies if ambiguous Date and DateTime constants generate errors. |
|
Specifies whether Visual FoxPro for Windows system settings are updated with the current Microsoft Windows system settings. |
|
Enables or disables the Visual FoxPro system menu bar during program execution, and allows you to reconfigure it. |
|
Enables or disables file open dialog from appearing when table cannot be located during execution of a data command such as SELECT - SQL Command. |
|
Specifies the level of table validation to perform. |
|
Determines whether Visual FoxPro displays command results. |
|
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. |
|
Specifies the text-merge delimiters. |
|
Specifies the Help topic or topics to open when you invoke the Visual FoxPro Help system. |
|
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. |
|
Enables or disables tracing between breakpoints in the Trace Window. |
|
Specifies the maximum number of characters that can be stored in the type-ahead buffer. |
|
Specifies if Microsoft Visual FoxPro passes parameters to a user-defined function (UDF) by value or by reference. |
|
Specifies whether records with duplicate index key values are maintained in an index file. |
|
Controls mapping of Character expressions to Varchar data types in result sets of queries and views. |
|
Opens or closes the Data Session window or restores the Visual FoxPro environment from a view file. |
|
Maps MS-DOS drive designators (A:, B:, C:, and so on) to volumes or folders in FoxPro for Macintosh. |
|
Included for backward compatibility. |