Commands that Scope to a Data Session

These commands affect only the data session in which they are issued.

Use	To
BEGIN TRANSACTION Command	Begin a transaction.
END TRANSACTION Command	End the current transaction and save any changes made to tables, table memo files, or index files included in a transaction.
ROLLBACK Command	Cancel any changes made during the current transaction.
SET ANSI Command	Specify whether to pad a shorter string or binary expression during comparison in SQL commands.
SET AUTOINCERROR Command	Specify whether attempts to update or insert values in a field with automatically incrementing values generate errors.
SET AUTOSAVE Command	Determine whether Visual FoxPro flushes data buffers to disk when you exit a READ or return to the Command window.
SET BLOCKSIZE Command	Specify how Visual FoxPro allocates disk space for the storage of memo fields.
SET CARRY Command	Determine whether Visual FoxPro carries data forward from the current record to a new record created with INSERT, APPEND, and BROWSE.
SET CENTURY Command	Display the century portion of date expressions and determine how to interpret dates that specify only 2 digit years.
SET COLLATE Command	Specify a collation sequence for character fields in subsequent indexing and sorting operations.
SET CONFIRM Command	Specify whether the user can exit a text box by typing past the last character in the text box.
SET CURRENCY Command	Define the currency symbol and specifies its position in the display of numeric, currency, float, and double expressions.
SET DATABASE Command	Specify the current database.
SET DATE Command	Specify the format for the display of Date and DateTime expressions.
SET DECIMALS Command	Specify the number of decimal places displayed in numeric expressions.
SET DELETED Command	Specify whether to process records marked for deletion and whether they are available for use with other commands.
SET EXACT Command	Specify rules to use when comparing two strings of different lengths.
SET EXCLUSIVE Command	Specify whether to open table files for exclusive or shared use on a network.
SET FIELDS Command	Specify which fields in a table can be accessed.
SET FIXED Command	Specify if the number of decimal places used in the display of numeric data is fixed.
SET HOURS Command	Set the system clock to a 12- or 24-hour time format.
SET LOCK Command	Enable or disable automatic file locking in certain commands.
SET MARK TO Command	Specify a delimiter for the display of date expressions.
SET MEMOWIDTH Command	Specify the displayed width of memo fields and character expressions.
SET MULTILOCKS Command	Determine whether you can lock multiple records using LOCK( ) or RLOCK( ).
SET NEAR Command	Determine where the record pointer is positioned after an unsuccessful FIND or SEEK operation.
SET NULL Command	Determine how null values are supported by the ALTER TABLE, CREATE TABLE and INSERT - SQL commands.
SET POINT Command	Determine the decimal point character used in the display of numeric and currency expressions.
SET REFRESH Command	Specify the update interval for a browse window, memo editing window, or local memory buffers changed by other users on the network.
SET REPROCESS Command	Specify how often and for how long Visual FoxPro attempts to lock a file or record after an unsuccessful locking attempt.
SET SAFETY Command	Display a dialog box before overwriting an existing file, or determine 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	Specify whether seconds are displayed in the time portion of a DateTime value.
SET SYSFORMATS Command	Specify whether Visual FoxPro for Windows system settings are updated with the current Microsoft Windows system settings.
SET TALK Command	Determine whether Visual FoxPro displays command results.
SET UNIQUE Command	Specify whether records with duplicate index key values are maintained in an index file.

See Also

Reference

Command Window (Visual FoxPro)

Table Designer (Visual FoxPro)

Other Resources

Shared Access to Data

Language Categories