ÍÍÍÍÍÍ Before You Begin ÍÍÍÍÍÍ
General
  (c) Microsoft Corporation
General wn
  Using Help
  Run Menu
General me in
  Doc Changes Since Printing
General nx
  What's New Since 1.02
General wn nx
  Technical Support
General er
  CompuServe -- The Fox Forum
  FoxPro Self-Running Demo
General pe
  Patching FoxPro
ÍÍÍÍÍÍÍ General Topics ÍÍÍÍÍÍÍ
  Color Table by Color Pair
General en in
  Command Continuation
General wi
  Commonly Asked Questions
  Compatibility
General cm
  Configuring FoxPro
General cf
  Demand Paging
  DOS 5.0
General en
  Error Messages
General em
  Expanded/Extended Memory
  File Extensions
General fm
  Foundation READ
General wi mp eh
  FoxApp - Build Applications
  FOX.EXE - a Diagnostic Tool
General en pe
  How FoxPro Finds Components
  Linker Performance
  Name Expressions
General fm pe
  Optimizing Performance
General cf pe
  Printer Driver Hints
General pr
  Problem RAM Disks & Caches
  Procolor
  Project Manager Hints
General pe fm
  READ with Multiple Windows
General in ex
  Running Under DESQview
  Running Under Windows 3.0
  Rushmore Technology
  Screen Generator Directives
General in nx
  SQL Cursors
General sq db
  System Capacities
  Transaction Processing
General pe mu
  TYPE() and EVALUATE()
General ch nu dt lo
  Version Control & Projects
General pe nx
  Which FoxPro Version to Run
