Language Differences Between Foxpro 2 and Visual Foxpro 3/5

Language Differences between FoxPro 2.x and Visual FoxPro

This Appendix originally appeared in the FoxPro 2.x to Visual FoxPro Migration Manualby 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 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