Language Differences between FoxPro 2.x and Visual FoxPro


This Appendix originally appeared in the FoxPro 2.x to Visual FoxPro Migration Manual by Micro Endeavors, Inc. The material is part of a two-day FoxPro 2.x to Visual FoxPro migration seminar developed and taught by Micro Endeavors. For information about the migration seminar, and other training and services available from Micro Endeavors, please visit them on the Web at http://www.microendeavors.com, or call (800) 331-9434 or (610) 449-4680. (c) 1997 Micro Endeavors, Inc.

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

Updating FoxPro 2.x Commands and Functions for Visual FoxPro

Many of Visual FoxPro’s 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

FoxPro 2.x and Visual FoxPro Commands

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  

SET Commands

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

SYS( ) Functions

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

System Variables

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 * *