Commands that Scope to a Data Session

JavaScript Editor js editor     Web development 



Main Page

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



JavaScript Editor js editor     Web development