ÍÍÍÍÍ The FoxPro Language ÍÍÍÍ
%
Function nu nx
&
Function ch
$
=
Command mv
\ | \\
Command tm nx
? | ??
Command pr in
???
Command pr
@ ... SAY/GET
Command pr in ex
@ ... GET - Check Boxes
Command in nx
@ ... GET - Invisible Buttons
@ ... GET - Lists
@ ... GET - Popups
@ ... GET - Push Buttons
@ ... GET - Radio Buttons
@ ... EDIT - Text Edit Regions
@ ... BOX
Command in
@ ... CLEAR
@ ... FILL
@ ... MENU
Command mp
@ ... PROMPT
@ ... TO
ABS()
Function nu
ACCEPT
Command mv in
ACOPY()
Function mv nx
ACOS()
ACTIVATE MENU
Command mp ex
ACTIVATE POPUP
ACTIVATE SCREEN
Command in wi
ACTIVATE WINDOW
Command wi
ADEL()
ADIR()
AELEMENT()
AFIELDS()
AINS()
ALEN()
ALIAS()
Function db
ALLTRIM()
APPEND
Command db in
APPEND FROM
Command db ex
APPEND FROM ARRAY
APPEND MEMO
Command db
ASC()
ASCAN()
ASIN()
ASORT()
ASUBSCRIPT()
AT()
ATAN()
ATC()
ATCLINE()
ATLINE()
ATN2()
AVERAGE
Command mv db
BAR()
Function mp
BETWEEN()
Function ch nu dt
BOF()
Function lo db
BROWSE
Command db in ex
BUILD APP
Command pe nx
BUILD EXE
BUILD PROJECT
CALCULATE
CALL
Command pe
CANCEL
CAPSLOCK()
Function en km
CDOW()
Function dt
CDX()
Function db ix nx
CEILING()
CHANGE
CHR()
Function ch dc
CHRSAW()
Function km
CHRTRAN()
CLEAR
Command mv mp wi in
CLOSE
Command db fm
CLOSE MEMO
CMONTH()
CNTBAR()
Function mp nx
CNTPAD()
COL()
Function en in
COMPILE
CONTINUE
COPY FILE
Command fm
COPY INDEXES
Command db ix nx
COPY MEMO
COPY STRUCTURE
COPY STRUCTURE EXTENDED
COPY TAG
COPY TO
Command db fm ex
COPY TO ARRAY
COS()
COUNT
CREATE
CREATE COLOR SET
Command en in nx
CREATE CURSOR - SQL
Command db nx
CREATE FROM
CREATE LABEL
CREATE MENU
Command mp nx
CREATE PROJECT
CREATE QUERY
Command db nx sq
CREATE REPORT
CREATE REPORT - Quick Report
CREATE SCREEN
CREATE SCREEN - Quick Screen
CREATE TABLE - SQL
Command sq db nx
CREATE VIEW
Command en fm
CTOD()
Function ch dt dc
CURDIR()
Function fm
DATE()
DAY()
DBF()
DEACTIVATE MENU
DEACTIVATE POPUP
DEACTIVATE WINDOW
DECLARE
Command mv ex
DEFINE BAR
DEFINE BOX
DEFINE MENU
DEFINE PAD
DEFINE POPUP
DEFINE WINDOW
Command wi ex
DELETE
DELETE FILE
DELETE TAG
DELETED()
DIFFERENCE()
DIMENSION
DIRECTORY
DISKSPACE()
DISPLAY
Command mv en pr in
DISPLAY FILES
DISPLAY MEMORY
Command mv en
DISPLAY STATUS
Command en
DISPLAY STRUCTURE
DMY()
DO
Command fm pe ex
DO CASE
Command sp
DO WHILE
DOW()
DTOC()
Function ch dt
DTOR()
DTOS()
EDIT
EJECT
EJECT PAGE
EMPTY()
EOF()
ERASE
ERROR()
Function en
EVALUATE()
Function ch nu dt lo
EXIT
EXP()
EXPORT
Command db fm nx
EXTERNAL
FCHSIZE()
Function ll
FCLOSE()
FCOUNT()
FCREATE()
FEOF()
FERROR()
FFLUSH()
FGETS()
FIELD()
FILE()
Function lo fm
FILER
FILTER()
FIND
FKLABEL()
FKMAX()
FLOCK()
Function mu
FLOOR()
FLUSH
FOPEN()
FOR ... ENDFOR
FOUND()
FPUTS()
FREAD()
FSEEK()
FSIZE()
FULLPATH()
FUNCTION
FV()
FWRITE()
GATHER
Command db mv
GETBAR()
GETENV()
GETEXPR
GETFILE()
Function en fm
GETPAD()
GO/GOTO
GOMONTH()
HEADER()
HELP
HIDE MENU
HIDE POPUP
HIDE WINDOW
IF ... ENDIF
IIF()
IMPORT
INDEX
Command db ix ex
INKEY()
Function en km in
INLIST()
INPUT
INSERT
INSERT - SQL
INSMODE()
INT()
ISALPHA()
Function ch lo
ISCOLOR()
Function lo en
ISDIGIT()
ISLOWER()
ISUPPER()
JOIN
KEY()
Function db ix ex
KEYBOARD
Command km
LABEL
Command pr ex
LASTKEY()
LEFT()
LEN()
LIKE()
LINENO()
LIST
Command mv in fm pr
LOAD
LOCATE
LOCFILE()
Function en fm nx
LOCK()
LOG()
LOG10()
LOOKUP()
LOWER()
LTRIM()
LUPDATE()
MAX()
MCOL()
MDOWN()
MDX()
MDY()
MEMLINES()
MEMORY()
MENU
MENU - System Menu Names
MENU TO
MENU()
MESSAGE()
MIN()
MLINE()
MOD()
MODIFY COMMAND/FILE
MODIFY LABEL
MODIFY MEMO
MODIFY MENU
MODIFY PROJECT
MODIFY QUERY
MODIFY REPORT
MODIFY SCREEN
MODIFY STRUCTURE
MONTH()
MOVE POPUP
MOVE WINDOW
MRKBAR()
MRKPAD()
MROW()
MWINDOW()
Function km wi nx
NDX()
NETWORK()
NOTE | * | &&
Command er
NUMLOCK()
OBJNUM()
Function in nx
OCCURS()
ON BAR
Command eh mp nx
ON ERROR
Command eh er mu
ON ESCAPE
Command eh
ON KEY
Command eh km
ON KEY =
ON KEY LABEL
ON PAD
Command eh mp ex
ON PAGE
ON READERROR
Command eh er
ON SELECTION BAR
ON SELECTION MENU
ON SELECTION PAD
Command eh mp
ON SELECTION POPUP
ON()
Function eh er nx
ORDER()
OS()
PACK
PAD()
Function ch mp
PADC() | PADL() | PADR()
PARAMETERS
Command mv pe ex
PARAMETERS()
PAYMENT()
PCOL()
Function en pr
PI()
PLAY MACRO
POP KEY
Command km nx
POP MENU
POP POPUP
POPUP()
PRINTJOB ... ENDPRINTJOB
PRINTSTATUS()
Function lo pr
PRIVATE
PRMBAR()
PRMPAD()
PROCEDURE
PROGRAM()
PROMPT()
PROPER()
PROW()
PUBLIC
PUSH KEY
PUSH MENU
PUSH POPUP
PUTFILE()
PV()
QUIT
RAND()
RAT()
RATLINE()
RDLEVEL()
Function nu en nx
READ
Command in ex
READ MENU
READKEY()
RECALL
RECCOUNT()
RECNO()
RECSIZE()
REGIONAL
REINDEX
RELATION()
RELEASE
Command mv mp wi pe
RELEASE MODULE
RENAME
REPLACE
REPLICATE()
REPORT
RESTORE FROM
RESTORE MACROS
RESTORE SCREEN
RESTORE WINDOW
RESUME
RETRY
RETURN
RIGHT()
RLOCK()
ROUND()
ROW()
RTOD()
RTRIM()
RUN | !
SAVE MACROS
SAVE SCREEN
SAVE TO
SAVE WINDOW
SCAN
SCATTER
SCHEME()
SCOLS()
SCROLL
Command in wi ex
SECONDS()
SEEK
SEEK()
SELECT
SELECT()
SELECT - SQL
SET
SET ALTERNATE
SET ANSI
SET AUTOSAVE
SET BELL
SET BLINK
Command en in
SET BLOCKSIZE
SET BORDER
Command mp wi
SET BRSTATUS
SET CARRY
SET CENTURY
Command en dt
SET CLEAR
SET CLOCK
SET COLOR OF
SET COLOR OF SCHEME
SET COLOR SET
SET COLOR TO
SET COMPATIBLE
SET CONFIRM
Command in km
SET CONSOLE
SET CURRENCY
SET CURSOR
SET DATE
Command en in dt
SET DEBUG
SET DECIMALS
SET DEFAULT
SET DELETED
SET DELIMITERS
SET DEVELOPMENT
SET DEVICE
Command fm en in
SET DISPLAY
SET DOHISTORY
SET ECHO
SET ESCAPE
SET EXACT
SET EXCLUSIVE
Command mu
SET FIELDS
SET FILTER
SET FIXED
SET FORMAT
SET FULLPATH
SET FUNCTION
Command en km
SET HEADING
SET HELP
SET HELPFILTER
Command en nx
SET HOURS
Command dt en
SET INDEX
SET INTENSITY
SET LIBRARY
SET LOCK
SET LOGERRORS
SET MACKEY
SET MARGIN
SET MARK OF
SET MARK TO
SET MEMOWIDTH
SET MESSAGE
SET MOUSE
SET MULTILOCKS
SET NEAR
SET NOTIFY
SET ODOMETER
Command in en
SET OPTIMIZE
Command en db nx
SET ORDER
SET PATH
SET PDSETUP
Command pr nx
SET POINT
SET PRINTER
SET PROCEDURE
SET REFRESH
SET RELATION
SET RELATION OFF
SET REPROCESS
SET RESOURCE
SET SAFETY
SET SCOREBOARD
SET SEPARATOR
SET SHADOWS
Command wi in
SET SKIP
SET SKIP OF
SET SPACE
SET STATUS
SET STEP
SET STICKY
SET SYSMENU
Command pe ex
SET TALK
Command en er
SET TEXTMERGE
Command tm fi pe nx
SET TEXTMERGE DELIMITERS
SET TOPIC
SET TRBETWEEN
Command er nx
SET TYPEAHEAD
SET UDFPARMS
SET UNIQUE
Command db ix
SET VIEW
SET WINDOW OF MEMO
SET()
SHOW GET
SHOW GETS
SHOW MENU
SHOW OBJECT
SHOW POPUP
SHOW WINDOW
SIGN()
SIN()
SIZE POPUP
SKIP
SKPBAR()
SKPPAD()
SORT
SOUNDEX()
SPACE()
SQL
SQRT()
SROWS()
STORE
STR()
STRTRAN()
STUFF()
SUBSTR()
SUM
SUSPEND
SYS()
SYS(0) Network machine #/name
SYS(1) Julian system date
SYS(2) Seconds since midnight
SYS(3) Unique file name
SYS(5) DEFAULT drive
SYS(6) PRINTER device
SYS(7) FORMAT file
SYS(9) FoxPro serial number
SYS(10) String from day number
SYS(11) Julian day number
SYS(12) Remaining memory
SYS(13) Printer status
Function pr
SYS(14) Index expression
SYS(15) Character translation
SYS(16) Executing program name
Function er en
SYS(17) Processor in use
SYS(18) Current field/object
Function er in
SYS(21) Master index number
SYS(22) Master tag/index name
SYS(23) EMS memory available
SYS(24) EMS memory limit
SYS(100) CONSOLE setting
SYS(101) DEVICE setting
SYS(102) PRINTER setting
SYS(103) TALK setting
SYS(1001) FoxPro's memory
SYS(1016) User alloc. memory
SYS(2000) File wildcard match
SYS(2001) SET command status
SYS(2002) Turn cursor on/off
SYS(2003) Current directory
SYS(2004) FoxPro's directory
SYS(2005) Resource file
SYS(2006) Graphics card
SYS(2007) Checksum
SYS(2008) Cursor shape
SYS(2009) Swap cursor shape
SYS(2010) FILES in CONFIG.SYS
SYS(2011) Lock status
Function mu nx
SYS(2012) Memo file blocksize
Function db nx
SYS(2013) System menu name
SYS(2014) Minimum path
Function fm nx
SYS(2015) Unique name
SYS(2016) SHOW GETS WINDOW
Function wi nx
SYS(2017) Show sign-on screen
Function en nx
SYS(2018) Error message
Function er nx
SYS(2019) CONFIG.FP file
SYS(2020) Disk size
SYS(2021) Filtered index expr
SYS(2022) Disk cluster size
SYS(2023) Temporary file drive
TAG()
TAN()
TARGET()
TEXT ... ENDTEXT
Command tm fi pe ex
TIME()
TOTAL
TRANSFORM()
Function ch dc in
TRIM()
TYPE
Command fm pr
TYPE()
UNLOCK
UPDATE
UPDATED()
Function db in
UPPER()
USE
Command db mu ex
USED()
USER-DEFINED FUNCTIONS (UDFs)
Function lo db in ex
VAL()
VARREAD()
VERSION()
WAIT
Command mv er pe ex
WBORDER()
WCHILD()
WCOLS()
Function wi
WEXIST()
WLAST()
WLCOL()
WLROW()
WMAXIMUM()
WMINIMUM()
WONTOP()
WOUTPUT()
WPARENT()
WREAD()
WROWS()
WTITLE()
WVISIBLE()
YEAR()
Function nu dt
ZAP
ZOOM WINDOW
Command wi in nx
SYSTEM MEMORY VARIABLES
Sysmemvar mv
_ALIGNMENT
Sysmemvar pr
_BOX
_CALCMEM
Sysmemvar da
_CALCVALUE
_CLIPTEXT
Sysmemvar en
_CUROBJ
Sysmemvar in nx
_DBLCLICK
_DIARYDATE
_FOXDOC
Sysmemvar er
_FOXGRAPH
Sysmemvar in
_GENGRAPH
_GENMENU
Sysmemvar mp pr nx
_GENPD
Sysmemvar pr nx nx
_GENSCRN
_GENXTAB
_INDENT
_LMARGIN
_MLINE
Sysmemvar db
_PADVANCE
_PAGENO
_PBPAGE
_PCOLNO
_PCOPIES
_PDRIVER
_PDSETUP
Sysmemvar pr nx
_PECODE
_PEJECT
_PEPAGE
_PLENGTH
_PLINENO
_PLOFFSET
_PPITCH
_PQUALITY
_PRETEXT
Sysmemvar tm nx
_PSCODE
_PSPACING
_PWAIT
_RMARGIN
_STARTUP
Sysmemvar pe en nx
_TABS
_TALLY
Sysmemvar db nx
_TEXT
_THROTTLE
Sysmemvar pe er nx
_WRAP
ÍÍÍÍ The FoxPro Interface ÍÍÍÍ
General in di wi me
þ 1-To-Many
Interface di
þ ASCII Chart
Interface me wi
þ About FoxPro
Interface di me
þ Add File
þ Add Screen
þ Alerts
Interface ge
þ Append
þ Append From
þ Applications
þ Associated Window
þ Attributes
þ Average
þ Box
þ Browse
þ Build Option
þ Calculate
þ Calculate Field
þ Calculator
þ Calendar/Diary
þ Capture
Interface me
þ Change
þ Character
þ Check Box
þ Choose Field/Variable
þ Code Snippet
Interface wi
þ Color Picker
þ Command
þ Comment
þ Comment Options
þ Compile
þ Copy Directory
þ Copy Files
þ Copy To
þ Count
þ Data Grouping
þ Database
þ Debug
þ Delete Directory
þ Delete Files
þ Delete Layout
þ Delete Record
þ Do
þ Edit
þ Execution Throttle
þ Expression Builder
þ Field Picker
þ File
þ File Information
þ Filer
þ Find
þ Find Files
þ Format
þ Forms
þ FoxDoc
þ FoxGraph
þ General Options
þ Generate
þ Generate Menu
þ Generate Screen
þ Goto
þ Goto Line
þ Group Info
þ Help
þ Help Topics
þ Hot Keys
Interface
þ Index
þ Invisible Button
þ Keyboard Macros
þ Label
þ Labels
þ Label Designer
þ Label Environment
þ Length
þ List
þ Load Color Set
þ Locate
þ Locate File
þ Macro Definition
þ Macro Edit
þ Make Directory
þ Menu Builder
þ Menu Options
þ Menu Shortcut
þ Move Directory
þ Move Files
þ New File
þ Navigating in the Interface
þ Open File
þ Output Destinations
þ Pack
þ Page Layout
þ Page Layout Options
þ Page Preview
þ Path
þ Popup
þ Preferences
þ Print
þ Printer Application Procs.
þ Printer Driver Setup
þ Printer Setup
þ Printer Setup Editing
þ Program
þ Project
þ Project Information
þ Prompt Options
þ Push Button
þ Puzzle
þ Queries
þ Quick Report
þ Quick Screen
þ Quit
þ RQBE
þ RQBE Display Options
þ RQBE Group By
þ RQBE Having
þ RQBE Join Condition
þ RQBE Order By
þ RQBE Select Fields
þ Radio Button
þ Recall
þ Record
þ Reindex
þ Rename Directory
þ Rename Files
þ Replace
þ Report
þ Reports
þ Report Expression
þ Report Variables
þ Report Writer
þ Restore Macros
þ Revert
þ Run
þ Save As
þ Save Color Set
þ Save Layout
þ Scope
Interface di ge
þ Screen Builder
þ Screen Color Picker
þ Screen Field
þ Screen Layout
þ Seek
þ Select Directory
þ Set Index Order
þ Setup
þ Size
þ Sort
þ Sort Files
þ Spacing
þ Special Characters
þ Specify Text
þ Stop Recording Macro
þ Structure
þ Style
þ Sum
þ Suppress Repeated Values
þ System
þ System Messages
þ Target Directory
þ Text
þ Text Editing
Interface di ge wi
þ Title/Summary
þ Total
þ Trace
þ Try It
þ Type
þ Variable Definition
þ View
þ Window