Introduction
There have been a significant number of changes to the FoxPro command set since FoxPro 2.6. This Appendix details those changes.
To read about | See |
Modifying your FoxPro 2.x code with new Visual FoxPro functionality | Updating FoxPro 2.x Commands and Functions for Visual FoxPro, page D-2 |
New Visual FoxPro commands, enhanced FoxPro 2.x commands | FoxPro 2.x and Visual FoxPro Commands, page D-8 |
Many of Visual FoxPros language elements are included only for backward compatibility with FoxPro 2.x. Instead of using these commands, you should replace them with the command, function or technique listed in the second column.
FoxPro 2.x Command or Function | Replaced by |
@ ... BOX command | Shape control |
@ ... EDIT - Edit Boxes command | Editbox control |
@ ... GET - Check Boxes command | CheckBox control |
@ ... GET - Combo Boxes command | ComboBox control |
@ ... GET - Command Buttons command | CommandButton control |
@ ... GET - List Boxes command | ListBox control |
@ ... GET - Option Buttons command | OptionGroup control |
@ ... GET - Spinners command | Spinner control |
@ ... GET - Text Boxes command | TextBox control |
@ ... GET - Transparent Buttons command | CommandButton control |
@ ... GET DEFAULT clause | Default property (in database container) |
@ ... GET MESSAGE cMessageText | StatusBarText property |
@ ... MENU command | Menu Designer |
@ ... PROMPT command | Menu Designer |
@ ... SAY | Label control, TextBox control |
@ ... SAY - Pictures & OLE Objects command | Image, OLE Bound and OLE Container Controls |
@ ... SAY FUNCTION, any @ ... GET FUNCTION |
Format property |
@ ... SAY PICTURE | Image control, OLE Bound control |
@ ... TO command | Shape control |
_ALIGNMENT System Memory Variable | Report Designer |
_ASSIST System Memory Variable | No Equivalent |
_BOX System Memory Variable | Report Designer |
_CUROBJ System Memory Variable | ActiveControl Form property |
_FOXDOC System Memory Variable | Documenting Wizard |
_GENGRAPH System Memory Variable | Graph Wizard |
_GENPD System Memory Variable | TO FILE ASCII argument in REPORT |
_GENSCRN System Memory Variable | Form Designer |
_GENXTAB System Memory Variable | Cross-Tab Wizard |
_INDENT System Memory Variable | Report Designer |
_LMARGIN System Memory Variable | Report Designer |
_PADVANCE System Memory Variable | Report Designer |
_PBPAGE System Memory Variable | Report Designer |
_PCOLNO System Memory Variable | Report Designer |
_PCOPIES System Memory Variable | Report Designer |
_PDRIVER System Memory Variable | TO FILE ASCII argument in REPORT |
_PDSETUP System Memory Variable | TO FILE ASCII argument in REPORT |
_PECODE System Memory Variable | Report Designer |
_PEJECT System Memory Variable | Report Designer |
_PEPAGE System Memory Variable | Report Designer |
_PLENGTH System Memory Variable | Report Designer |
_PLINENO System Memory Variable | Report Designer |
_PLOFFSET System Memory Variable | Report Designer |
_PPITCH System Memory Variable | Report Designer |
_PQUALITY System Memory Variable | Report Designer |
_PSCODE System Memory Variable | Report Designer |
_PSPACING System Memory Variable | Report Designer |
_PWAIT System Memory Variable | Report Designer |
_RMARGIN System Memory Variable | Report Designer |
_STARTUP System Memory Variable | DO command |
_TABS System Memory Variable | Report Designer |
_TRANSPORT System Memory Variable | Visual FoxPro Converter |
_WRAP System Memory Variable | Report Designer |
ACCEPT command | TextBox control |
ANSITOOEM( ) function | GETCP( ) function |
ASSIST command | No Equivalent |
CALL command | SET LIBRARY command |
CLEAR READ command | CLEAR EVENTS command |
COL( ) function | CurrentX property |
COLOR | ColorSource, BackColor and ForeColor properties |
COLOR SCHEME | ForeColor, BackColor, and ColorScheme properties |
CREATE SCREEN - Quick Screen command | CREATE FORM Quick Form command |
CREATE SCREEN command | CREATE FORM command |
Date data type | Date data type and DateTime data type |
DBCONNECT | SQLCONNECT( ) function |
DBEXEC | SQLEXEC( ) function |
DEACTIVATE WINDOW | Deactivate event |
DEFINE BOX command | Report Designer |
DEFINE WINDOW CLOSE | Closable property |
DEFINE WINDOW FLOAT | Movable property |
DEFINE WINDOW HALFHEIGHT | HalfHeightCaption property |
DEFINE WINDOW ICON FILE | Icon property |
EMPTY( ), BLANK( ) to check for non-existent data | ISNULL( ) function to check for null values representing unknown or non-existent data |
ENABLE, DISABLE clauses | Enabled property |
FIND command | SEEK command |
Font (Text Menu) | FontName property |
Font size (Font dialog) | FontSize property |
Font style bold (Font dialog) | FontBold property |
Font style italic (Font dialog) | FontItalic property |
Height | Height property |
Horizontal position (Screen Layout dialog) | Left property |
INPUT command | TextBox control |
INSERT command | APPEND or INSERT SQL Commands |
JOIN command | SELECT SQL command |
LOAD command | SET LIBRARY command |
MDOWN( ) function | Click, MouseDown, MouseUp and RightClick Events |
MENU command | Menu Designer |
MENU TO command | Menu Designer |
MODIFY SCREEN command | MODIFY FORM command |
MODIFY STRUCTURE | Table Designer |
MOVE WINDOW CENTER | AutoCenter property |
Numeric data type | Numeric, Integer, Double, and Currency data types |
OBJNUM( ) function | TabIndex property |
OBJVAR( ) function | Name property |
OEMTOANSI( ) function | GETCP( ) function |
ON KEY command | See ON KEY LABEL |
ON KEY = command | See ON KEY LABEL |
ON KEY LABEL command | KeyPress event, KeyPreview property |
ON READERROR command | Error Event |
PICTURE clause | InputMask property |
RDLEVEL( ) function | No Equivalent |
READ ACTIVATE | ReadActivate event |
READ command | No Equivalent |
READ CYCLE | ReadCycle property* |
READ DEACTIVATE | ReadDeactivate event* |
READ LOCK | ReadLock property* |
READ MENU command | Menu Designer |
READ NOMOUSE | ReadMouse property* |
READ SAVE | ReadSave property* |
READ SHOW | ReadShow event* |
READ TIMEOUT | ReadTimeout property* |
READ VALID | ReadValid event* |
READ WHEN | ReadWhen event* |
READKEY( ) function | No equivalent |
ROW( ) function | CurrentY property |
Screen Name | Name property |
SET BORDER | BorderStyle property |
SET BORDER command | BorderStyle property |
SET BRSTATUS command | StatusBarText property |
SET CLEAR command | Refresh Method |
SET COLOR OF command | SET COLOR OF SCHEME command |
SET COLOR TO command | SET COLOR OF SCHEME command |
SET DELIMITERS command | Format property |
SET DOHISTORY command | Trace Window |
SET FORMAT command | Format property |
SET INTENSITY command | SET COLOR OF SCHEME command |
SET NOCPTRANS | Character (Binary) and Memo (Binary) field types |
SET WINDOW OF MEMO command | TextBox control |
SHOW GET command | Refresh method |
SHOW GET, SHOW GETS | Refresh method |
SHOW OBJECT command | Refresh method |
Size (Screen Layout dialog) | Height and Width properties |
Style (Font dialog) | FontBold, FontItalic, FontUnderline, FontShadow, FontOutline, FontStrikeThru properties |
SYS(15) - Character Translation | SET COLLATE command |
SYS(18) - Current control | ActiveControl property |
SYS(20) - Transform German Text | SET COLLATE command |
SYS(2016) - SHOW GETS WINDOW Name | No equivalent |
SYS(2017) - Display Startup Screen | No equivalent |
Terminate on selection (Screen Builder) | TerminateRead property |
Title (Screen Builder) | Caption property |
UPDATE command | UPDATE SQL command |
UPDATED( ) function | InteractiveChange or ProgrammaticChange Events |
Valid (Screen Builder) | Click, DblClick, LostFocus, or Valid events |
Valid Error | ErrorMessage event |
VARREAD( ) function | ControlSource or Name Properties |
Vertical position (Screen Layout dialog) | Top property |
When (Screen Builder) | GotFocus or When event |
Width (Screen Builder) | Width property |
WREAD( ) function | No equivalent |
The following is a list of all the commands available in FoxPro 2.6, Visual FoxPro 3.0b and Visual FoxPro 5.0. You will find listings of all the SET commands on page D-31, SYS functions on page D-35, and System Variables on page D-38.
Use these listings to determine if a bug in your code is caused by the addition of new keywords or a change in functionality.
Legend:
X Valid command
M Behavior modified from previous version
* Command included for backward compatibility and should not be used with marked version of FoxPro
Language Element | 2.6 | 3.0 | 5.0 | Comments |
#DEFINE ... #UNDEF | X | X | X | |
#IF ... #ENDIF | X | X | X | |
#IFDEF | #IFNDEF ... #ENDIF | X | X | ||
#INCLUDE | X | X | ||
#REGION | X | X | X | |
* | X | X | X | |
&& | X | X | X | |
$ | X | X | X | |
% | X | X | X | |
& | X | X | X | |
:: Scope Resolution Operator | X | X | ||
? | ?? | X | X | X | |
??? | X | X | X | |
@ ... BOX | X | *M | * | Character expression is ignored |
@ ... CLASS | *X | *X | Allows you to create objects that work with READ | |
@ ... CLEAR | X | * | * | |
@ ... EDIT Text Edit Regions | X | * | * | |
@ ... FILL | X | * | * | |
@ ... GET | X | * | * | |
@ ... GET Check Boxes | X | * | * | |
@ ... GET Invisible Buttons | X | * | * | |
@ ... GET Lists | X | * | * | |
@ ... GET Popups | X | * | * | |
@ ... GET Push Buttons | X | * | * | |
@ ... GET Radio Buttons | X | * | * | |
@ ... GET Spinners | X | * | * | |
@ ... MENU | X | * | * | |
@ ... PROMPT | X | * | * | |
@ ... SAY | X | * | * | |
@ ... SAY BMPs & OLE Objects | X | * | * | |
@ ... SCROLL | X | * | * | |
@ ... TO | X | * | * | |
\ | \\ | X | X | X | |
= | X | X | X | |
ABS( ) | X | X | X | |
ACCEPT | * | * | * | |
ACLASS( ) | X | X | ||
ACOPY( ) | X | X | X | |
ACOS( ) | X | X | X | |
ACTIVATE MENU | X | X | X | |
ACTIVATE POPUP | X | X | X | |
ACTIVATE SCREEN | X | X | X | |
ACTIVATE WINDOW | X | X | X | |
ADATABASES( ) | X | X | ||
ADBOBJECTS( ) | X | X | ||
ADD CLASS | X | X | ||
ADD TABLE | X | X | ||
ADEL( ) | X | X | X | |
ADIR( ) | X | X | X | |
AELEMENT( ) | X | X | X | |
AERROR( ) | X | X | ||
AFIELDS( ) | X | M | M |
4 columns in 2.6, 11 columns in 3.0b, 16 columns in 5.0 |
AFONT( ) | X | X | X | |
AINS( ) | X | X | X | |
AINSTANCE( ) | X | X | ||
ALEN( ) | X | X | X | |
ALIAS( ) | X | X | X | |
ALLTRIM( ) | X | X | X | |
ALTER TABLE - SQL | X | X | ||
AMEMBERS( ) | X | X | ||
ANSITOOEM( ) | X | * | * | |
APPEND | X | M | X | 3.0 - IN and NOMENU clauses |
APPEND FROM | X | M | M |
3.0 XL5 and AS codepage clauses 5.0 CHARACTER clause |
APPEND GENERAL | X | M | X | 3.0 DATA clause |
APPEND MEMO | X | M | X | 3.0 AS clause |
APPEND PROCEDURES | X | X | ||
APRINTERS( ) | X | X | ||
ASC( ) | X | X | X | |
ASCAN( ) | X | X | X | |
ASELOBJ( ) | X | X | ||
ASIN( ) | X | X | X | |
ASORT( ) | X | X | X | |
ASSERT | X | |||
ASSIST | X | X | X | |
ASUBSCRIPT( ) | X | X | X | |
AT( ) | X | X | X | |
AT_C( ) | X | X | ||
ATAN( ) | X | X | X | |
ATC( ) | X | X | X | |
ATCC( ) | X | X | ||
ATCLINE( ) | X | X | X | |
ATLINE( ) | X | X | X | |
ATN2( ) | X | X | X | |
AUSED( ) | X | X | ||
AVERAGE | X | X | X | |
BAR( ) | X | X | X | |
BARCOUNT( ) | X | X | X | |
BARPROMPT( ) | X | X | X | |
BEGIN TRANSACTION | X | X | ||
BETWEEN( ) | X | X | X | |
BINTOC( ) | X | |||
BITAND( ) | X | X | ||
BITCLEAR( ) | X | X | ||
BITLSHIFT( ) | X | X | ||
BITNOT( ) | X | X | ||
BITOR( ) | X | X | ||
BITRSHIFT( ) | X | X | ||
BITSET( ) | X | X | ||
BITTEST( ) | X | X | ||
BITXOR( ) | X | X | ||
BLANK | X | X | X | |
BOF( ) | X | X | X | |
BROWSE | X | M | X | 3.0 NAME clause |
BUILD APP | X | X | M | 5.0 RECOMPILE option |
BUILD DLL | X | |||
BUILD EXE | X | X | M | 5.0 RECOMPILE option |
BUILD PROJECT | X | X | X | |
CALCULATE | X | X | X | |
CALL | X | X | X | |
CANCEL | X | X | X | |
CANDIDATE( ) | X | X | ||
CAPSLOCK( ) | X | X | X | |
CD | CHDIR | X | X | ||
CDOW( ) | X | M | X | support for DateTime data type |
CDX( ) | X | X | X | |
CEILING( ) | X | X | X | |
CHANGE | X | X | X | |
CHR( ) | X | X | X | |
CHRSAW( ) | X | X | X | |
CHRTRAN( ) | X | X | X | |
CHRTRANC( ) | X | X | ||
CLEAR | X | X | X | |
CLEAR ALL | X | X | X | |
CLEAR CLASS | X | X | ||
CLEAR CLASSLIB | X | X | ||
CLEAR DLLS | X | X | ||
CLEAR EVENTS | X | X | ||
CLEAR RESOURCES | X | |||
CLOSE ALL | X | X | X | |
CLOSE DATABASES (ALL) | X | M | X | 3.0 Closes Database container(s) as well as tables, indexes |
CLOSE DEBUGGER | X | |||
CLOSE MEMO | X | X | X | |
CLOSE TABLES (ALL) | X | X | 3.0 only closes tables, indexes, not databases | |
CMONTH( ) | X | X | X | |
CNTBAR( ) | X | X | X | |
CNTPAD( ) | X | X | X | |
COL( ) | X | X | X | |
COMPILE | X | M | X | 3.0 AS nCodePage clause |
COMPILE CLASS | X | |||
COMPILE DATABASE | X | X | ||
COMPILE FORM | X | X | ||
COMPOBJ( ) | X | X | ||
CONTINUE | X | X | X | |
COPY FILE | X | X | X | |
COPY INDEXES | X | X | X | |
COPY MEMO | X | M | X | 3.0 AS nCodePage clause |
COPY PROCEDURES | X | X | ||
COPY STRUCTURE | X | X | X | |
COPY STRUCTURE EXTENDED | X | X | X | |
COPY TAG | X | X | X | |
COPY TO | X | M | M |
3.0 FOX2X, XL5 and AS nCodePage clauses 5.0 CHARACTER clause |
COPY TO ARRAY | X | X | X | |
COS( ) | X | X | X | |
COUNT | X | X | X | |
CPCONVERT( ) | X | X | X | |
CPCURRENT( ) | X | X | X | |
CPDBF( ) | X | X | X | |
CREATE | X | X | X | |
CREATE CLASS | X | X | ||
CREATE CLASSLIB | X | X | ||
CREATE COLOR SET | X | X | X | |
CREATE CONNECTION | X | X | ||
CREATE CURSOR - SQL | X | M | X | 3.0 NULL|NO NULL, CHECK, ERROR, DEFAULT, UNIQUE, and NOCPTRANS clauses |
CREATE DATABASE | X | X | ||
CREATE FORM | X | X | ||
CREATE FROM | X | X | M | 5.0 DATABASE and NAME clauses |
CREATE LABEL | X | X | X | |
CREATE MENU | X | X | X | |
CREATE PROJECT | X | X | X | |
CREATE QUERY | X | X | X | |
CREATE REPORT | X | X | X | |
CREATE REPORT - Quick Report | X | X | X | |
CREATE SCREEN | X | X | X | |
CREATE SCREEN - Quick Screen | X | X | X | |
CREATE SQL VIEW | X | X | ||
CREATE TABLE - SQL | X | M | X |
3.0 New clauses to support database container features Warning: this command creates tables that are not compatible with FoxPro 2.x! |
CREATE TRIGGER | X | X | ||
CREATE VIEW | X | X | X | Easily confused with the creation of a SQL View |
CREATEBINARY( ) | X | |||
CREATEOBJECT( ) | X | X | ||
CREATEOFFLINE( ) | X | |||
CTOBIN( ) | X | |||
CTOD( ) | X | X | X | |
CTOT( ) | X | X | ||
CURDIR( ) | X | X | X | |
CURSORGETPROP( ) | X | X | ||
CURSORSETPROP( ) | X | X | ||
CURVAL( ) | X | X | ||
DATE( ) | X | X | X | |
DATETIME( ) | X | X | ||
DAY( ) | X | X | X | |
DBC( ) | X | X | ||
DBF( ) | X | X | X | |
DBGETPROP( ) | X | X | ||
DBSETPROP( ) | X | X | ||
DBUSED( ) | X | X | ||
DDE | X | X | X | |
DDEAbortTrans( ) | X | X | X | |
DDEAdvise( ) | X | X | X | |
DDEEnabled( ) | X | X | X | |
DDEExecute( ) | X | X | X | |
DDEInitiate( ) | X | X | X | |
DDELastError( ) | X | X | X | |
DDEPoke( ) | X | X | X | |
DDERequest( ) | X | X | X | |
DDESetOption( ) | X | X | X | |
DDESetService( ) | X | X | X | |
DDESetTopic( ) | X | X | X | |
DDETerminate( ) | X | X | X | |
DEACTIVATE MENU | X | X | X | |
DEACTIVATE POPUP | X | X | X | |
DEACTIVATE WINDOW | X | X | X | |
DEBUG | X | |||
DEBUGOUT | X | |||
DECLARE | X | X | X | |
DECLARE - DLL | X | X | ||
DEFINE BAR | X | M | X | 3.0 - FONT and STYLE clauses |
DEFINE BOX | X | X | X | |
DEFINE CLASS | X | X | ||
DEFINE MENU | X | M | X | 3.0 FONT and STYLE clauses |
DEFINE PAD | X | M | X | 3.0 NEGOTIATE, FONT and STYLE clauses |
DEFINE POPUP | X | M | X | 3.0 FONT and STYLE clauses |
DEFINE WINDOW | X | M | X | 3.0 NAME clause |
DELETE | X | M | X | 3.0 IN clause |
DELETE - SQL | X | X | ||
DELETE CONNECTION | X | X | ||
DELETE DATABASE | X | X | ||
DELETE FILE | X | X | X | |
DELETE TAG | X | X | X | |
DELETE TRIGGER | X | X | ||
DELETE VIEW | X | X | ||
DELETED( ) | X | X | X | |
DESCENDING( ) | X | X | X | |
DIFFERENCE( ) | X | X | X | |
DIMENSION | X | X | X | |
DIRECTORY | X | X | X | |
DIRECTORY( ) | X | |||
DISKSPACE( ) | X | X | M | 5.0 Supports optional volume name |
DISPLAY | X | X | X | |
DISPLAY CONNECTIONS | X | X | ||
DISPLAY DATABASE | X | X | ||
DISPLAY DLLS | X | X | ||
DISPLAY FILES | X | X | X | |
DISPLAY MEMORY | X | X | X | |
DISPLAY OBJECTS | X | X | ||
DISPLAY PROCEDURES | X | X | ||
DISPLAY STATUS | X | X | X | |
DISPLAY STRUCTURE | X | X | X | |
DISPLAY TABLES | X | X | ||
DISPLAY VIEWS | X | X | ||
DMY( ) | X | X | X | |
DO | X | X | X | |
DO CASE ... ENDCASE | X | X | X | |
DO FORM | X | X | ||
DO WHILE ... ENDDO | X | X | X | |
DODEFAULT( ) | X | |||
DOEVENTS | X | |||
DOW( ) | X | M | X | 3.0 nFirstDayOfWeek parameter |
DROP TABLE | X | |||
DROP VIEW | X | |||
DROPOFFLINE( ) | X | |||
DTOC( ) | X | X | X | |
DTOR( ) | X | X | X | |
DTOS( ) | X | X | X | |
DTOT( ) | X | X | ||
EDIT | X | M | X | 3.0 NAME clause |
EJECT | X | X | X | |
EJECT PAGE | X | X | X | |
EMPTY( ) | X | X | X | |
END TRANSACTION | X | X | ||
EOF( ) | X | X | X | |
ERASE | X | X | X | |
ERROR | X | X | ||
ERROR( ) | X | X | X | |
EVALUATE( ) | X | X | X | |
EXIT | X | X | X | |
EXP( ) | X | X | X | |
EXPORT | X | M | X | 3.0 XL5 and AS nCodePage clauses |
EXTERNAL | X | M | X | 3.0 CLASS, FILE, FORM, QUERY, TABLE clauses |
FCHSIZE( ) | X | X | X | |
FCLOSE( ) | X | X | X | |
FCOUNT( ) | X | X | X | |
FCREATE( ) | X | X | X | |
FDATE( ) | X | X | X | |
FEOF( ) | X | X | X | |
FERROR( ) | X | X | X | |
FFLUSH( ) | X | X | X | |
FGETS( ) | X | X | X | |
FIELD( ) | X | X | X | |
FILE( ) | X | X | X | |
FILER | X | X | X | |
FILTER( ) | X | X | X | |
FIND | X | X | X | |
FKLABEL( ) | X | X | X | |
FKMAX( ) | X | X | X | |
FLDLIST( ) | X | X | X | |
FLOCK( ) | X | X | X | |
FLOOR( ) | X | X | X | |
FLUSH | X | X | X | |
FONTMETRIC( ) | X | X | X | |
FOPEN( ) | X | X | X | |
FOR ... ENDFOR | X | X | X | |
FOR EACH ENDFOR | X | |||
FOR( ) | X | X | X | |
FOUND( ) | X | X | X | |
FPUTS( ) | X | X | X | |
FREAD( ) | X | X | X | |
FREE TABLE | X | X | ||
FSEEK( ) | X | X | X | |
FSIZE( ) | X | M | X | 3.0 cFileName parameter |
FTIME( ) | X | X | X | |
FULLPATH( ) | X | X | X | |
FUNCTION | X | X | X | |
FV( ) | X | X | X | |
FWRITE( ) | X | X | X | |
GATHER | X | M | X | 3.0 NAME clause |
GETBAR( ) | X | X | X | |
GETCOLOR( ) | X | X | ||
GETCP( ) | X | X | ||
GETDIR( ) | X | X | X | |
GETENV( ) | X | X | X | |
GETEXPR | X | X | X | |
GETFILE( ) | X | X | X | |
GETFLDSTATE( ) | X | X | ||
GETFONT( ) | X | X | X | |
GETNEXTMODIFIED( ) | X | X | ||
GETOBJECT( ) | X | X | ||
GETPAD( ) | X | X | X | |
GETPEM( ) | X | X | ||
GETPICT( ) | X | X | ||
GETPRINTER( ) | X | X | ||
GO/GOTO | X | X | X | |
GOMONTH( ) | X | X | X | |
HEADER( ) | X | X | X | |
HELP | X | M | X | 3.0 ID clause |
HIDE MENU | X | X | X | |
HIDE POPUP | X | X | X | |
HIDE WINDOW | X | X | X | |
HOME( ) | X | X | X | |
HOUR( ) | X | X | ||
IDXCOLLATE( ) | X | X | X | |
IF ... ENDIF | X | X | X | |
IIF( ) | X | X | X | |
IMESTATUS( ) | X | X | ||
IMPORT | X | M | M |
3.0 XL5 [SHEET] and AS clauses 5.0 DATABASE and NAME clauses |
INDBC( ) | X | X | ||
INDEX | X | M | X | 3.0 - CANDIDATE clause |
INKEY( ) | X | X | X | |
INLIST( ) | X | X | X | |
INPUT | X | X | X | |
INSERT | X | X | X | |
INSERT - SQL | X | X | X | |
INSMODE( ) | X | X | X | |
INT( ) | X | X | X | |
ISALPHA( ) | X | X | ||
ISBLANK( ) | X | X | X | |
ISCOLOR( ) | X | X | X | |
ISDIGIT( ) | X | X | X | |
ISEXCLUSIVE( ) | X | X | ||
ISFLOCKED( ) | X | |||
ISLEADBYTE( ) | X | X | ||
ISLOWER( ) | X | X | X | |
ISMOUSE( ) | X | X | ||
ISNULL( ) | X | X | ||
ISREADONLY( ) | X | X | X | |
ISRLOCKED( ) | X | |||
ISUPPER( ) | X | X | X | |
JOIN | X | X | X | |
KEY( ) | X | X | X | |
KEYBOARD | X | X | X | |
KEYMATCH( ) | X | X | X | |
LABEL | X | M | X | 3.0 NAME clause |
LASTKEY( ) | X | X | X | |
LEFT( ) | X | X | X | |
LEFTC( ) | X | X | ||
LEN( ) | X | X | X | |
LENC( ) | X | X | ||
LIKE( ) | X | X | X | |
LIKEC( ) | X | X | ||
LINENO( ) | X | X | X | |
LIST | X | X | X | |
LIST CONNECTIONS | X | X | ||
LIST DATABASE | X | X | ||
LIST DLLS | X | X | ||
LIST FILES | X | X | X | |
LIST MEMORY | X | X | X | |
LIST OBJECTS | X | X | ||
LIST PROCEDURES | X | X | ||
LIST STATUS | X | X | X | |
LIST STRUCTURE | X | X | X | |
LIST TABLES | X | X | ||
LIST VIEWS | X | X | ||
LOAD | X | X | X | |
LOADPICTURE( ) | X | |||
LOCAL | X | X | ||
LOCATE | X | X | X | |
LOCFILE( ) | X | X | X | |
LOCK( ) | X | X | X | |
LOG( ) | X | X | X | |
LOG10( ) | X | X | X | |
LOOKUP( ) | X | X | X | |
LOWER( ) | X | X | X | |
LPARAMETERS | X | X | ||
LTRIM( ) | X | X | X | |
LUPDATE( ) | X | X | X | |
MAX( ) | X | X | X | |
MCOL( ) | X | X | M | 5.0 Scalemode option |
MD | MKDIR | X | M | 5.0 Can create entire path | |
MDOWN( ) | X | X | X | |
MDX( ) | X | X | X | |
MDY( ) | X | X | X | |
MEMLINES( ) | X | X | X | |
MEMORY( ) | X | X | X | |
MENU | X | X | X | |
MENU TO | X | X | X | |
MENU( ) | X | X | X | |
MESSAGE( ) | X | X | X | |
MESSAGEBOX( ) | X | X | ||
MIN( ) | X | X | X | |
MINUTE( ) | X | X | ||
MLINE( ) | X | X | X | |
MOD( ) | X | X | X | |
MODIFY CLASS | X | X | ||
MODIFY COMMAND | X | M | X | 3.0 AS nCodePage clause |
MODIFY CONNECTION | X | X | ||
MODIFY DATABASE | X | X | ||
MODIFY FILE | X | M | X | 3.0 AS nCodepage clause |
MODIFY FORM | X | X | ||
MODIFY GENERAL | X | X | X | |
MODIFY LABEL | X | X | X | |
MODIFY MEMO | X | X | X | |
MODIFY MENU | X | X | X | |
MODIFY PROCEDURE | X | X | ||
MODIFY PROJECT | X | X | X | |
MODIFY QUERY | X | M | X | 3.0 AS nCodePage clause |
MODIFY REPORT | X | X | X | |
MODIFY SCREEN | X | X | X | |
MODIFY STRUCTURE | X | X | X | |
MODIFY VIEW | X | X | ||
MODIFY WINDOW | X | X | X | |
MONTH( ) | X | X | X | |
MOUSE | X | X | ||
MOVE POPUP | X | X | X | |
MOVE WINDOW | X | X | X | |
MRKBAR( ) | X | X | X | |
MRKPAD( ) | X | X | X | |
MROW( ) | X | X | M | 5.0 ScaleMode option |
MTON( ) | X | X | ||
MWINDOW( ) | X | X | X | |
NDX( ) | X | X | X | |
NORMALIZE( ) | X | X | X | |
NOTE | X | X | X | |
NTOM( ) | X | X | ||
NUMLOCK( ) | X | X | X | |
NVL( ) | X | X | ||
OBJNUM( ) | X | X | X | |
OBJTOCLIENT( ) | X | X | ||
OBJVAR( ) | X | X | X | |
OCCURS( ) | X | X | X | |
OEMTOANSI( ) | X | X | X | |
OLDVAL( ) | X | X | ||
ON APLABOUT | X | X | X | |
ON BAR | X | X | X | |
ON ERROR | X | X | X | |
ON ESCAPE | X | X | X | |
ON EXIT BAR | X | X | X | |
ON EXIT MENU | X | X | X | |
ON EXIT PAD | X | X | X | |
ON EXIT POPUP | X | X | X | |
ON KEY | X | X | X | |
ON KEY = | X | X | X | |
ON KEY LABEL | X | X | X | |
ON MACHELP | X | X | X | |
ON PAD | X | X | X | |
ON PAGE | X | X | X | |
ON READERROR | X | X | X | |
ON SELECTION BAR | X | X | X | |
ON SELECTION MENU | X | X | X | |
ON SELECTION PAD | X | X | X | |
ON SELECTION POPUP | X | X | X | |
ON SHUTDOWN | X | X | X | |
ON( ) | X | X | X | |
OPEN DATABASE | X | X | ||
ORDER( ) | X | X | X | |
OS( ) | X | X | X | |
PACK | X | X | X | |
PACK DATABASE | X | X | ||
PAD( ) | X | X | X | |
PADC( ) | PADL( ) | PADR( ) | X | X | X | |
PARAMETERS | X | X | X | |
PARAMETERS( ) | X | X | X | |
PAYMENT( ) | X | X | X | |
PCOL( ) | X | X | X | |
PEMSTATUS( ) | X | X | ||
PI( ) | X | X | X | |
PLAY MACRO | X | X | X | |
POP KEY | X | X | X | |
POP MENU | X | X | X | |
POP POPUP | X | X | X | |
POPUP( ) | X | M | X | 3.0 cMenuName parameter |
PRIMARY( ) | X | X | ||
PRINTJOB ... ENDPRINTJOB | X | X | X | |
PRINTSTATUS( ) | X | X | X | |
PRIVATE | X | X | X | |
PRMBAR( ) | X | X | X | |
PRMPAD( ) | X | X | X | |
PROCEDURE | X | X | X | |
PROGRAM( ) | X | X | X | |
PROMPT( ) | X | X | X | |
PROPER( ) | X | X | X | |
PROW( ) | X | X | X | |
PRTINFO( ) | X | M | X |
3.0 new options (13 total) |
PUBLIC | X | X | X | |
PUSH KEY | X | X | X | |
PUSH MENU | X | X | X | |
PUSH POPUP | X | X | X | |
PUTFILE( ) | X | X | X | |
PV( ) | X | X | X | |
QUIT | X | X | X | |
RAND( ) | X | X | X | |
RAT( ) | X | X | X | |
RATC( ) | X | X | ||
RATLINE( ) | X | X | X | |
RD | RMDIR | X | X | ||
RDLEVEL( ) | X | X | X | |
READ | X | X | X | |
READ EVENTS | X | X | ||
READ MENU | X | X | X | |
READKEY( ) | X | X | X | |
RECALL | X | X | X | |
RECCOUNT( ) | X | X | X | |
RECNO( ) | X | X | X | |
RECSIZE( ) | X | X | X | |
REFRESH( ) | X | X | ||
REINDEX | X | X | X | |
RELATION( ) | X | X | X | |
RELEASE | X | M | X | 3.0 Programs can release PUBLIC variables with EXTENDED clause |
RELEASE CLASSLIB | X | X | ||
RELEASE MODULE | X | X | X | |
RELEASE PROCEDURE | X | X | ||
REMOVE CLASS | X | X | ||
REMOVE TABLE | X | X | ||
RENAME | X | X | X | |
RENAME CLASS | X | X | ||
RENAME CONNECTION | X | X | ||
RENAME TABLE | X | X | ||
RENAME VIEW | X | X | ||
REPLACE | X | M | X | 3.0 IN Clause |
REPLACE FROM ARRAY | X | X | X | |
REPLICATE( ) | X | X | X | |
REPORT | X | M | M |
3.0 NOWAIT, ASCII, NAME clauses 5.0 WINDOW and RANGE clauses |
REQUERY( ) | X | X | ||
RESTORE FROM | X | X | X | |
RESTORE MACROS | X | X | X | |
RESTORE SCREEN | X | X | X | |
RESTORE WINDOW | X | X | X | |
RESUME | X | X | X | |
RETRY | X | X | X | |
RETURN | X | X | X | |
RGB( ) | X | X | ||
RGBSCHEME( ) | X | X | X | |
RIGHT( ) | X | X | X | |
RIGHTC( ) | X | X | ||
RLOCK( ) | X | X | X | |
ROLLBACK | X | X | ||
ROUND( ) | X | X | X | |
ROW( ) | X | X | X | |
RTOD( ) | X | X | X | |
RTRIM( ) | X | X | X | |
RUN | ! | X | X | X | |
RUNSCRIPT | X | X | X | |
SAVE MACROS | X | X | X | |
SAVE SCREEN | X | X | X | |
SAVE TO | X | X | X | |
SAVE WINDOWS | X | X | X | |
SAVEPICTURE( ) | X | |||
SCAN ... ENDSCAN | X | X | X | |
SCATTER | X | X | X | |
SCHEME( ) | X | X | X | |
SCOLS( ) | X | X | X | |
SCROLL | X | X | X | |
SEC( ) | X | X | ||
SECONDS( ) | X | X | X | |
SEEK | X | M | X | 3.0 ORDER, TAG, IN clauses |
SEEK( ) | X | M | X | 3.0 cTagname parameter |
SELECT | X | X | X | |
SELECT - SQL | X | M | M |
3.0 Database!Table syntax 5.0 DATABASE, FORCE, JOIN ON, NAME and TOP (SQL-92) clauses |
SELECT( ) | X | X | X | |
SET | X | X | X | |
SET( ) | X | X | M | 5.0 SET(DATE,1) and SET(PRINTER,2) |
SETFLDSTATE( ) | X | X | ||
SHOW GET | X | X | X | |
SHOW GETS | X | X | X | |
SHOW MENU | X | X | X | |
SHOW OBJECT | X | X | X | |
SHOW POPUP | X | X | X | |
SHOW WINDOW | X | X | X | |
SIGN( ) | X | X | X | |
SIN( ) | X | X | X | |
SIZE POPUP | X | X | X | |
SIZE WINDOW | X | X | ||
SKIP | X | X | X | |
SKPBAR( ) | X | X | X | |
SKPPAD( ) | X | X | X | |
SORT | X | X | M | 5.0 DATABASE and NAME clauses |
SOUNDEX( ) | X | X | X | |
SPACE( ) | X | X | X | |
SQLCANCEL( ) | X | X | ||
SQLCOLUMNS( ) | X | X | ||
SQLCOMMIT( ) | X | X | ||
SQLCONNECT( ) | X | X | ||
SQLDISCONNECT( ) | X | X | ||
SQLEXEC( ) | X | X | ||
SQLGETPROP( ) | X | X | ||
SQLMORERESULTS( ) | X | X | ||
SQLPREPARE( ) | X | |||
SQLROLLBACK( ) | X | X | ||
SQLSETPROP( ) | X | X | ||
SQLSTRINGCONNECT( ) | X | X | ||
SQLTABLES( ) | X | X | ||
SQRT( ) | X | X | X | |
SROWS( ) | X | X | X | |
STORE | X | X | X | |
STR( ) | X | X | X | |
STRCONV( ) | X | X | ||
STRTRAN( ) | X | X | X | |
STUFF( ) | X | X | X | |
STUFFC( ) | X | X | ||
SUBSTR( ) | X | X | X | |
SUBSTRC( ) | X | X | ||
SUM | X | X | X | |
SUSPEND | X | X | X | |
SYSMETRIC( ) | X | X | X | |
TABLEREVERT( ) | X | X | ||
TABLEUPDATE( ) | X | X | ||
TAG( ) | X | X | X | |
TAGCOUNT( ) | X | X | X | |
TAGNO( ) | X | X | X | |
TAN( ) | X | X | X | |
TARGET( ) | X | X | X | |
TEXT ... ENDTEXT | X | X | X | |
THIS Object Reference | X | X | ||
THISFORM Object Reference | X | X | ||
THISFORMSET Object Reference | X | X | ||
TIME( ) | X | X | X | |
TOTAL | X | X | M | 5.0 DATABASE and NAME clauses |
TRANSFORM( ) | X | X | X | |
TRIM( ) | X | X | X | |
TTOC( ) | X | M | 5.0 new 2 argument | |
TTOD( ) | X | X | ||
TXNLEVEL( ) | X | X | ||
TXTWIDTH( ) | X | X | X | |
TYPE | X | X | X | |
TYPE( ) | X | X | X | |
UNIQUE( ) | X | X | X | |
UNLOCK | X | M | X | 3.0 RECORD clause |
UPDATE | X | X | X | |
UPDATE - SQL | X | X | ||
UPDATED( ) | X | X | X | |
UPPER( ) | X | X | X | |
USE | X | M | M |
3.0 SQLviewName parameter, NOQUERY and NODATA clauses 5.0 ADMIN and ONLINE clauses |
USED( ) | X | X | X | |
VAL( ) | X | X | X | |
VALIDATE DATABASE | X | X | ||
VARREAD( ) | X | X | X | |
VERSION( ) | X | M | X | 3.0 1,2 and 3 options |
WAIT | X | M | X | 3.0 AT and NOCLEAR clauses |
WBORDER( ) | X | X | X | |
WCHILD( ) | X | X | X | |
WCOLS( ) | X | X | X | |
WEEK( ) | X | X | ||
WEXIST( ) | X | X | X | |
WFONT( ) | X | X | X | |
WITH ... ENDWITH | X | X | ||
WLAST( ) | X | X | X | |
WLCOL( ) | X | X | X | |
WLROW( ) | X | X | X | |
WMAXIMUM( ) | X | X | X | |
WMINIMUM( ) | X | X | X | |
WONTOP( ) | X | X | X | |
WOUTPUT( ) | X | X | X | |
WPARENT( ) | X | X | X | |
WREAD( ) | X | X | X | |
WROWS( ) | X | X | X | |
WTITLE( ) | X | X | X | |
WVISIBLE( ) | X | X | X | |
YEAR( ) | X | X | X | |
ZAP | X | M | X | 3.0 IN clause |
ZOOM WINDOW | X | X | X |
The following SET commands exist in the specified versions of FoxPro 2.x and Visual FoxPro.
Command |
2.6 |
3.0 |
5.0 |
Private Data Session |
Changes or Comments |
SET ALTERNATE | X | X | X | ||
SET ANSI | X | X | X | X | |
SET APLABOUT | X | X | Macintosh Only | ||
SET ASSERTS | X | ||||
SET AUTOSAVE | X | X | X | X | |
SET BELL | X | X | X | ||
SET BLINK | X | * | MS-DOS only | ||
SET BLOCKSIZE | X | X | X | X | |
SET BORDER | X | X* | * | Use the BorderStyle Property instead | |
SET BRSTATUS | X | X* | * | Use the StatusBarText Property instead | |
SET CARRY | X | X | X | X | |
SET CENTURY | X | X | X | X | |
SET CLASSLIB | X | X | |||
SET CLEAR | X | X* | * | Use the Refresh Method instead | |
SET CLOCK | X | X | X | ||
SET COLLATE | X | X | X | X | |
SET COLOR OF | X | X* | * | Use SET COLOR OF SCHEME instead | |
SET COLOR OF SCHEME | X | X | X | ||
SET COLOR SET | X | X | X | ||
SET COLOR TO | X | X* | * | Use SET COLOR OF SCHEME instead | |
SET COMPATIBLE | X | X | X | ||
SET CONFIRM | X | X | X | X | |
SET CONSOLE | X | X | X | ||
SET COVERAGE | X | ||||
SET CPCOMPILE | X | X | |||
SET CPDIALOG | X | X | |||
SET CURRENCY | X | X | X | X | |
SET CURSOR | X | X | X | ||
SET DATABASE | X | X | X | ||
SET DATASESSION | X | X | |||
SET DATE | X | X | M | X | 5.0 - SHORT, LONG and TAIWAN clauses |
SET DEBUG | X | X | X | ||
SET DEBUGOUT | X | ||||
SET DECIMALS | X | X | X | X | |
SET DEFAULT | X | X | X | ||
SET DELETED | X | X | X | X | |
SET DELIMITERS | X | X* | * | X | Use the Format Property instead |
SET DEVELOPMENT | X | X | X | ||
SET DEVICE | X | X | X | ||
SET DISPLAY | X | X | X | ||
SET DOHISTORY | X | M | * |
Use the Trace Window instead 3.0 - TO filename ADDITIVE clause |
|
SET ECHO | X | X | X* | Use the Trace Window instead | |
SET ESCAPE | X | X | X | ||
SET EVENTLIST | X | ||||
SET EVENTTRACKING | X | ||||
SET EXACT | X | X | X | X | |
SET EXCLUSIVE | X | X | X | X | |
SET FDOW | X | X | |||
SET FIELDS | X | X | X | X | |
SET FILTER | X | X | X | ||
SET FIXED | X | X | X | X | |
SET FORMAT | X | X* | * | Use the Format Property instead | |
SET FULLPATH | X | X | X | ||
SET FUNCTION | X | X | X | ||
SET FWEEK | X | X | |||
SET HEADINGS | X | X | X | ||
SET HELP | X | X | X | ||
SET HELPFILTER | X | X | X | ||
SET HOURS | X | X | X | X | Scopes to Private Data Session in Visual FoxPro 5.0 ONLY |
SET INDEX | X | X | X | ||
SET INTENSITY | X | X* | * | Use SET COLOR OF SCHEME instead | |
SET KEY | X | X | X | ||
SET KEYCOMP | X | X | X | ||
SET LIBRARY | X | X | X | ||
SET LOCK | X | X | X | X | |
SET LOGERRORS | X | X | X | ||
SET MACDESKTOP | X | X | Macintosh Only | ||
SET MACHELP | X | X | Macintosh Only | ||
SET MACKEY | X | X | X | ||
SET MARGIN | X | X | X | ||
SET MARK OF | X | X | X | ||
SET MARK TO | X | X | X | X | |
SET MEMOWIDTH | X | X | X | X | |
SET MESSAGE | X | X | X | ||
SET MOUSE | X | * | MS-DOS Only | ||
SET MULTILOCKS | X | X | X | X | |
SET NEAR | X | X | X | X | |
SET NOCPTRANS | X | X | X | ||
SET NOTIFY | X | X | X | ||
SET NULL | X | X | X | ||
SET NULLDISPLAY | X | ||||
SET ODOMETER | X | X | X | ||
SET OLEOBJECT | X | X | |||
SET OPTIMIZE | X | X | X | ||
SET ORDER | X | X | X | ||
SET PALETTE | X | X | X | ||
SET PATH | X | X | X | ||
SET PDSETUP | X | X | X | ||
SET POINT | X | X | X | X | |
SET PRINTER | X | M | X | 3.0 - FONT, DEFAULT and NAME clauses | |
SET PROCEDURE | X | M | X | 3.0 - ADDITIVE clause | |
SET READBORDER | X | X | X | ||
SET REFRESH | X | X | X | ||
SET RELATION | X | X | X | ||
SET RELATION OFF | X | X | X | ||
SET REPROCESS | X | X | X | X | |
SET RESOURCE | X | X | X | ||
SET SAFETY | X | X | X | X | |
SET SCOREBOARD | X | * | MS-DOS only | ||
SET SECONDS | X | X | X | Scopes to Private Data Session in Visual FoxPro 5.0 ONLY | |
SET SEPARATOR | X | X | * | X | Use the Windows Control Panel instead |
SET SHADOWS | X | * | MS-DOS only | ||
SET SKIP | X | X | X | ||
SET SKIP OF | X | X | X | ||
SET SPACE | X | X | X | ||
SET STATUS | X | * | * | Use the StatusBarText Property instead | |
SET STATUS BAR | X | * | * | Use the StatusBarText property instead | |
SET STEP | X | X | X | ||
SET STICKY | X | X | X | ||
SET SYSFORMATS | X | M | X | 5.0 - uses SET DATE SHORT format | |
SET SYSMENU | X | X | X | ||
SET TALK | X | X | X | X | |
SET TEXTMERGE | X | X | X | ||
SET TEXTMERGE DELIMITERS |
X | X | X | ||
SET TOPIC | X | X | X | ||
SET TOPIC ID | X | X | |||
SET TRBETWEEN | X | X | X | ||
SET TYPEAHEAD | X | X | X | ||
SET UDFPARMS | X | X | X | ||
SET UNIQUE | X | X | X | X | |
SET VIEW | X | X | X | ||
SET VOLUME | X | X | Macintosh Only | ||
SET WINDOW OF MEMO | X | * | * | Use the TextBox Control instead | |
SET XCMDFILE | X | X | Macintosh only |
The following is a complete list of all available SYS( ) functions.
SYS( ) Function Name and Description | 2.6 | 3.0 | 5.0 |
SYS(0) Network machine #/name | X | X | X |
SYS(1) Julian system date | X | X | X |
SYS(2) Seconds since midnight | X | X | X |
SYS(3) Unique file name | X | X | X |
SYS(5) DEFAULT drive | X | X | X |
SYS(6) PRINTER device | X | X | X |
SYS(7) FORMAT file | X | X | X |
SYS(9) FoxPro serial number | X | X | X |
SYS(10) String from day number | X | X | X |
SYS(11) Julian day number | X | X | X |
SYS(12) Remaining memory | X | X | X |
SYS(13) Printer status | X | X | X |
SYS(14) Index expression | X | X | X |
SYS(15) Character Translation | X | * | * |
SYS(16) Executing program name | X | X | X |
SYS(17) Processor in use | X | X | X |
SYS(18) Current field/object | X | * | * |
SYS(20) Transform German Text | X | * | * |
SYS(21) Master index number | X | X | X |
SYS(22) Master tag/index name | X | X | X |
SYS(23) EMS memory available | X | X | X |
SYS(24) EMS memory limit | X | X | X |
SYS(100) CONSOLE setting | X | X | X |
SYS(101) DEVICE setting | X | X | X |
SYS(102) PRINTER setting | X | X | X |
SYS(103) TALK setting | X | X | X |
SYS(1001) FoxPro's memory | X | X | X |
SYS(1016) User alloc. Memory | X | X | X |
SYS(1023) Enable Help Diagnostic Mode | X | X | |
SYS(1024) Disable Help Diagnostic Mode | X | X | |
SYS(1037) Printer setup dialog | X | X | X |
SYS(1269) Property Information | X | X | |
SYS(1270) Object Location | X | X | |
SYS(1271) Object's .SCX File | X | X | |
SYS(1272) Object Hierarchy | X | X | |
SYS(1500) Activate a System Menu Item | X | ||
SYS(2000) File wildcard match | X | X | X |
SYS(2001) SET command status | X | X | X |
SYS(2002) Turn cursor on/off | X | X | X |
SYS(2003) Current directory | X | X | X |
SYS(2004) FoxPro's directory | X | X | X |
SYS(2005) Resource file | X | X | X |
SYS(2006) Graphics support | X | X | X |
SYS(2007) Checksum | X | X | X |
SYS(2008) Cursor shape | X | X | X |
SYS(2009) Swap cursor shape | X | X | X |
SYS(2010) FILES in CONFIG.SYS | X | X | X |
SYS(2011) Lock status | X | X | X |
SYS(2012) Memo file blocksize | X | X | X |
SYS(2013) System menu name | X | X | X |
SYS(2014) Minimum path | X | X | X |
SYS(2015) Unique name | X | X | X |
SYS(2016) SHOW GETS WINDOW Name | X | * | * |
SYS(2017) Display Startup Screen | X | * | * |
SYS(2018) Error message | X | X | X |
SYS(2019) Configuration file | X | X | X |
SYS(2020) Disk size | X | X | X |
SYS(2021) Filtered index expr | X | X | X |
SYS(2022) Disk cluster size | X | X | X |
SYS(2023) Temporary file drive | X | X | X |
SYS(2027) Map MS-DOS shorthand | X | X | X |
SYS(2029) Table Type | X | X | |
SYS(2333) ActiveX Dual Interface Support | X | ||
SYS(3004) Return Locale ID | X | X | |
SYS(3005) Set Locale ID | X | X | |
SYS(3006) Set Language and Locale Ids | X | X | |
SYS(3050) Set Buffer Memory Size | X | X | |
SYS(3051) Set Lock Retry Interval | X | X | |
SYS(3052) Override SET REPROCESS Locking | X | X | |
SYS(3053) ODBC Environment Handle | X | X | |
SYS(3054) Rushmore Optimization Level | X |
A list of the available system variables in various versions of FoxPro.
System Variable Name | 2.6 | 3.0 | 5.0 |
_ALIGNMENT | X | * | * |
_ASCIICOLS | X | X | |
_ASCIIROWS | X | X | |
_ASSIST | X | * | * |
_BEAUTIFY | X | * | X |
_BOX | X | * | * |
_BROWSER | X | X | |
_BUILDER | X | X | |
_CALCMEM | X | X | X |
_CALCVALUE | X | X | X |
_CLIPTEXT | X | X | X |
_CONVERTER | X | X | |
_COVERAGE | X | ||
_CUROBJ | X | * | * |
_DBLCLICK | X | X | X |
_DIARYDATE | X | X | X |
_DOS | X | X | X |
_FOXDOC | X | * | * |
_FOXGRAPH | X | X | X |
_GENGRAPH | X | * | * |
_GENMENU | X | X | X |
_GENPD | X | * | * |
_GENSCRN | X | * | * |
_GENXTAB | X | * | * |
_INDENT | X | * | * |
_LMARGIN | X | * | * |
_MAC | X | X | X |
_MLINE | X | X | X |
_PADVANCE | X | * | * |
_PAGENO | X | X | X |
_PBPAGE | X | * | * |
_PCOLNO | X | * | * |
_PCOPIES | X | * | * |
_PDRIVER | X | * | * |
_PDSETUP | X | * | * |
_PECODE | X | * | * |
_PEJECT | X | * | * |
_PEPAGE | X | * | * |
_PLENGTH | X | * | * |
_PLINENO | X | * | * |
_PLOFFSET | X | * | * |
_PPITCH | X | * | * |
_PQUALITY | X | * | * |
_PRETEXT | X | X | X |
_PSCODE | X | * | * |
_PSPACING | X | * | * |
_PWAIT | X | * | * |
_RMARGIN | X | * | * |
_SCCTEXT | X | ||
_SCREEN | X | X | |
_SHELL | X | X | X |
_SPELLCHK | X | X | X |
_STARTUP | X | * | * |
_TABS | X | * | * |
_TALLY | X | X | X |
_TEXT | X | X | X |
_THROTTLE | X | X | X |
_TRANSPORT | X | * | * |
_TRIGGERLEVEL | X | X | |
_UNIX | X | X | X |
_VFP | X | ||
_WINDOWS | X | X | X |
_WIZARD | X | X | |
_WRAP | X | * | * |