Home
Microsoft Visual FoxPro 9.0 SP2
Getting Started with Visual FoxPro
Customizing the Visual FoxPro Environment
Accessibility for People with Disabilities
Customizing Microsoft Windows for Accessibility
How to: Customize Visual FoxPro for Accessibility
Microsoft Documentation in Alternative Formats
Utilities and Resources for Enhancing Accessibility
Optimizing Your System
Optimizing the Operating Environment
Optimizing Visual FoxPro in a Multiuser Environment
Optimizing Visual FoxPro Startup Speed
Visual FoxPro Environment Settings
Automating Keystroke Tasks with Macros
How to: Clear Macro Definitions
How to: Create, Save, and Restore Macro Sets
How to: Edit Macros
How to: Record Macros
How to: Set a Default Macro Set
How to: Change Configuration Settings in the Windows Registry
How to: Configure Visual FoxPro Toolbars
How to: Create a Configuration File
How to: Display and Print Source Code in Color
How to: Dock Windows
How to: Set Editor Options
How to: Specify the Configuration File
How to: Specify the Location of Temporary Files
How to: Use Command-Line Options When Starting Visual FoxPro
How to: View and Change Environment Settings
Setting Configuration Options at Startup
Special Terms for Configuration Files
Restoring the Visual FoxPro Interactive Environment
Visual FoxPro Configuration
Installing Visual FoxPro
How to: Install Additional Applications
How to: Install Visual FoxPro
How to: Reinstall Visual FoxPro
Requirements for Installing Visual FoxPro
Troubleshooting Installation
How to: Convert Earlier Visual FoxPro Files
Locating Readme Files
Upgrading from Earlier Versions
Product Support
Copyright
Microsoft Visual FoxPro Technical Support
VFPX
Reference
Error Messages
Error Messages Listed Alphabetically
Error Messages Listed Numerically
General Reference
Building Expressions
Operating the Expression Builder
How to: Build a Function Expression
How to: Build a Variable Expression
How to: Trim and Concatenate Fields
Creating Character Expressions
Creating Date Expressions
Creating Logical Expressions
Creating Numeric Expressions
Creating Visual FoxPro Names
Macro Substitution
Name Expression Creation
Trimming and Concatenating Expressions
Using Commands and Functions
Data and Field Types
Blob Data Type
Character Data Type
Currency Data Type
Date Data Type
DateTime Data Type
Double Field Type
Float Field Type
General Field Type
Integer Field Type
Logical Data Type
Memo Field Type
Numeric Data Type
Varbinary Data Type
Varchar Field Type
Variant Data Type
Visual FoxPro and XML Schema Data Type Mapping
Visual FoxPro Data and Field Types
XML Data in Visual FoxPro
Data Manipulation
Data Transfer and Arrays
Arrays and SELECT - SQL
Data Transfer from a Table to an Array
Data Transfer from an Array to a Table
Field and Record Manipulation
FOR Clauses
Scope Clauses
WHILE Clauses
Null Value Handling
Behavior of Null Values in Commands and Functions
Behavior of Null Values in Logical Expressions
NULL as a Parameter
NULL as a Value
Class and Object Manipulation
Data Storage Containers
Constants
How to: Define a Constant
Variables
Access to Variables
Arrays
Fields
Records
File Structures
Compact Index File Structure (.idx)
Compound Index File Structure (.cdx)
File Extensions and File Types
FoxUser Resource File Structure
Index File Structure (.idx)
Macro File Format (.fky)
Memo File Structure (.FPT)
Table File Structure (.dbc, .dbf, .frx, .lbx, .mnx, .pjx, .scx, .vcx)
Table Structures of Table Files (.dbc, .frx, .lbx, .mnx, .pjx, .scx, .vcx)
Naming Conventions
Constant Naming Conventions
Object Naming Conventions
Table Field Naming Conventions
Variable Naming Conventions
Window Naming Conventions
Visual FoxPro and Other Programming Languages
Assignment Statements
Case Sensitivity
CASE Statements
Comments
FOR Loops
IF Statements
Passing Data to Parameters in Other Programming Languages
Variable Declaration
WHILE Loops
Fonts Overview
Graphics Support in Visual FoxPro
Keyboard Shortcuts
MemberData Extensibility
Regular Expressions and Operators
Reserved Words
String and Value Comparison in Visual FoxPro
System Menu Names
Visual FoxPro System Capacities
XSource Folder
Language Reference
API Library Construction
API Library Routines A-Z
_ActivateHandler( ) API Library Routine
_ActivateIdle( ) API Library Routine
_ActivateMenu( ) API Library Routine
_ALen( ) API Library Routine
_Alloca( ) API Library Routine
_AllocHand( ) API Library Routine
_AllocMemo( ) API Library Routine
_BreakPoint( ) API Library Routine
_CountItems( ) API Library Routine
_DBAppend( ) API Library Routine
_DBLock( ) API Library Routine
_DBRead( ) API Library Routine
_DBRecCount( ) API Library Routine
_DBRecNo( ) API Library Routine
_DBReplace( ) API Library Routine
_DBRewind( ) API Library Routine
_DBSeek( ) API Library Routine
_DBSkip( ) API Library Routine
_DBStatus( ) API Library Routine
_DBUnlock( ) API Library Routine
_DBUnwind( ) API Library Routine
_DBWrite( ) API Library Routine
_DeActivateHandler( ) API Library Routine
_DeActivateIdle( ) API Library Routine
_DeActivateMenu( ) API Library Routine
_DefaultProcess( ) API Library Routine
_Dialog( ) API Library Routine
_DisposeItem( ) API Library Routine
_DisposeMenu( ) API Library Routine
_EdActive( ) API Library Routine
_EdCloseFile( ) API Library Routine
_EdCopy( ) API Library Routine
_EdCut( ) API Library Routine
_EdDelete( ) API Library Routine
_EdGetChar( ) API Library Routine
_EdGetEnv( ) API Library Routine
_EdGetLineNum( ) API Library Routine
_EdGetLinePos( ) API Library Routine
_EdGetPos( ) API Library Routine
_EdGetStr( ) API Library Routine
_EdIndent( ) API Library Routine
_EdInsert( ) API Library Routine
_EdLastError( ) API Library Routine
_EdOpenFile( ) API Library Routine
_EdPaste( ) API Library Routine
_EdPosInView( ) API Library Routine
_EdRedo( ) API Library Routine
_EdRevert( ) API Library Routine
_EdSave( ) API Library Routine
_EdScrollToPos( ) API Library Routine
_EdScrollToSel( ) API Library Routine
_EdSelect( ) API Library Routine
_EdSendKey( ) API Library Routine
_EdSetEnv( ) API Library Routine
_EdSetPos( ) API Library Routine
_EdSkipLines( ) API Library Routine
_EdUndo( ) API Library Routine
_EdUndoOn( ) API Library Routine
_Error( ) API Library Routine
_ErrorInfo( ) API Library Routine
_Evaluate( ) API Library Routine
_Execute( ) API Library Routine
_FCHSize( ) API Library Routine
_FClose( ) API Library Routine
_FCopy( ) API Library Routine
_FCreate( ) API Library Routine
_FEOF( ) API Library Routine
_FError( ) API Library Routine
_FFlush( ) API Library Routine
_FGets( ) API Library Routine
_FindMemo( ) API Library Routine
_FindVar( ) API Library Routine
_FindWindow( ) API Library Routine
_FindWindowP( ) API Library Routine
_FOpen( ) API Library Routine
_FPuts( ) API Library Routine
_FRead( ) API Library Routine
_FreeHand( ) API Library Routine
_FreeObject( ) API Library Routine
_FSeek( ) API Library Routine
_FWrite( ) API Library Routine
_GetAPIHandle( ) API Library Routine
_GetHandSize( ) API Library Routine
_GetItemCmdKey( ) API Library Routine
_GetItemId( ) API Library Routine
_GetItemSubMenu( ) API Library Routine
_GetItemText( ) API Library Routine
_GetNewItemId( ) API Library Routine
_GetNewMenuId( ) API Library Routine
_GetNextEvent( ) API Library Routine
_GetObjectProperty( ) API Library Routine
_GetOSPrompt( ) API Library Routine
_GlobalToLocal( ) API Library Routine
_GlobalToLocalP( ) API Library Routine
_HandToPtr( ) API Library Routine
_HLock( ) API Library Routine
_HUnLock( ) API Library Routine
_InKey( ) API Library Routine
_Load( ) API Library Routine
_MemAvail( ) API Library Routine
_MemCmp( ) API Library Routine
_MemFill( ) API Library Routine
_MemMove( ) API Library Routine
_MemoChan( ) API Library Routine
_MemoSize( ) API Library Routine
_MenuId( ) API Library Routine
_MenuInteract( ) API Library Routine
_MousePos( ) API Library Routine
_MousePosP( ) API Library Routine
_NameTableIndex( ) API Library Routine
_NewItem( ) API Library Routine
_NewMenu( ) API Library Routine
_NewVar( ) API Library Routine
_ObjectCmp( ) API Library Routine
_ObjectReference( ) API Library Routine
_ObjectRelease( ) API Library Routine
_OnSelection( ) API Library Routine
_PutChr( ) API Library Routine
_PutStr( ) API Library Routine
_PutValue( ) API Library Routine
_Release( ) API Library Routine
_RetChar( ) API Library Routine
_RetCurrency( ) API Library Routine
_RetDateStr( ) API Library Routine
_RetDateTimeStr( ) API Library Routine
_RetFloat( ) API Library Routine
_RetInt( ) API Library Routine
_RetLogical( ) API Library Routine
_RetVal( ) API Library Routine
_SetHandSize( ) API Library Routine
_SetItemCmdKey( ) API Library Routine
_SetItemSubMenu( ) API Library Routine
_SetItemText( ) API Library Routine
_SetMenuPoint( ) API Library Routine
_SetMenuPointP( ) API Library Routine
_SetObjectProperty( ) API Library Routine
_Store( ) API Library Routine
_StrCmp( ) API Library Routine
_StrCpy( ) API Library Routine
_StrLen( ) API Library Routine
_UserError( ) API Library Routine
_WAttr( ) API Library Routine
_WBottom( ) API Library Routine
_WBottomP( ) API Library Routine
_WClear( ) API Library Routine
_WClearRect( ) API Library Routine
_WClearRectP( ) API Library Routine
_WClose( ) API Library Routine
_WFindTitle( ) API Library Routine
_WGetCursor( ) API Library Routine
_WGetCursorP( ) API Library Routine
_WGetObjectClientWindow( ) API Library Routine
_WGetObjectWindow( ) API Library Routine
_WGetPort( ) API Library Routine
_WHeight( ) API Library Routine
_WHeightP( ) API Library Routine
_WHide( ) API Library Routine
_WhToHwnd( ) API Library Routine
_WLeft( ) API Library Routine
_WLeftP( ) API Library Routine
_WMainWindow( ) API Library Routine
_WMove( ) API Library Routine
_WMoveP( ) API Library Routine
_WOnTop( ) API Library Routine
_WOpen( ) API Library Routine
_WOpenP( ) API Library Routine
_WPosCursor( ) API Library Routine
_WPosCursorP( ) API Library Routine
_WPutChr( ) API Library Routine
_WPutStr( ) API Library Routine
_WRight( ) API Library Routine
_WRightP( ) API Library Routine
_WScroll( ) API Library Routine
_WScrollP( ) API Library Routine
_WSelect( ) API Library Routine
_WSendBehind( ) API Library Routine
_WSetAttr( ) API Library Routine
_WSetPort( ) API Library Routine
_WSetTitle( ) API Library Routine
_WShow( ) API Library Routine
_WSize( ) API Library Routine
_WSizeP( ) API Library Routine
_WTitle( ) API Library Routine
_WTop( ) API Library Routine
_WTopP( ) API Library Routine
_WWidth( ) API Library Routine
_WWidthP( ) API Library Routine
_WZoom( ) API Library Routine
API Library Routines by Category
Debugging Routines
Environment Routines
Error Handling Routines
Event Handling Routines
File Input and Output Routines
Memo Field Input and Output Routines
Memory Management Routines
Menu Routines
Object Routines
Routines to Return Results to Visual FoxPro
Statement and Expression Routines
String Manipulation Routines
Table Input and Output Routines
Text Editor and Clipboard Manipulation Routines
Variable and Array Routines
Window Manipulation Routines
Visual FoxPro Key Codes (API Library Construction)
Visual FoxPro System Events (API Library Construction)
Backward-Compatible Language Elements
@ ... BOX Command
@ ... CLASS Command
@ ... CLEAR Command
@ ... EDIT - Edit Boxes Command
@ ... FILL Command
@ ... GET - Check Boxes Command
@ ... GET - Combo Boxes Command
@ ... GET - Command Buttons Command
@ ... GET - List Boxes Command
@ ... GET - Option Buttons Command
@ ... GET - Spinners Command
@ ... GET - Text Boxes Command
@ ... GET - Transparent Buttons Command
@ ... MENU Command
@ ... PROMPT Command
@ ... SAY - Pictures & OLE Objects Command
@ ... SAY Command
@ ... SCROLL Command
@ ... TO Command
_ALIGNMENT System Variable
_ASSIST System Variable
_BOX System Variable
_CUROBJ System Variable
_FOXDOC System Variable
_GENGRAPH System Variable
_GENPD System Variable
_GENSCRN System Variable
_GENXTAB System Variable
_INDENT System Variable
_LMARGIN System Variable
_PADVANCE System Variable
_PBPAGE System Variable
_PCOLNO System Variable
_PCOPIES System Variable
_PDRIVER System Variable
_PDSETUP System Variable
_PECODE System Variable
_PEJECT System Variable
_PEPAGE System Variable
_PLENGTH System Variable
_PLINENO System Variable
_PLOFFSET System Variable
_PPITCH System Variable
_PQUALITY System Variable
_PSCODE System Variable
_PSPACING System Variable
_PWAIT System Variable
_RMARGIN System Variable
_TABS System Variable
_TRANSPORT System Variable
_WRAP System Variable
ACCEPT Command
ANSITOOEM( ) Function
ASSIST Command
CALL Command
COL( ) Function
ColorScheme Property
Controls and Objects Created in Earlier Versions
CREATE SCREEN - Quick Screen Command
CREATE SCREEN Command
DEFINE BOX Command
ErrorMessage Event
FIND Command
INPUT Command
INSERT Command
JOIN Command
LOAD Command
MDOWN( ) Function
MemoWindow Property
MENU TO Command
Message Event
MODIFY SCREEN Command
OBJNUM( ) Function
OBJVAR( ) Function
OEMTOANSI( ) Function
ON KEY = Command
ON KEY Command
ON READERROR Command
OpenWindow Property
RDLEVEL( ) Function
READ Command
READ MENU Command
ReadActivate Event
ReadBackColor, ReadForeColor Properties
ReadCycle Property
ReadDeactivate Event
READKEY( ) Function
ReadLock Property
ReadMouse Property
ReadObject Property
ReadSave Property
ReadShow Event
ReadTimeout Property
ReadValid Event
ReadWhen Event
SET BORDER Command
SET BRSTATUS Command
SET CLEAR Command
SET COLOR OF Command
SET COLOR TO Command
SET DEBUG Command
SET DELIMITERS Command
SET DISPLAY Command
SET FORMAT Command
SET INTENSITY Command
SET VOLUME Command
SET WINDOW OF MEMO Command
SHOW GET Command
SHOW GETS Command
SHOW OBJECT Command
SYS(100) - Console Setting
SYS(101) - Device Setting
SYS(102) - Printer Setting
SYS(103) - Talk Setting
TerminateRead Property
UPDATE Command
UPDATED( ) Function
VARREAD( ) Function
WINDOW( ) Function
WindowList Property
WREAD( ) Function
Commands
DEFINE CLASS Command
DEFINE CLASS Command - ADD OBJECT Clause
DEFINE CLASS Command - DEFINE CLASS Clause
DEFINE CLASS Command - Function or Procedure Definition Clause
DEFINE CLASS Command - IMPLEMENTS Clause
DEFINE CLASS Command - PEMName_COMATTRIB Clause
DEFINE CLASS Command - Property Definition Clause
SELECT - SQL Command
Considerations for SQL SELECT Statements
Filter Conditions for Queries and Views
Join Conditions for Tables, Queries, and Views
SELECT - SQL Command - Additional Display Options
SELECT - SQL Command - FROM Clause
SELECT - SQL Command - GROUP BY Clause
SELECT - SQL Command - HAVING Clause
SELECT - SQL Command - INTO or TO Clause
SELECT - SQL Command - ORDER BY Clause
SELECT - SQL Command - SELECT Clause
SELECT - SQL Command - UNION Clause
SELECT - SQL Command - WHERE Clause
SELECT - SQL Command - WITH Clause
SET Command Overview
SET ALTERNATE Command
SET ANSI Command
SET ASSERTS Command
SET AUTOINCERROR Command
SET AUTOSAVE Command
SET BELL Command
SET BLOCKSIZE Command
SET BROWSEIME Command
SET CARRY Command
SET CENTURY Command
SET CLASSLIB Command
SET CLOCK Command
SET COLLATE Command
SET COLOR OF SCHEME Command
SET COLOR SET Command
SET COMPATIBLE Command
SET CONFIRM Command
SET CONSOLE Command
SET COVERAGE Command
SET CPCOMPILE Command
SET CPDIALOG Command
SET CURRENCY Command
SET CURSOR Command
SET DATABASE Command
SET DATASESSION Command
SET DATE Command
SET DEBUGOUT Command
SET DECIMALS Command
SET DEFAULT Command
SET DELETED Command
SET DEVELOPMENT Command
SET DEVICE Command
SET DIRECTORY Command
SET DOHISTORY Command
SET ECHO Command
SET ENGINEBEHAVIOR Command
SET ESCAPE Command
SET EVENTLIST Command
SET EVENTTRACKING Command
SET EXACT Command
SET EXCLUSIVE Command
SET FDOW Command
SET FIELDS Command
SET FILTER Command
SET FIXED Command
SET FULLPATH Command
SET FUNCTION Command
SET FWEEK Command
SET HEADINGS Command
SET HELP Command
SET HOURS Command
SET INDEX Command
SET KEY Command
SET KEYCOMP Command
SET LIBRARY Command
SET LOCK Command
SET LOGERRORS Command
SET MACKEY Command
SET MARGIN Command
SET MARK OF Command
SET MARK TO Command
SET MEMOWIDTH Command
SET MESSAGE Command
SET MULTILOCKS Command
SET NEAR Command
SET NOCPTRANS Command
SET NOTIFY Command
SET NULL Command
SET NULLDISPLAY Command
SET ODOMETER Command
SET OLEOBJECT Command
SET OPTIMIZE Command
SET ORDER Command
SET PALETTE Command
SET PATH Command
SET PDSETUP Command
SET POINT Command
SET PRINTER Command
SET PROCEDURE Command
SET READBORDER Command
SET REFRESH Command
SET RELATION Command
SET RELATION OFF Command
SET REPORTBEHAVIOR Command
SET REPROCESS Command
SET RESOURCE Command
SET SAFETY Command
SET SECONDS Command
SET SEPARATOR Command
SET SKIP Command
SET SKIP OF Command
SET SPACE Command
SET SQLBUFFERING Command
SET STATUS BAR Command
SET STATUS Command
SET STEP Command
SET STRICTDATE Command
SET SYSFORMATS Command
SET SYSMENU Command
SET TABLEPROMPT Command
SET TABLEVALIDATE Command
SET TALK Command
SET TEXTMERGE Command
SET TEXTMERGE DELIMITERS Command
SET TOPIC Command
SET TOPIC ID Command
SET TRBETWEEN Command
SET TYPEAHEAD Command
SET UDFPARMS Command
SET UNIQUE Command
SET VARCHARMAPPING Command
SET VIEW Command
& Command
&& Command
* Command
= Command
? | ?? Command
??? Command
\ | \\ Command
ACTIVATE MENU Command
ACTIVATE POPUP Command
ACTIVATE SCREEN Command
ACTIVATE WINDOW Command
ADD CLASS Command
ADD TABLE Command
ALTER TABLE - SQL Command
APPEND Command
APPEND FROM ARRAY Command
APPEND FROM Command
APPEND GENERAL Command
APPEND MEMO Command
APPEND PROCEDURES Command
ASSERT Command
AVERAGE Command
BEGIN TRANSACTION Command
BLANK Command
BROWSE Command
BUILD APP Command
BUILD DLL Command
BUILD EXE Command
BUILD MTDLL Command
BUILD PROJECT Command
CALCULATE Command
CANCEL Command
CD | CHDIR Command
CHANGE Command
CLEAR Commands
CLOSE Commands
CLOSE MEMO Command
COMPILE Command
CONTINUE Command
COPY FILE Command
COPY INDEXES Command
COPY MEMO Command
COPY PROCEDURES Command
COPY STRUCTURE Command
COPY STRUCTURE EXTENDED Command
COPY TAG Command
COPY TO ARRAY Command
COPY TO Command
COUNT Command
CREATE CLASS Command
CREATE CLASSLIB Command
CREATE COLOR SET Command
CREATE Command
CREATE CONNECTION Command
CREATE CURSOR - SQL Command
CREATE DATABASE Command
CREATE FORM Command
CREATE FROM Command
CREATE LABEL Command
CREATE MENU Command
CREATE PROJECT Command
CREATE QUERY Command
CREATE REPORT - Quick Report Command
CREATE REPORT Command
CREATE SQL VIEW Command
CREATE TABLE - SQL Command
CREATE TRIGGER Command
CREATE VIEW Command
DEACTIVATE MENU Command
DEACTIVATE POPUP Command
DEACTIVATE WINDOW Command
DEBUG Command
DEBUGOUT Command
DECLARE - DLL Command
DECLARE Command
DEFINE BAR Command
DEFINE MENU Command
DEFINE PAD Command
DEFINE POPUP Command
DEFINE WINDOW Command
DELETE - SQL Command
DELETE Command
DELETE CONNECTION Command
DELETE DATABASE Command
DELETE FILE Command
DELETE TAG Command
DELETE TRIGGER Command
DELETE VIEW Command
DIMENSION Command
DIR or DIRECTORY Command
DISPLAY Command
DISPLAY CONNECTIONS Command
DISPLAY DATABASE Command
DISPLAY DLLS Command
DISPLAY FILES Command
DISPLAY MEMORY Command
DISPLAY OBJECTS Command
DISPLAY PROCEDURES Command
DISPLAY STATUS Command
DISPLAY STRUCTURE Command
DISPLAY TABLES Command
DISPLAY VIEWS Command
DO CASE ... ENDCASE Command
DO Command
DO FORM Command
DO WHILE ... ENDDO Command
DOCK Command
DOEVENTS Command
DROP TABLE Command
DROP VIEW Command
EDIT Command
EJECT Command
EJECT PAGE Command
END TRANSACTION Command
ERASE Command
ERROR Command
EXIT Command
EXPORT Command
EXTERNAL Command
FLUSH Command
FOR ... ENDFOR Command
FOR EACH ... ENDFOR Command
FREE TABLE Command
FUNCTION Command
GATHER Command
GETEXPR Command
GO | GOTO Command
HELP Command
HIDE MENU Command
HIDE POPUP Command
HIDE WINDOW Command
IF ... ENDIF Command
IMPORT Command
INDEX Command
INSERT - SQL Command
KEYBOARD Command
LABEL Command
LIST Commands
LIST CONNECTIONS Command
LIST DATABASE Command
LIST DLLS Command
LIST OBJECTS Command
LIST PROCEDURES Command
LIST TABLES Command
LIST VIEWS Command
LOCAL Command
LOCATE Command
LOOP Command
LPARAMETERS Command
MD | MKDIR Command
MENU Command
MODIFY CLASS Command
MODIFY COMMAND Command
MODIFY CONNECTION Command
MODIFY DATABASE Command
MODIFY FILE Command
MODIFY FORM Command
MODIFY GENERAL Command
MODIFY LABEL Command
MODIFY MEMO Command
MODIFY MENU Command
MODIFY PROCEDURE Command
MODIFY PROJECT Command
MODIFY QUERY Command
MODIFY REPORT Command
MODIFY STRUCTURE Command
MODIFY VIEW Command
MODIFY WINDOW Command
MOUSE Command
MOVE POPUP Command
MOVE WINDOW Command
NODEFAULT Command
NOTE Command
ON BAR Command
ON ERROR Command
ON ESCAPE Command
ON EXIT BAR Command
ON EXIT MENU Command
ON EXIT PAD Command
ON EXIT POPUP Command
ON KEY LABEL Command
ON PAD Command
ON PAGE Command
ON SELECTION BAR Command
ON SELECTION MENU Command
ON SELECTION PAD Command
ON SELECTION POPUP Command
ON SHUTDOWN Command
OPEN DATABASE Command
PACK Command
PACK DATABASE Command
PARAMETERS Command
PLAY MACRO Command
POP KEY Command
POP MENU Command
POP POPUP Command
PRINTJOB ... ENDPRINTJOB Command
PRIVATE Command
PROCEDURE Command
PUBLIC Command
PUSH KEY Command
PUSH MENU Command
PUSH POPUP Command
QUIT Command
RD | RMDIR Command
READ EVENTS Command
RECALL Command
REINDEX Command
RELEASE BAR Command
RELEASE CLASSLIB Command
RELEASE Command
RELEASE LIBRARY Command
RELEASE MENUS Command
RELEASE PAD Command
RELEASE POPUPS Command
RELEASE PROCEDURE Command
RELEASE WINDOWS Command
REMOVE CLASS Command
REMOVE TABLE Command
RENAME CLASS Command
RENAME Command
RENAME CONNECTION Command
RENAME TABLE Command
RENAME VIEW Command
REPLACE Command
REPLACE FROM ARRAY Command
REPORT FORM Command
RESTORE FROM Command
RESTORE MACROS Command
RESTORE SCREEN Command
RESTORE WINDOW Command
RESUME Command
RETRY Command
RETURN Command
ROLLBACK Command
RUN | ! Command
SAVE MACROS Command
SAVE SCREEN Command
SAVE TO Command
SAVE WINDOWS Command
SCAN ... ENDSCAN Command
SCATTER Command
SCROLL Command
SEEK Command
SELECT Command
SHOW MENU Command
SHOW POPUP Command
SHOW WINDOW Command
SIZE POPUP Command
SIZE WINDOW Command
SKIP Command
SORT Command
STORE Command
SUM Command
SUSPEND Command
TEXT ... ENDTEXT Command
TOTAL Command
TRY...CATCH...FINALLY Command
TYPE Command
UNLOCK Command
UPDATE - SQL Command
USE Command
VALIDATE DATABASE Command
WAIT Command
WITH ... ENDWITH Command
ZAP Command
ZOOM WINDOW Command
Events
Activate Event
AdjustObjectSize Event
AfterBand Event
AfterBuild Event
AfterCloseTables Event
AfterCursorAttach Event
AfterCursorClose Event
AfterCursorDetach Event
AfterCursorFill Event
AfterCursorRefresh Event
AfterCursorUpdate Event
AfterDelete Event
AfterDock Event
AfterInsert Event
AfterRecordRefresh Event
AfterReport Event
AfterRowColChange Event
AfterUpdate Event
BeforeBand Event
BeforeBuild Event
BeforeCursorAttach Event
BeforeCursorClose Event
BeforeCursorDetach Event
BeforeCursorFill Event
BeforeCursorRefresh Event
BeforeCursorUpdate Event
BeforeDelete Event
BeforeDock Event
BeforeInsert Event
BeforeOpenTables Event
BeforeRecordRefresh Event
BeforeReport Event
BeforeRowColChange Event
BeforeUpdate Event
Click Event
dbc_Activate Event
dbc_AfterAddRelation Event
dbc_AfterAddTable Event
dbc_AfterAppendProc Event
dbc_AfterCloseTable Event
dbc_AfterCopyProc Event
dbc_AfterCreateConnection Event
dbc_AfterCreateOffline Event
dbc_AfterCreateTable Event
dbc_AfterCreateView Event
dbc_AfterDBGetProp Event
dbc_AfterDBSetProp Event
dbc_AfterDeleteConnection Event
dbc_AfterDropOffline Event
dbc_AfterDropRelation Event
dbc_AfterDropTable Event
dbc_AfterDropView Event
dbc_AfterModifyConnection Event
dbc_AfterModifyProc Event
dbc_AfterModifyTable Event
dbc_AfterModifyView Event
dbc_AfterOpenTable Event
dbc_AfterRemoveTable Event
dbc_AfterRenameConnection Event
dbc_AfterRenameTable Event
dbc_AfterRenameView Event
dbc_AfterValidateData Event
dbc_BeforeAddRelation Event
dbc_BeforeAddTable Event
dbc_BeforeAppendProc Event
dbc_BeforeCloseTable Event
dbc_BeforeCopyProc Event
dbc_BeforeCreateConnection Event
dbc_BeforeCreateOffline Event
dbc_BeforeCreateTable Event
dbc_BeforeCreateView Event
dbc_BeforeDBGetProp Event
dbc_BeforeDBSetProp Event
dbc_BeforeDeleteConnection Event
dbc_BeforeDropOffline Event
dbc_BeforeDropRelation Event
dbc_BeforeDropTable Event
dbc_BeforeDropView Event
dbc_BeforeModifyConnection Event
dbc_BeforeModifyProc Event
dbc_BeforeModifyTable Event
dbc_BeforeModifyView Event
dbc_BeforeOpenTable Event
dbc_BeforeRemoveTable Event
dbc_BeforeRenameConnection Event
dbc_BeforeRenameTable Event
dbc_BeforeRenameView Event
dbc_BeforeValidateData Event
dbc_CloseData Event
dbc_Deactivate Event
dbc_ModifyData Event
dbc_OpenData Event
dbc_PackData Event
DblClick Event
Deactivate Event
Deleted Event
Destroy Event
DownClick Event
DragDrop Event
DragOver Event
DropDown Event
Error Event
EvaluateContents Event
GotFocus Event
Init Event
InteractiveChange Event
KeyPress Event
Load Event
LoadReport Event
LostFocus Event
MiddleClick Event
MouseDown Event
MouseEnter Event
MouseLeave Event
MouseMove Event
MouseUp Event
MouseWheel Event
Moved Event
OLECompleteDrag Event
OLEDragDrop Event
OLEDragOver Event
OLEGiveFeedback Event
OLESetData Event
OLEStartDrag Event
OnMoveItem Event
Paint Event
ProgrammaticChange Event
QueryAddFile Event
QueryModifyFile Event
QueryNewFile Event
QueryRemoveFile Event
QueryRunFile Event
QueryUnload Event
RangeHigh Event
RangeLow Event
Resize Event
RightClick Event
SCCDestroy Event
SCCInit Event
Scrolled Event
Timer Event
UIEnable Event
UnDock Event
Unload Event
UnloadReport Event
UpClick Event
Valid Event
When Event
Functions
SYS( ) Functions Overview
SYS(0) - Network Machine Information
SYS(1) - Julian System Date
SYS(10) - String from Julian Day Number
SYS(1001) - Visual FoxPro Memory
SYS(1011) - Number of Memory Handles
SYS(1016) - User Object Memory Use
SYS(1023) - Enable Help Diagnostic Mode
SYS(1024) - Disable Help Diagnostic Mode
SYS(1037) - Page Setup Dialog Box
SYS(11) - Julian Day Number
SYS(1104) - Purge Memory Cache
SYS(12) - Available Memory in Bytes
SYS(1269) - Property Information
SYS(1270) - Object Location
SYS(1271) - Object's .SCX File
SYS(1272) - Object Hierarchy
SYS(13) - Printer Status
SYS(14) - Index Expression
SYS(15) - Character Translation
SYS(1500) - Activate a System Menu Item
SYS(16) - Executing Program File Name
SYS(17) - Processor in Use
SYS(18) - Current Control
SYS(2) - Seconds Since Midnight
SYS(20) - Transform German Text
SYS(2000) - File Name Wildcard Match
SYS(2001) - SET ... Command Status
SYS(2002) - Turn Insertion Point On or Off
SYS(2003) - Current Directory
SYS(2004) - Visual FoxPro Start Directory
SYS(2005) - Current Resource File
SYS(2006) - Current Graphics Card
SYS(2007) - Checksum Value
SYS(2010) - CONFIG.SYS File Settings
SYS(2011) - Current Lock Status
SYS(2012) - Memo Field Blocksize
SYS(2013) - System Menu Name String
SYS(2014) - Minimum Path
SYS(2015) - Unique Procedure Name
SYS(2016) - SHOW GETS WINDOW Name
SYS(2017) - Record Checksum Value
SYS(2018) - Error Message Parameter
SYS(2019) - Configuration File Name and Location
SYS(2020) - Default Disk Free Space
SYS(2021) - Filtered Index Expression
SYS(2022) - Disk Cluster Size
SYS(2023) - Temporary Path
SYS(2024) - Detect Report Cancellation
SYS(2029) - Table Type
SYS(2030) - Debug
SYS(2040) - Detect Report Status
SYS(2060) - Mouse Wheel Events
SYS(21) - Controlling Index Number
SYS(22) - Controlling Tag or Index Name
SYS(23) - FoxPro EMS Memory Usage
SYS(2300) - Add or Remove Code Page
SYS(2325) - WCLIENTWINDOW from Visual FoxPro WHANDLE
SYS(2326) - WHANDLE from a Window's hWnd
SYS(2327) - Window's hWnd from Visual FoxPro WHANDLE
SYS(2333) - ActiveX Dual Interface Support
SYS(2334) - Automation Server Invocation Mode
SYS(2335) - Unattended Server Mode
SYS(2336) - Critical Section support
SYS(2339) - Call CoFreeUnusedLibraries when COM object is released
SYS(2340) - NT Service Support
SYS(24) - EMS Memory Limit
SYS(2410) - Error Handler
SYS(2450) - Application Search Path Order
SYS(2600) - Return Pointer as String
SYS(2700) - Enables Windows XP Themes
SYS(2800) - Accessibility Support
SYS(2801) - Event Tracking Support
SYS(2910) - List Display Count
SYS(3) - Legal File Name
SYS(3004) - Return Locale ID
SYS(3005) - Set Locale ID
SYS(3006) - Set Language and Locale IDs
SYS(3007) - ToolTipText Property Font Language Script
SYS(3008) - Hyperlink Tooltips
SYS(3009) - Bidirectional Text Justification for ToolTips
SYS(3050) - Set Buffer Memory Size
SYS(3051) - Set Lock Retry Interval
SYS(3052) - Override SET REPROCESS Locking
SYS(3053) - ODBC Environment Handle
SYS(3054) - Rushmore Query Optimization Level
SYS(3055) - FOR and WHERE Clause Complexity
SYS(3056) - Read Registry Settings
SYS(3065) - Internal Program Cache
SYS(3092) - Output Rushmore Query Optimization Level
SYS(3095) - IDispatch Pointer
SYS(3096) - IDispatch Object Reference
SYS(3097) - Add Reference to Object
SYS(3098) - Release Object reference
SYS(3099) - SQL Data Engine Compatibility Mode
SYS(3101) - COM Code Page Translation
SYS(5) - Default Drive
SYS(6) - Current Printer Device
SYS(602) - Bitmap Configuration
SYS(7) - Current Format File
SYS(9) - Visual FoxPro Serial Number
SYS(987) - Map Remote Data to ANSI
$ Operator
% Operator
:: Scope Resolution Operator
ABS( ) Function
ACLASS( ) Function
ACOPY( ) Function
ACOS( ) Function
ADATABASES( ) Function
ADBOBJECTS( ) Function
ADDBS( ) Function
ADDPROPERTY( ) Function
ADEL( ) Function
ADIR( ) Function
ADLLS( ) Function
ADOCKSTATE( ) Function
AELEMENT( ) Function
AERROR( ) Function
AEVENTS( ) Function
AFIELDS( ) Function
AFONT( ) Function
AGETCLASS( ) Function
AGETFILEVERSION( ) Function
AINS( ) Function
AINSTANCE( ) Function
ALANGUAGE( ) Function
ALEN( ) Function
ALIAS( ) Function
ALINES( ) Function
ALLTRIM( ) Function
AMEMBERS( ) Function
AMOUSEOBJ( ) Function
ANETRESOURCES( ) Function
APRINTERS( ) Function
APROCINFO( ) Function
ASC( ) Function
ASCAN( ) Function
ASELOBJ( ) Function
ASESSIONS( ) Function
ASIN( ) Function
ASORT( ) Function
ASQLHANDLES( ) Function
ASTACKINFO( ) Function
ASUBSCRIPT( ) Function
AT( ) Function
AT_C( ) Function
ATAGINFO( ) Function
ATAN( ) Function
ATC( ) Function
ATCC( ) Function
ATCLINE( ) Function
ATLINE( ) Function
ATN2( ) Function
AUSED( ) Function
AVCXCLASSES( ) Function
BAR( ) Function
BARCOUNT( ) Function
BARPROMPT( ) Function
BETWEEN( ) Function
BINDEVENT( ) Function
BINTOC( ) Function
BITAND( ) Function
BITCLEAR( ) Function
BITLSHIFT( ) Function
BITNOT( ) Function
BITOR( ) Function
BITRSHIFT( ) Function
BITSET( ) Function
BITTEST( ) Function
BITXOR( ) Function
BOF( ) Function
CANDIDATE( ) Function
CAPSLOCK( ) Function
CAST( ) Function
CDOW( ) Function
CDX( ) Function
CEILING( ) Function
Character Functions
CHR( ) Function
CHRSAW( ) Function
CHRTRAN( ) Function
CHRTRANC( ) Function
CLEARRESULTSET( ) Function
CMONTH( ) Function
CNTBAR( ) Function
CNTPAD( ) Function
COM Functions
COMARRAY( ) Function
COMCLASSINFO( ) Function
COMPOBJ( ) Function
COMPROP( ) Function
COMRETURNERROR( ) Function
COS( ) Function
CPCONVERT( ) Function
CPCURRENT( ) Function
CPDBF( ) Function
CREATEBINARY( ) Function
CREATEOBJECT( ) Function
CREATEOBJECTEX( ) Function
CREATEOFFLINE( ) Function
CTOBIN( ) Function
CTOD( ) Function
CTOT( ) Function
CURDIR( ) Function
CURSORGETPROP( ) Function
CURSORSETPROP( ) Function
CURSORTOXML( ) Function
CURVAL( ) Function
Data Conversion Functions
Date and Time Functions
DATE( ) Function
DATETIME( ) Function
DAY( ) Function
DBALIAS( ) Function
DBC( ) Function
DBF( ) Function
DBGETPROP( ) Function
DBSETPROP( ) Function
DBUSED( ) Function
DDE Functions
DDEAbortTrans( ) Function
DDEAdvise( ) Function
DDEEnabled( ) Function
DDEExecute( ) Function
DDEInitiate( ) Function
DDELastError( ) Function
DDEPoke( ) Function
DDERequest( ) Function
DDESetOption( ) Function
DDESetService( ) Function
DDESetTopic( ) Function
DDETerminate( ) Function
DEFAULTEXT( ) Function
DELETED( ) Function
DESCENDING( ) Function
DIFFERENCE( ) Function
DIRECTORY( ) Function
DISKSPACE( ) Function
DisplayPath( ) Function
DMY( ) Function
DODEFAULT( ) Function
DOW( ) Function
DRIVETYPE( ) Function
DROPOFFLINE( ) Function
DTOC( ) Function
DTOR( ) Function
DTOS( ) Function
DTOT( ) Function
EDITSOURCE( ) Function
EMPTY( ) Function
EOF( ) Function
ERROR( ) Function
EVALUATE( ) Function
EVENTHANDLER( ) Function
EVL( ) Function
EXECSCRIPT( ) Function
EXP( ) Function
FCHSIZE( ) Function
FCLOSE( ) Function
FCOUNT( ) Function
FCREATE( ) Function
FDATE( ) Function
FEOF( ) Function
FERROR( ) Function
FFLUSH( ) Function
FGETS( ) Function
FIELD( ) Function
FILE( ) Function
FILETOSTR( ) Function
FILTER( ) Function
FKLABEL( ) Function
FKMAX( ) Function
FLDCOUNT( ) function
FLDLIST( ) Function
FLOCK( ) Function
FLOOR( ) Function
FONTMETRIC( ) Function
FOPEN( ) Function
FOR( ) Function
FORCEEXT( ) Function
FORCEPATH( ) Function
FOUND( ) Function
FPUTS( ) Function
FREAD( ) Function
FSEEK( ) Function
FSIZE( ) Function
FTIME( ) Function
FULLPATH( ) Function
FV( ) Function
FWRITE( ) Function
GETAUTOINCVALUE( ) Function
GETBAR( ) Function
GETCOLOR( ) Function
GETCP( ) Function
GETCURSORADAPTER( ) Function
GETDIR( ) Function
GETENV( ) Function
GETFILE( ) Function
GETFLDSTATE( ) Function
GETFONT( ) Function
GETINTERFACE( ) Function
GETNEXTMODIFIED( ) Function
GETOBJECT( ) Function
GETPAD( ) Function
GETPEM( ) Function
GETPICT( ) Function
GETPRINTER( ) Function
GETRESULTSET( ) Function
GETWORDCOUNT( ) Function
GETWORDNUM( ) Function
GOMONTH( ) Function
HEADER( ) Function
HOME( ) Function
HOUR( ) Function
ICASE( ) Function
ID( ) Function - Network Machine Information
IDXCOLLATE( ) Function
IIF( ) Function
IMESTATUS( ) Function
INDBC( ) Function
INDEXSEEK( ) Function
INKEY( ) Function
INLIST( ) Function
INPUTBOX( ) Function
INSMODE( ) Function
INT( ) Function
ISALPHA( ) Function
ISBLANK( ) Function
ISCOLOR( ) Function
ISDIGIT( ) Function
ISEXCLUSIVE( ) Function
ISFLOCKED( ) Function
ISLEADBYTE( ) Function
ISLOWER( ) Function
ISMEMOFETCHED( ) Function
ISMOUSE( ) Function
ISNULL( ) Function
ISPEN( ) Function
ISREADONLY( ) Function
ISRLOCKED( ) Function
ISTRANSACTABLE( ) Function
ISUPPER( ) Function
JUSTDRIVE( ) Function
JUSTEXT( ) Function
JUSTFNAME( ) Function
JUSTPATH( ) Function
JUSTSTEM( ) Function
KEY( ) Function
KEYMATCH( ) Function
LASTKEY( ) Function
LEFT( ) Function
LEFTC( ) Function
LEN( ) Function
LENC( ) Function
LIKE( ) Function
LIKEC( ) Function
LINENO( ) Function
LOADPICTURE( ) Function
LOCFILE( ) Function
LOCK( ) Function
LOG( ) Function
LOG10( ) Function
LOOKUP( ) Function
LOWER( ) Function
LTRIM( ) Function
LUPDATE( ) Function
MAKETRANSACTABLE( ) Function
MAX( ) Function
MCOL( ) Function
MDX( ) Function
MDY( ) Function
MEMLINES( ) Function
MEMORY( ) Function
MENU( ) Function
MESSAGE( ) Function
MESSAGEBOX( ) Function
MIN( ) Function
MINUTE( ) Function
MLINE( ) Function
MOD( ) Function
MONTH( ) Function
MRKBAR( ) Function
MRKPAD( ) Function
MROW( ) Function
MTON( ) Function
MWINDOW( ) Function
NDX( ) Function
NEWOBJECT( ) Function
NORMALIZE( ) Function
NTOM( ) Function
Numeric Functions
NUMLOCK( ) Function
NVL( ) Function
OBJTOCLIENT( ) Function
OCCURS( ) Function
OLDVAL( ) Function
ON( ) Function
ORDER( ) Function
OS( ) Function
PAD( ) Function
PADL( ) | PADR( ) | PADC( ) Functions
PADPROMPT( ) Function
PARAMETERS( ) Function
PAYMENT( ) Function
PCOL( ) Function
PCOUNT( ) Function
PEMSTATUS( ) Function
PI( ) Function
POPUP( ) Function
PRIMARY( ) Function
PRINTSTATUS( ) Function
PRMBAR( ) Function
PRMPAD( ) Function
PROGRAM( ) Function
PROMPT( ) Function
PROPER( ) Function
PROW( ) Function
PRTINFO( ) Function
PUTFILE( ) Function
PV( ) Function
QUARTER( ) Function
RAISEEVENT( ) Function
RAND( ) Function
RAT( ) Function
RATC( ) Function
RATLINE( ) Function
RECCOUNT( ) Function
RECNO( ) Function
RECSIZE( ) Function
REFRESH( ) Function
RELATION( ) Function
REMOVEPROPERTY( ) Function
REPLICATE( ) Function
REQUERY( ) Function
RGB( ) Function
RGBSCHEME( ) Function
RIGHT( ) Function
RIGHTC( ) Function
RLOCK( ) Function
ROUND( ) Function
ROW( ) Function
RTOD( ) Function
RTRIM( ) Function
SAVEPICTURE( ) Function
SCHEME( ) Function
SCOLS( ) Function
SEC( ) Function
SECONDS( ) Function
SEEK( ) Function
SELECT( ) Function
SET( ) Function
SETFLDSTATE( ) Function
SETRESULTSET( ) Function
SIGN( ) Function
SIN( ) Function
SKPBAR( ) Function
SKPPAD( ) Function
SOUNDEX( ) Function
SPACE( ) Function
SQLCANCEL( ) Function
SQLCOLUMNS( ) Function
SQLCOMMIT( ) Function
SQLCONNECT( ) Function
SQLDISCONNECT( ) Function
SQLEXEC( ) Function
SQLGETPROP( ) Function
SQLIDLEDISCONNECT( ) Function
SQLMORERESULTS( ) Function
SQLPREPARE( ) Function
SQLROLLBACK( ) Function
SQLSETPROP( ) Function
SQLSTRINGCONNECT( ) Function
SQLTABLES( ) Function
SQRT( ) Function
SROWS( ) Function
STR( ) Function
STRCONV( ) Function
STREXTRACT( ) Function
STRTOFILE( ) Function
STRTRAN( ) Function
STUFF( ) Function
STUFFC( ) Function
SUBSTR( ) Function
SUBSTRC( ) Function
SYSMETRIC( ) Function
TABLEREVERT( ) Function
TABLEUPDATE( ) Function
TAG( ) Function
TAGCOUNT( ) Function
TAGNO( ) Function
TAN( ) Function
TARGET( ) Function
TEXTMERGE( ) Function
TIME( ) Function
TRANSFORM( ) Function
TRIM( ) Function
TTOC( ) Function
TTOD( ) Function
TXNLEVEL( ) Function
TXTWIDTH( ) Function
TYPE( ) Function
UNBINDEVENTS( ) Function
UNIQUE( ) Function
UPPER( ) Function
USED( ) Function
VAL( ) Function
VARTYPE( ) Function
VERSION( ) Function
WBORDER( ) Function
WCHILD( ) Function
WCOLS( ) Function
WDOCKABLE( ) Function
WEEK( ) Function
WEXIST( ) Function
WFONT( ) Function
WLAST( ) Function
WLCOL( ) Function
WLROW( ) Function
WMAXIMUM( ) Function
WMINIMUM( ) Function
WONTOP( ) Function
WOUTPUT( ) Function
WPARENT( ) Function
WROWS( ) Function
WTITLE( ) Function
WVISIBLE( ) Function
XML Functions
XMLTOCURSOR( ) Function
XMLUPDATEGRAM( ) Function
YEAR( ) Function
Language Categories
Databases
Database Manipulation Language
Field Manipulation Language
Index Manipulation Language
Record Manipulation Language
Relation Manipulation Language
Table Manipulation Language
Input and Output
Data Formatting Language
Keyboard and Mouse Input
Menus and Menu Bars
Printing
Reports and Labels
Windows Commands and Functions
Programming
Array Manipulation
Debugging and Error-Handling Language
Event Handlers
Low-Level File Functions
Object-Oriented Programming Commands and Functions
Program Execution
Structured Programming
System Variables
Variable Manipulation
Shared Access to Data
Commands that Scope to a Data Session
Shared Access to Data Commands and Functions
Visual FoxPro Environment
Environment
File Management
Language Reference for OLE DB Development
Standard and Custom OLE DB Properties
Supported OLE DB Objects
Supported Visual FoxPro Commands and Functions in OLE DB Provider
Unsupported Visual FoxPro Commands and Functions in OLE DB Provider
Visual FoxPro OLE DB Provider Data Support
Methods
ActivateCell Method
Add Method (Collection Class)
Add Method (File Object)
AddColumn Method
AddItem Method
AddListItem Method
AddObject Method
AddProperty Method
AddTableSchema Method
AddToSCC Method
ApplyDiffgram Method
Attach Method
AutoFit Method
AutoOpen Method
Box Method
Build Method
CancelReport Method
ChangesToCursor Method
CheckIn Method
CheckOut Method
Circle Method
Class Browser Methods
CleanUp Method
Clear Method
ClearData Method
ClearStatus Method
CloneObject Method
Close Method
CloseTables Method
Cls Method
CursorAttach Method
CursorDetach Method
CursorFill Method
CursorRefresh Method
DataToClip Method
DelayedMemoFetch Method
DeleteColumn Method
Dock Method
DoCmd Method
DoMessage Method
DoScroll Method
DoStatus Method
DoVerb Method
Drag Method
Draw Method
Eval Method
GetData Method
GetDockState Method
GetFormat Method
GetKey Method
GetLatestVersion Method
GetPageHeight Method
GetPageWidth Method
GridHitTest Method
Help Method
Hide Method
IncludePageInOutput Method
IndexToItemID Method
Item Method (Collection Class)
Item Method (File Object)
ItemIDToIndex Method
Line Method
LoadXML Method
Modify Method
Move Method
MoveItem Method
Nest Method
NewObject Method
OLEDrag Method
OnPreviewClose Method
OpenTables Method
OutputPage Method
Point Method
Print Method
PrintCachedPages Method
PSet Method
Quit Method
ReadExpression Method
ReadMethod Method
RecordRefresh Method
Refresh Method
Release Method
ReleaseXML Method
Remove Method (Collection Class)
Remove Method (File Object)
RemoveFromSCC Method
RemoveItem Method
RemoveListItem Method
RemoveObject Method
Render Method
Requery Method
RequestData Method
Reset Method
ResetToDefault Method
Run Method
SaveAs Method
SaveAsClass Method
SetAll Method
SetData Method
SetFocus Method
SetFormat Method
SetMain Method
SetVar Method
SetViewPort Method
Show Method
ShowWhatsThis Method
SupportsListenerType Method
TextHeight Method
TextWidth Method
ToCursor Method
ToXML Method
UndoCheckOut Method
Unnest Method
UpdateStatus Method
WhatsThisMode Method
WriteExpression Method
WriteMethod Method
ZOrder Method
Objects, Collections, and Classes
Application Object
Application Object Properties, Methods, and Events
CheckBox Control
CheckBox Control Properties, Methods, and Events
Collection Class
Collection Object Properties, Methods, and Events
Column Object
Column Object Properties, Methods, and Events
ComboBox Control
ComboBox Control Properties, Methods, and Events
CommandButton Control
CommandButton Control Properties, Methods, and Events
CommandGroup Control
CommandGroup Control Properties, Methods, and Events
Container Object
Container Object Properties, Methods, and Events
Control Object
Control Object Properties, Methods, and Events
Cursor Object
Cursor Object Properties, Methods, and Events
CursorAdapter Class
CursorAdapter Object Properties, Methods, and Events
Custom Object
Custom Object Properties, Methods, and Events
DataEnvironment Object
DataEnvironment Object Properties, Methods, and Events
DataObject Object
DataObject Object Properties, Methods, and Events
EditBox Control
EditBox Control Properties, Methods, and Events
Exception Class
Exception Object Properties, Methods, and Events
File Object
File Object Properties, Methods, and Events
Files Collection
Files Collection Properties and Methods
Form Object
Form Object Properties, Methods, and Events
FormSet Object
FormSet Object Properties, Methods, and Events
Grid Control
Grid Control Properties, Methods, and Events
Header Object
Header Object Properties, Methods, and Events
Hyperlink Object
Hyperlink Object Properties, Methods, and Events
Image Control
Image Control Properties, Methods, and Events
Label Control
Label Control Properties, Methods, and Events
Line Control
Line Control Properties, Methods, and Events
ListBox Control
ListBox Control Properties, Methods, and Events
OLE Bound Control
OLE Bound Control Properties, Methods, and Events
OLE Container Control
OLE Container Control Properties, Methods, and Events
OptionButton Control
OptionButton Control Properties, Methods, and Events
OptionGroup Control
OptionGroup Control Properties, Methods, and Events
Page Object
Page Object Properties, Methods, and Events
PageFrame Control
PageFrame Control Properties, Methods, and Events
Project Object
Project Object Properties, Methods, and Events
ProjectHook Object
ProjectHook Object Properties, Methods, and Events
Projects Collection
Projects Collection Properties, Methods, and Events
Relation Object
Relation Object Properties, Methods, and Events
ReportListener Object
ReportListener Object Properties, Methods, and Events
Separator Object
Separator Object Properties, Methods, and Events
Server Object
Server Object Properties, Methods, and Events
Servers Collection
Servers Collection Properties, Methods, and Events
Session Object
Session Object Properties, Methods, and Events
Shape Control
Shape Control Properties, Methods, and Events
Spinner Control
Spinner Control Properties, Methods, and Events
TextBox Control
TextBox Control Properties, Methods, and Events
Timer Control
Timer Control Properties, Methods, and Events
ToolBar Object
ToolBar Object Properties, Methods, and Events
Visual FoxPro Foundation Classes A-Z
GDI Plus API Wrapper Foundation Classes
GDI Plus Base Foundation Class
GDI Plus Bitmap Foundation Class
GDI Plus Brush Foundation Class
GDI Plus Color Foundation Class
GDI Plus Font Foundation Class
GDI Plus FontFamily Foundation Class
GDI Plus Graphics Foundation Class
GDI Plus HatchBrush Foundation Class
GDI Plus Image Foundation Class
GDI Plus Object Foundation Class
GDI Plus Pen Foundation Class
GDI Plus Point Foundation Class
GDI Plus Rectangle Foundation Class
GDI Plus Size Foundation Class
GDI Plus SolidBrush Foundation Class
GDI Plus StringFormat Foundation Class
ReportListener Foundation Classes
ReportListener Base Foundation Class
ReportListener Debug Foundation Class
ReportListener FXListener Foundation Class
ReportListener HTML Foundation Class
ReportListener User Feedback Foundation Class
ReportListener Utility and File-handling Foundation Class
ReportListener XML Display-Style Foundation Class
ReportListener XML Foundation Class
About Dialog Box Foundation Class
ActiveX Calendar Foundation Class
Application Registry Foundation Class
Array Handler Foundation Class
Cancel Button Foundation Class
Clock Foundation Class
Common Dialog Box Foundation Class
Common System Folders Foundation Class
Conflict Catcher Foundation Class
Cookies Foundation Class
Cross Tab Foundation Class
Crypto API Foundation Class
Data Edit Buttons Foundation Class
Data Navigation Buttons Foundation Class
Data Navigation Object Foundation Class
Data Session Manager Foundation Class
Data Validation Foundation Class
DBF to HTML Foundation Class
Distinct Values Combo Foundation Class
Error Object Foundation Class
Field Mover Foundation Class
File Version Foundation Class
Filter Dialog Box Button Foundation Class
Filter Dialog Box Foundation Class
Filter Expression Dialog Box Foundation Class
Find (Findnext) Buttons Foundation Class
Find Button Foundation Class
Find Dialog Box Foundation Class
Find Files/Text Foundation Class
Find Object Foundation Class
Font Combobox Foundation Class
Fontsize Combobox Foundation Class
Format Toolbar Foundation Class
FRX Cursor Foundation Class
FRX Device Helper Foundation Class
FRX to HTML Foundation Class
Get File and Directory Foundation Class
GoTo Dialog Box Button Foundation Class
GoTo Dialog Box Foundation Class
Graph By Record Foundation Class
Graph Object Foundation Class
Help Button Foundation Class
Hyperlink Button Foundation Class
Hyperlink Image Foundation Class
Hyperlink Label Foundation Class
INI Access Foundation Class
Item Locator Foundation Class
Keywords Dialog Box Foundation Class
Launch Button Foundation Class
Locate Button Foundation Class
Lookup Combobox Foundation Class
Mail Merge Object Foundation Class
Messagebox Handler Foundation Class
Microsoft Agent Utility Foundation Class
MouseOver Effects Foundation Class
Mover Foundation Class
Navigation Shortcut Menu Foundation Class
Navigation Toolbar Foundation Class
Object State Foundation Class
ODBC Registry Foundation Class
Offline Switch Foundation Class
OK Button Foundation Class
Output Control Foundation Class
Output Dialog Box Foundation Class
Output Object Foundation Class
Password Dialog Box Foundation Class
Pivot Table Foundation Class
Pool Manager Foundation Class
Preview Report Foundation Class
QBF Foundation Class
Registry Access Foundation Class
Regular Expressions Foundation Class
Resize Object Foundation Class
RTF Controls Foundation Class
Run Form Button Foundation Class
SCX to HTML Foundation Class
SendMail Buttons Foundation Class
SetAllX Extension Foundation Class
Shell Execute Foundation Class
Shortcut Menu Class Foundation Class
Simple Edit Buttons Foundation Class
Simple Navigation Buttons Foundation Class
Simple Picture Navigation Buttons Foundation Class
Sort Dialog Box Button Foundation Class
Sort Dialog Box Foundation Class
Sort Mover Foundation Class
Sort Object Foundation Class
Sort Selector Foundation Class
Sound Player Foundation Class
Splash Screen Foundation Class
SQL Pass Through Foundation Class
Stop Watch Foundation Class
String Library Foundation Class
Super Mover Foundation Class
System Metrics Foundation Class
System Toolbar Foundation Class
Table Mover Foundation Class
Text Preview Foundation Class
Thermometer Foundation Class
Trace Aware Timer Foundation Class
Type Library Foundation Class
URL Combo Foundation Class
URL Open Dialog Box Foundation Class
User Privileges Foundation Class
VCR Buttons Foundation Class
VCR Picture Navigation Buttons Foundation Class
Video Player Foundation Class
Web Browser Control Foundation Class
Window Handler Foundation Class
XML Web Services Foundation Classes
XMLAdapter Class
XMLAdapter Object Properties, Methods, and Events
XMLField Class
XMLField Object Properties, Methods, and Events
XMLTable Class
XMLTable Object Properties, Methods, and Events
Class Browser Object Members
Empty Class
Fields Collection (XMLTable)
FoxCode Object Reference
Member Classes
Objects Collection
Parent Object Reference
Tables Collection (XMLAdapter)
THIS Object Reference
THISFORM Object Reference
THISFORMSET Object Reference
Operators
Character Operators
Date and Time Operators
Logical Operators
Numeric Operators
Relational Operators
Preprocessor Directives
#DEFINE ... #UNDEF Preprocessor Directive
#IF ... #ENDIF Preprocessor Directive
#IFDEF | #IFNDEF ... #ENDIF Preprocessor Directive
#INCLUDE Preprocessor Directive
#INSERT Preprocessor Directive
#NAME Preprocessor Directive
Coverage Preprocessor Directives
Properties
_MemberData Property
ActiveColumn Property
ActiveControl Property
ActiveForm Property
ActivePage Property
ActiveProject Property
ActiveRow Property
AddLineFeeds Property
ADOCodePage Property
Alias Property
Align Property
Alignment Property
AllowAddNew Property
AllowAutoColumnFit Property
AllowCellSelection Property
AllowDelete Property
AllowHeaderSizing Property
AllowInsert Property
AllowModalMessages Property
AllowOutput Property
AllowRowSizing Property
AllowSimultaneousFetch Property
AllowTabs Property
AllowUpdate Property
AlwaysOnBottom Property
AlwaysOnTop Property
Anchor Property
Application Property
AutoActivate Property
AutoCenter Property
AutoCloseTables Property
AutoComplete Property
AutoCompSource Property
AutoCompTable Property
AutoHideScrollBar Property
AutoIncrement Property
AutoOpenTables Property
AutoRelease Property
AutoSize Property
AutoVerbMenu Property
AutoYield Property
BackColor, ForeColor Properties
BackStyle Property
BaseClass Property
BatchUpdateCount Property
BindControls Property
BorderColor Property
BorderStyle Property
BorderWidth Property
Bound Property
BoundColumn Property
BoundTo Property
BreakOnError Property
BufferMode Property
BufferModeOverride Property
BuildDateTime Property
ButtonCount Property
Buttons Property
CallAdjustObjectSize Property
CallEvaluateContents Property
Cancel Property
Caption Property
Centered Property
Century Property
ChildAlias Property
ChildOrder Property
ChildTable Property
Class Browser Properties
Class Property
ClassLibrary Property
ClipControls Property
Closable Property
CLSID Property
CodePage Property
ColorSource Property
ColumnCount Property
ColumnLines Property
ColumnOrder Property
Columns Property
ColumnWidths Property
CommandClauses Property
Comment Property
CompareMemo Property
ConflictCheckCmd Property
ConflictCheckType Property
ContinuousScroll Property
ControlBox Property
ControlCount Property
Controls Property
ControlSource Property
ConversionFunc Property
Count Property
CurrentControl Property
CurrentDataSession Property
CurrentPass Property
CurrentX, CurrentY Properties
CursorSchema Property
CursorSource Property
CursorStatus Property
Curvature Property
Database Property
DataEnvironment Property
DataSession Property
DataSessionID Property
DataSource Property
DataSourceType Property
DataType Property
DateFormat Property
DateMark Property
Debug Property
DeclareXMLPrefix Property
DEClass Property
DEClassLibrary Property
Default Property
DefaultFilePath Property
DefOLELCID Property
DeleteCmd Property
DeleteCmdDataSource Property
DeleteCmdDataSourceType Property
DeleteMark Property
Description Property
Desktop Property
Details Property
DisabledBackColor, DisabledForeColor Properties
DisabledItemBackColor, DisabledItemForeColor Properties
DisabledPicture Property
DisableEncode Property
DisplayCount Property
DisplayOrientation Property
DisplayValue Property
Dockable Property
Docked Property
DockPosition Property
DocumentFile Property
DownPicture Property
DragIcon Property
DragMode Property
DrawMode Property
DrawStyle Property
DrawWidth Property
DynamicAlignment Property
DynamicBackColor, DynamicForeColor Properties
DynamicCurrentControl Property
DynamicFontBold, DynamicFontItalic, DynamicFontStrikethru, DynamicFontUnderline Properties
DynamicFontName Property
DynamicFontOutline Property
DynamicFontShadow Property
DynamicFontSize Property
DynamicInputMask Property
DynamicLineHeight Property
EditorOptions Property
Enabled Property
EnableHyperlinks Property
Encrypted Property
ErrorNo Property
Exclude Property
Exclusive Property
FetchAsNeeded Property
FetchMemo Property
FetchMemoCmdList Property
FetchMemoDataSource Property
FetchMemoDataSourceType Property
FetchSize Property
FileClass Property
FileClassLibrary Property
FillColor Property
FillStyle Property
Filter Property
FirstElement Property
FirstNestedTable Property
Flags Property
FontBold, FontItalic, FontStrikethru, FontUnderline Properties
FontCharSet Property
FontCondense, FontExtend Properties
FontName Property
FontOutline Property
FontShadow Property
FontSize Property
ForceCloseTag Property
Format Property
FormattedOutput Property
FormCount Property
Forms Property
FractionDigits Property
FRXDataSession Property
FullName Property
GDIPlusGraphics Property
GridLineColor Property
GridLines Property
GridLineWidth Property
HalfHeightCaption Property
HeaderClass Property
HeaderClassLibrary Property
HeaderHeight Property
Height Property
HelpContextID Property
HideSelection Property
Highlight Property
HighlightBackColor Property
HighlightForeColor Property
HighlightRow Property
HighlightRowLineWidth Property
HighlightStyle Property
HomeDir Property
HostName Property
Hours Property
HScrollSmallChange Property
hWnd Property
Icon Property
IMEMode Property
Increment Property
IncrementalSearch Property
InitialSelectedAlias Property
InputMask Property
InsertCmd Property
InsertCmdDataSource Property
InsertCmdDataSourceType Property
InsertCmdRefreshCmd Property
InsertCmdRefreshFieldList Property
InsertCmdRefreshKeyFieldList Property
Instancing Property
IntegralHeight Property
Interval Property
IsAttribute Property
IsBase64 Property
IsBinary Property
IsDiffGram Property
IsLoaded Property
IsNull Property
ItemBackColor, ItemForeColor Properties
ItemData Property
ItemIDData Property
ItemTips Property
IXMLDOMElement Property
KeyboardHighValue, KeyboardLowValue Properties
Keyfield Property
KeyFieldList Property
KeyPreview Property
KeySort Property
LanguageOptions Property
LastModified Property
Left Property
LeftColumn Property
LineContents Property
LineNo Property
LineSlant Property
LinkMaster Property
List Property
ListCount Property
ListenerType Property
ListIndex Property
ListItem Property
ListItemID Property
LockColumns Property
LockColumnsLeft Property
LockScreen Property
MacDesktop Property
MainFile Property
MapBinary Property
MapN19_4ToCurrency Property
MapVarchar Property
Margin Property
MaxButton Property
MaxHeight Property
MaxLeft Property
MaxLength Property
MaxRecords Property
MaxTop Property
MaxWidth Property
MDIForm Property
MemberClass Property
MemberClassLibrary Property
Message Property
MinButton Property
MinHeight Property
MinWidth Property
MouseIcon Property
MousePointer Property
Movable Property
MoverBars Property
MultiSelect Property
Name Property
NestedInto Property
NewIndex Property
NewItemID Property
NextSiblingTable Property
NoCpTrans Property
NoData Property
NoDataOnLoad Property
NullDisplay Property
NumberOfElements Property
Object Property
OLEClass Property
OLEDragMode Property
OLEDragPicture Property
OLEDropEffects Property
OLEDropHasData Property
OLEDropMode Property
OLEDropTextInsertion Property
OLELCID Property
OLERequestPendingTimeout Property
OLEServerBusyRaiseError Property
OLEServerBusyTimeout Property
OLETypeAllowed Property
OneToMany Property
OpenViews Property
Optimize Property
Order Property
OrderDirection Property
OutputPageCount Property
OutputType Property
PageCount Property
PageHeight Property
PageNo Property
PageOrder Property
Pages Property
PageTotal Property
PageWidth Property
Panel Property
PanelLink Property
ParentAlias Property
ParentClass Property
ParentTable Property
Partition Property
PasswordChar Property
Picture Property
PictureMargin Property
PicturePosition Property
PictureSelectionDisplay Property
PictureSpacing Property
PictureVal Property
PolyPoints Property
Prepared Property
PreserveWhiteSpace Property
PreviewContainer Property
PrintJobName Property
Procedure Property
PROCESSID Property
ProgID Property
ProjectHook Property
ProjectHookClass Property
ProjectHookLibrary Property
QuietMode Property
ReadOnly Property
RecordMark Property
RecordSource Property
RecordSourceType Property
RefreshAlias Property
RefreshCmd Property
RefreshCmdDataSource Property
RefreshCmdDataSourceType Property
RefreshIgnoreFieldList Property
RefreshTimeStamp Property
RelationalExpr Property
RelativeColumn Property
RelativeRow Property
ReleaseType Property
Resizable Property
RespectCursorCP Property
RespectNesting Property
RightToLeft Property
RotateFlip Property
Rotation Property
RowColChange Property
RowHeight Property
RowSource Property
RowSourceType Property
ScaleMode Property
SCCProvider Property
SCCStatus Property
ScrollBars Property
Seconds Property
SelectCmd Property
Selected Property
SelectedBackColor, SelectedForeColor Properties
SelectedID Property
SelectedItemBackColor Property
SelectedItemForeColor Property
SelectionNamespaces Property
SelectOnEntry Property
SelLength Property
SelStart Property
SelText Property
SendGDIPlusImage Property
SendUpdates Property
ServerClass Property
ServerClassLibrary Property
ServerHelpFile Property
ServerName Property
ServerProject Property
ShowInTaskbar Property
ShowTips Property
ShowWindow Property
Sizable Property
SizeBox Property
SOM Property
Sorted Property
Sparse Property
SpecialEffect Property
SpinnerHighValue, SpinnerLowValue Properties
SplitBar Property
StackLevel Property
StartMode Property
StatusBar Property
StatusBarText Property
Stretch Property
StrictDateEntry Property
Style Property
TabIndex Property
Tables Property
TabOrientation Property
Tabs Property
TabStop Property
TabStretch Property
TabStyle Property
Tag Property
Text Property
Themes Property
ThreadID Property
TimestampFieldList Property
TitleBar Property
ToolTipText Property
Top Property
TopIndex Property
TopItemID Property
TwoPassProcess Property
Type Property
TypeLibCLSID Property
TypeLibDesc Property
TypeLibName Property
Unicode Property
UpdatableFieldList Property
UpdateCmd Property
UpdateCmdDataSource Property
UpdateCmdDataSourceType Property
UpdateCmdRefreshCmd Property
UpdateCmdRefreshFieldList Property
UpdateCmdRefreshKeyFieldList Property
UpdateGram Property
UpdateGramSchemaLocation Property
UpdateNameList Property
UpdateType Property
UseCodePage Property
UseCursorSchema Property
UseDeDataSource Property
UseMemoSize Property
UserValue Property
UseTransactions Property
UTF8Encoded Property
Value Property
Version Property
VersionComments Property
VersionCompany Property
VersionCopyright Property
VersionDescription Property
VersionLanguage Property
VersionNumber Property
VersionProduct Property
VersionTrademarks Property
VFPXMLProgID Property
View Property
ViewPortHeight Property
ViewPortLeft Property
ViewPortTop Property
ViewPortWidth Property
Visible Property
VisualEffect Property
VScrollSmallChange Property
WhatsThisButton Property
WhatsThisHelp Property
WhatsThisHelpID Property
WhereType Property
Width Property
WindowState Property
WindowType Property
WordWrap Property
WrapCharInCDATA Property
WrapInCDATA Property
WrapMemoInCDATA Property
XMLAdapter Property
XMLConstraints Property
XMLName Property
XMLNameIsXPath Property
XMLNamespace Property
XMLPrefix Property
XMLSchemaLocation Property
XMLTable Property
XMLType Property
XSDfractionDigits Property
XSDmaxLength Property
XSDtotalDigits Property
XSDtype Property
ZoomBox Property
System Variables Overview
_SCREEN System Variable
_SCREEN System Variable Properties, Methods and Events
_VFP System Variable
_VFP System Variable Properties, Methods, and Events
_ASCIICOLS System Variable
_ASCIIROWS System Variable
_BEAUTIFY System Variable
_BROWSER System Variable
_BUILDER System Variable
_CALCMEM System Variable
_CALCVALUE System Variable
_CLIPTEXT System Variable
_CODESENSE System Variable
_CONVERTER System Variable
_COVERAGE System Variable
_DBLCLICK System Variable
_DIARYDATE System Variable
_DOS System Variable
_FOXCODE System Variable
_FOXREF System Variable
_FoxTask System Variable
_GALLERY System Variable
_GENHTML System Variable
_GENMENU System Variable
_GETEXPR System Variable
_INCLUDE System Variable
_INCSEEK System Variable
_MAC System Variable
_MENUDESIGNER System Variable
_MLINE System Variable
_ObjectBrowser System Variable
_PAGENO System Variable
_PAGETOTAL System Variable
_PRETEXT System Variable
_REPORTBUILDER System Variable
_REPORTOUTPUT System Variable
_REPORTPREVIEW System Variable
_SAMPLES System Variable
_SCCTEXT System Variable
_SHELL System Variable
_SPELLCHK System Variable
_STARTUP System Variable
_TALLY System Variable
_TASKLIST System Variable
_TASKPANE System Variable
_TEXT System Variable
_THROTTLE System Variable
_TOOLBOX System Variable
_TOOLTIPTIMEOUT System Variable
_TRIGGERLEVEL System Variable
_UNIX System Variable
_WINDOWS System Variable
_WIZARD System Variable
SQL Commands and Functions
User Interface Reference
Builders
Application Builder
Advanced Tab, Application Builder
Credits Tab, Application Builder
Data Tab, Application Builder
Forms Tab, Application Builder
General Tab, Application Builder
Reports Tab, Application Builder
Combo Box Builder
Layout Tab, Combo Box Builder
List Items Tab, Combo Box Builder
Style Tab, Combo Box Builder
Value Tab, Combo Box Builder
Command Group Builder
Buttons Tab, Command Group Builder
Layout Tab, Command Group Builder
CursorAdapter Builder
Auto-Update Tab, CursorAdapter Builder
Data Access Tab, CursorAdapter Builder
Properties Tab, CursorAdapter Builder
DataEnvironment Builder
Cursors Tab, DataEnvironment Builder
Data Source Tab, DataEnvironment Builder
Edit Box Builder
Format Tab, Edit Box Builder
Style Tab, Edit Box Builder
Value Tab, Edit Box Builder
Form Builder
Field Selection Tab, Form Builder
Style Tab, Form Builder
Grid Builder
Grid Items Tab, Grid Builder
Layout Tab, Grid Builder
Relationship Tab, Grid Builder
Style Tab, Grid Builder
List Box Builder
Layout Tab, List Box Builder
List Items Tab, List Box Builder
Style Tab, List Box Builder
Value Tab, List Box Builder
Option Group Builder
Buttons Tab, Option Group Builder
Layout Tab, Option Group Builder
Value Tab, Option Group Builder
Referential Integrity Builder
Rules for Deleting Tab, RI Builder
Rules for Inserting Tab, RI Builder
Rules for Updating Tab, RI Builder
Text Box Builder
Format Tab, Text Box Builder
Style Tab, Text Box Builder
Value Tab, Text Box Builder
XML Web Service Builder
Operations Tab, XML Web Service Builder
Services Tab, XML Web Service Builder
AutoFormat Builder
How to: Use Builders
Designers
Query and View Designers
Fields Tab, Query and View Designers
View Field Properties Dialog Box
Filter Tab, Query and View Designers
Group By Tab, Query and View Designers
Join Tab, Query and View Designers
Miscellaneous Tab, Query and View Designers
Order By Tab, Query and View Designers
Update Criteria Tab, View Designer
Table Designer
Fields Tab, Table Designer
Indexes Tab, Table Designer
Table Tab, Table Designer
Class Designer
Connection Designer
Data Environment Designer
Database Designer
Form Designer
Label Designer
Menu and Shortcut Designers
Report Designer
Dialog Boxes
Class Info Dialog Box
Class Tab, Class Info Dialog Box
Members Tab, Class Info Dialog Box
Macros Dialog Box
Record Macro Dialog Box
Overwrite Macro Dialog Box
Stop Recording Macro Dialog Box
Edit Macro Dialog Box
New Macro Dialog Box
Multiple Selection Dialog Box (Report Builder)
Properties Tab, Multiple Selection Dialog Box (Report Builder)
Selection Tab, Multiple Selection Dialog Box (Report Builder)
Options Dialog Box
Field Mapping Tab, Options Dialog Box
Modify Field Mapping Dialog Box
Forms Tab, Options Dialog Box
Form Set Template Dialog Box
Form Template Dialog Box
Controls Tab, Options Dialog Box
Data Tab, Options Dialog Box
Debug Tab, Options Dialog Box
Editor Tab, Options Dialog Box
File Locations Tab, Options Dialog Box
General Tab, Options Dialog Box
IDE Tab, Options Dialog Box
Projects Tab, Options Dialog Box
Regional Tab, Options Dialog Box
Remote Data Tab, Options Dialog Box
Reports Tab, Options Dialog Box
View Tab, Options Dialog Box
Pane Customization Dialog Box
Data Tab, Pane Customization Dialog Box
Default Data Tab, Pane Customization Dialog Box
General Tab, Pane Customization Dialog Box
Handler Code Tab, Pane Customization Dialog Box
Options Tab, Pane Customization Dialog Box
Transform Data Tab, Pane Customization Dialog Box
Project Information Dialog Box
Project Tab, Project Information Dialog Box
Select Directory Dialog Box
Files Tab, Project Information Dialog Box
Servers Tab, Project Information Dialog Box
Query Destination Dialog Box
Browse Button, Query Destination Dialog Box
Cursor Button, Query Destination Dialog Box
Screen Button, Query Destination Dialog Box
Table Button, Query Destination Dialog Box
Report Band Properties Dialog Box (Report Builder)
Band Tab, Report Band Properties Dialog Box (Report Builder)
General Tab, Report Band Properties Dialog Box (Report Builder)
Other Tab, Report Band Properties Dialog Box (Report Builder)
Protection Tab, Report Band Properties Dialog Box (Report Builder)
Report Control Properties Dialog Box (Report Builder)
Advanced Tab, Report Control Properties Dialog Box (Report Builder)
Calculate Tab, Report Control Properties Dialog Box (Report Builder)
Dynamics Tab, Report Control Properties Dialog Box (Report Builder)
Format Tab, Report Control Properties Dialog Box (Report Builder)
General Tab, Report Control Properties Dialog Box (Report Builder)
Other Tab, Report Control Properties Dialog Box (Report Builder)
Print When Tab, Report Control Properties Dialog Box (Report Builder)
Protection Tab, Report Control Properties Dialog Box (Report Builder)
Style Tab, Report Control Properties Dialog Box (Report Builder)
Report Properties Dialog Box (Report Builder)
Data Environment Tab, Report Properties Dialog Box (Report Builder)
Data Grouping Tab, Report Properties Dialog Box (Report Builder)
Document Properties Tab, Report Properties Dialog Box (Report Builder)
Optional Bands Tab, Report Properties Dialog Box (Report Builder)
Other Tab, Report Properties Dialog Box (Report Builder)
Page Layout Tab, Report Properties Dialog Box (Report Builder)
Protection Tab, Report Properties Dialog Box (Report Builder)
Ruler/Grid Tab, Report Properties Dialog Box (Report Builder)
Variables Tab, Report Properties Dialog Box (Report Builder)
Toolbars Dialog Box
Customize Toolbar Dialog Box
About Microsoft Visual FoxPro Dialog Box
Add Dynamic Style Condition Dialog Box (Report Builder)
Add Files to Source Control Dialog Box
Add Property Dialog Box (Report Builder)
Add Table or View Dialog Box
Advanced Options Dialog Box
Append From Dialog Box
Append From Options Dialog Box
Arrange Tables and Views Dialog Box
Beautify Options Dialog Box
Breakpoints Dialog Box
Build Options Dialog Box
Calculate Field Dialog Box
Change Icon Dialog Box
Check In Files Dialog Box
Check Out Files Dialog Box
Choose Field/Variable Dialog Box
Code Page Dialog Box
Comment Dialog Box
Compile Dialog Box
Configure Dynamic Properties Dialog Box (Report Builder)
Connections Dialog Box
Coverage Dialog Box
Create Dialog Box
Create One-To-Many Relationships Dialog Box
Customize Toolbox Dialog Box
Data Grouping Dialog Box
Database Properties Dialog Box
Define Window Layout Dialog Box
Delete (Records) Dialog Box
Description Dialog Box
Do Dialog Box
Dynamic Script Preview Dialog Box (Report Builder)
Edit Bands Dialog Box
Edit Links Dialog Box
Edit Properties Dialog Box
Edit Property/Method Dialog Box
Edit Relationship Dialog Box
Event Handler Registry Dialog Box (Report Builder)
Event Tracking Dialog Box
EXE Version Dialog Box
Execution Throttle Dialog Box
Export Dialog Box
Export Options Dialog Box
Expression Builder Dialog Box
Expression Builder Options Dialog Box
Field Picker Dialog Box
File Finder Dialog Box
Find Dialog Box
Find Table or View Dialog Box
Font Dialog Box
Format (Field) Dialog Box
FRX Cursor Browser Dialog Box (Report Builder)
General Options Dialog Box
Generate Menu Dialog Box
Get Latest Version of Files Dialog Box
Go To Line Dialog Box
Go To Record Dialog Box
Having Dialog Box
Import Dialog Box
Include File Dialog Box
Insert Object Dialog Box
Insert Object Reference Dialog Box
Insert System Menu Bar Dialog Box
Join Condition Dialog Box
Label Dialog Box
Locate Database Dialog Box
Locate File Dialog Box
Locate Record Dialog Box
Look Up Reference Dialog Box
Look Up Reference Dialog Box, Options Dialog Box
Menu Options Dialog Box
More Windows Dialog Box
Move Item Dialog Box
New Class Dialog Box
New Dialog Box
New File Dialog Box
New Label Dialog Box
New Local View Dialog Box
New Method Dialog Box
New Property Dialog Box
New Remote View Dialog Box
New Table Dialog Box
Open Dialog Box
Open Picture Dialog Box
Optional Bands Dialog Box
Page Setup Dialog Box
Paste Special Dialog Box
Print Dialog Box
Print File Dialog Box
Print Options Dialog Box
Print When Dialog Box
Prompt Options Dialog Box
Quick Report Dialog Box
Recall (Records) Dialog Box
Rectangle/Line Dialog Box
Remove Files from Source Control Dialog Box
Rename File Dialog Box
Replace Dialog Box
Replace Field Dialog Box
Report and Label Print Options Dialog Box
Report Band Properties Dialog Box
Report Builder Debug Event Dialog Box (Report Builder)
Report Builder Options Dialog Box (Report Builder)
Report Dialog Box
Report Expression Dialog Box
Report Page Setup Dialog Box
Report Picture Dialog Box
Report Variables Dialog Box
Round Rectangle Dialog Box
Run-time Extensions Dialog Box (Report Builder)
Save As Class Dialog Box
Save As Dialog Box
Save As HTML Dialog Box
Scope Dialog Box
Select Connection or Data Source Dialog Box
Select Dialog Box
Set Grid Scale Dialog Box
Set Index Order Dialog Box
Tab Order Dialog Box
Task Pane Options Dialog Box
Undo Check Out of Files Dialog Box
Update Project List Dialog Box
View Parameters Dialog Box
Visual FoxPro Converter Dialog Box
Visual FoxPro Transporter Dialog Box
Visual FoxPro XML Web Service Location Dialog Box
Visual FoxPro XML Web Services Publisher Dialog Box
Visual FoxPro XML Web Services Registration Dialog Box
Wizard Selection Dialog Box
Work Area Properties Dialog Box
XML Web Service - Client Detail Dialog Box
XML Web Service - Complex Types Dialog Box
XML Web Service - Operation Detail Dialog Box
XML Web Service - Parameter Values Dialog Box
Zoom <property> Dialog Box
Windows
Class Browser Window
Class Browser Buttons
Component Gallery Window
Component Gallery Options Dialog Box
Catalogs Tab, Component Gallery Options Dialog Box
Dynamic Views Tab, Component Gallery Options Dialog Box
Standard Tab, Component Gallery Options Dialog Box
Component Gallery Properties Dialog Boxes
Catalog Properties Dialog Box
Folder Properties Dialog Box
Item Properties Dialog Box
Add Class to Project Dialog Box
Find Component Dialog Box
Open Catalog Dialog Box
Coverage Profiler Window
Coverage Profiler Tool Buttons
Coverage Profiler Add-Ins Dialog Box
Coverage Profiler Find Dialog Box
Coverage Profiler Options Dialog Box
Coverage Profiler Statistics Dialog Box
Coverage Profiler Exit Dialog Box
Debugger Window
Debugger Keyboard Shortcuts and Menus
Task Pane Manager
Data Explorer Task Pane
Environment Manager Task Pane
Accessibility Browser Window
Automated Test Harness Window
Browse Window
Call Stack Window
Code References Window
Code Window
Command Window
Data Session Window
Debug Output Window
Document View Window
Editing Window
General Field Window
Go To Definition Window
Locals Window
MemberData Editor
Object Browser Window
Project Manager Window
Properties Window
Task List Manager Window
Toolbox
Trace Window
Visual FoxPro IntelliSense Manager Window
Visual FoxPro System Windows
Watch Window
Wizards
Application Wizard
Application Wizard Object Members
Visual FoxPro Framework Application Object
Documenting Wizard
Customizing Documenting Wizard Output
SQL Server Upsizing Wizard
How to: Resolve SQL Server Upsizing Wizard Errors
Web Publishing Wizard
Advanced Dialog Box
HTML Item Dialog Box
Layout Options Dialog Box
Cross-Tab Wizard
Database Wizard
Form Wizard
Graph Wizard
Import Wizard
Label Wizard
Local View Wizard
Mail Merge Wizard
One-To-Many Form Wizard
One-To-Many Report Wizard
PivotTable Wizard
Query Wizard
Remote View Wizard
Report Wizard
Table Wizard
Samples and Walkthroughs
Samples
Foundation Class Samples
Add a Data-Bound Calendar Sample
Add Data Lookup Combo Boxes Sample
Add Data Querying to Forms Sample
Add Data Sorting and Filtering to Forms Sample
Add Encryption to Applications Sample
Add Miscellaneous Form Buttons Sample
Add Navigation to Forms Sample
Add Shortcut Menus to Objects Sample
Add Web Hyperlinks to a Form Sample
Application Error Handling Sample
Create a Visual FoxPro Web Browser Sample
Create Record Bound Graphs Sample
Create Toolbar Control Effects Sample
Display Data Reporting Output Options Sample
Expanding the SetAll Method Sample
Generate HTML Sample
Guidelines for Using Visual FoxPro Foundation Classes
Handle Application Environment Tasks Sample
Handle Common Windowing Tasks Sample
Handle Data Conflicts Sample
Pool Manager Sample
Retrieve Project Location and Name Sample
Run Word, Excel, and Graph Automation Sample
Search Text Using Regular Expressions Sample
Set VFP Shell Open Commands Sample
Tips for the Windows 2000 Logo Program Sample
Use an Enhanced Openfile Dialog Box Sample
Use Array Handling Sample
Use Common Application Dialog Boxes Sample
Use Edit Buttons for a Complex Form Sample
Use Edit Buttons for a Simple Form Sample
Use Mover List Boxes for Selecting Data Sample
Use Progress Thermometer Sample
Working with Microsoft Agent Sample
Server Samples
FoxISAPI Automation Server Samples
FoxIs, a Visual FoxPro Internet Server
FoxWeb, a Simplified Visual FoxPro Internet Automation Server
COM Samples
Solution Samples
ActiveX Solution Samples
Add and Remove Items in a Treeview Control Sample
Customize the Open Dialog Box Sample
Display System Information Sample
Play an AVI File in an ActiveX Control Sample
Provide a Hierarchical Display of Items Sample
Send Mail Sample
Use Slider and Status Bar Controls Sample
Use the RichText Control Sample
Automation Solution Samples
Automate a Microsoft Excel Spreadsheet Sample
Automate a Microsoft Word Document in a Form Sample
Automate Microsoft Word and Excel Sample
Manipulate Display Characteristics of a Graph Sample
Refresh a Graph in a Form Sample
Controls Solution Samples
Add Items Interactively to a List Box Sample
Add New Items to a Combo Box Sample
Allow Users to Choose List Values Sample
Allow Users to Drag and Drop Controls Sample
Change Pages When a User Chooses a Button Sample
Change the Number of Tabs at Run Time Sample
Display a Stop Watch Sample
Display a System Clock Sample
Display Calculated Values in a Column Sample
Display Child Records from a Relationship Sample
Display Controls in a Grid Sample
Display Different Pages without Tabs Sample
Display Multiple Columns in a List Box Sample
Display Pictures in a List Sample
Dynamically Format Grid Columns Sample
Edit a Memo Field or Text File Sample
Execute Commands at Specified Intervals Sample
Fill a List with Values from Different Sources Sample
Format Input and Validate Data in a Text Box Sample
Grid Highlighting, Column Resizing, and Header Images Sample
Hot Tracking and Hover Effects Sample
Manipulate Text Programmatically Sample
Move Items Between List Boxes Sample
Multiselect Items in a List Box Sample
Open Multiple Files Interactively Sample
Present a User with Multiple Choices Sample
Resize and Reposition Controls at Run Time Sample
See Check Box Design Options Sample
See Command Button Design Options Sample
Sort List Box Items Sample
Treeview/Listbox Drag and Drop Sample
Data Solution Samples
Create a Cursor from an XML DataSet Sample
Load and Generate XML Using the XMLAdapter Class Sample
Manage Data Access Using CursorAdapters Sample
Databases Solution Samples
Create a Default Unique ID Value for a Field Sample
Create Small Indexes Using BINTOC( ) Sample
Index on Expressions Sample
Nest Transactions Sample
Programmatically Check Table Properties Sample
Sort or Order a Table at Run Time Sample
Use DBC Events Sample
Forms Solution Samples
Create a One-To-Many Data Entry Form Sample
Create a Query-By-Example Form Sample
Create a Single Table Data Entry Form Sample
Create an Irregularly Shaped Window Sample
Create an SDI Form Sample
Display Line Animation on a Form Sample
Display Pictures in an Image Control Sample
Draw Lines and Shapes on a Form Sample
Graph Equations on a Form Sample
Manipulate Objects Programmatically Sample
Pass Parameters Between Forms Sample
Provide What's This? Help on a Form Sample
Return a Value from a Form Sample
Run Multiple Instances of a Form Sample
Transparent Forms Sample
Use Access/Assign Methods on a Form Sample
Menus and Toolbars Solution Samples
Add Menu Items at Run Time Sample
Add Personalized Menus Sample
Change Font Attributes Sample
Coordinate Menu Items and Toolbar Buttons Sample
Create Dynamic Shortcut Menus Sample
Disable or Display a Check beside a Menu Item Sample
Display Shortcut Menus Sample
Use Style Toolbars Sample
Miscellaneous Solution Samples
Control MSN Messenger Sample
Track Activities in a Project Sample
Programming Solution Samples
Bind, Raise, Unbind, and Retrieve Events Sample
Member Classes Sample
OLE Drag-and-Drop Data Formats Sample
OLE Drag-and-Drop Events Sample
Pass Strongly Typed Arrays Sample
SCATTER NAME...ADDITIVE Sample
Structured Exception Handling Sample
Taskbar Icon Sample
Windows XP Themes Support Sample
Reports Solution Samples
Print a Percent of Total in a Report Sample
Print an Invoice Sample
Print Customer Mailing Labels Sample
Print Data Dictionary Information Sample
Print in Catalog Format Sample
Print Product Orders By Quarter Sample
Print Report Details in a Ledger Style Sample
Use Conditional Formatting in a Report Sample
Views and Queries Solution Samples
Interactively Build a SELECT Statement Sample
Select Customers in a Specific Country Sample
Select Records from a Full Outer Join Sample
Select Records from a Left Outer Join Sample
Select Records from a Nested Join Sample
Select Records from a Right Outer Join Sample
Select Records from an Inner Join Sample
Select Records from Both Inner and Outer Joins Sample
Select the 10 Worst-Selling Products Sample
Select the Top 10 Best-Selling Products Sample
Windows API Solution Samples
Get Application Information from the Windows Registry Sample
Get Version Information Sample
Play Multimedia Files Using MCI Commands Sample
Read and Write Visual FoxPro Registry Values Sample
Read ODBC Registry Values Sample
Use API Functions that Require a STRUCT Sample
Use API Functions That Require Pointers to Arrays Sample
View Type Library Information Sample
How to: Run Visual FoxPro Solution Samples
Sample Class Libraries
Walkthroughs
Walkthrough: Creating a Visual FoxPro Application Setup Program Using InstallShield
Walkthrough: Creating Applications with Visual FoxPro
Walkthrough: Creating Reports with Visual FoxPro
Walkthrough: Creating XML Web Services with Visual FoxPro
Walkthrough: Retrieving Data from Different Data Sources
Using Visual FoxPro
Developing Visual FoxPro Applications
Application Planning
Application Architecture
Planning Client/Server Applications
Optimizing Client/Server Performance
Client/Server Design for High Performance
Form Acceleration
Optimizing Connections
Performance Improvement on Updates and Deletes
Query and View Acceleration
Speeding Up Data Retrieval
Data Location on the Optimal Platform
Performance Enhancement through Set-Based Data Access
Application Creation with Accuracy and Data Integrity
Planning Enterprise Applications
Rapid Application Development
Design Considerations
Visual FoxPro as an Application Back End
Visual FoxPro as an Application Front End
Developing International Applications
Designing for Localization
Managing Files in an International Application
Planning an International Application
Planning for Team Development Projects
Managing Files in a Source-Controlled Project
How to: Check for Differences in Forms, Reports, and Other Table Files
How to: Check In Files
How to: Check Out Files
How to: Compare Files or Projects
How to: Discard Changes
How to: Display File and Project Information
How to: Get the Latest Versions of Files
Working with Multi-File Components
Managing Visual FoxPro Projects Under Source Control
How to: Add Files to a Source-Controlled Project
How to: Detach a Project from Source Control
How to: Join an Existing Source-Controlled Project
How to: Put Projects Under Source Control
How to: Remove Files from a Source-Controlled Project
How to: Share Files Between Source-Controlled Projects
How to: Update the Project List
Working with the Project File and Project List File
Source Control Features
How to: Enable Source Control
Source Control Software in Visual FoxPro
Developing and Modifying Databases in Teams
Developing Class Libraries in Teams
Team Development Concepts
Security Planning
Security Considerations
Security Risks for Visual FoxPro Developers
Compiling an Application
Excluding Modifiable Files from Builds
How to: Build Applications
How to: Exclude Files from Builds
How to: Run Applications
Configuring Help Files for Applications
How to: Add Context Sensitive Help to Applications
How to: Add Help Buttons to Forms
How to: Implement
Creating Applications
Configuring an Application
How to: Control the Event Loop
How to: Customize the Appearance of Applications
How to: Initialize the Environment
How to: Set the Starting Point
Main Files in Applications
Creating Applications with the Application Framework
Application Framework Files
Data Selection with Application Builder
How to: Create a Framework
How to: Generate Forms and Reports with Application Builder
How to: Manage Documents with Application Builder
How to: Specify a Builder Application with Builder.dbf
Creating International Applications
Code Pages in Visual FoxPro
Code Pages Supported by Visual FoxPro
How to: Determine the Code Page of a Project File
How to: Prevent Translation of Data in Character or Memo Fields
How to: Specify the Code Page of a .dbf File
How to: Specify the Code Page of a Text File
Specification of Code Pages for Variables
Understanding Code Pages in Visual FoxPro
Sorting Data in International Applications
Application Creation with Double-Byte Character Sets
How to: Specify a Sort Order
Understanding Sort Orders
How to: Enter International Data
How to: Set Date, Time, and Currency Formats
Modifying International Applications
Reporting Features for International Applications
Creating the User Interface
Designing Menus and Toolbars
Creating Custom Toolbars
How to: Add a Coordinated Toolbar and Menu to a Form Set
How to: Add Custom Toolbars to Form Sets
How to: Add Objects to a Custom Toolbar Class
How to: Coordinate Toolbars and Forms Using Code
How to: Create the Coordinated Menu
How to: Define a Toolbar Class
How to: Define Toolbar Actions
How to: Dock Toolbars
Creating Menus, Shortcut Menus, Menu Items, and Submenus
How to: Create Menu Items
How to: Create Menus and Submenus
How to: Create Shortcut Menus
Menu System Creation
How to: Group Menu Items
How to: Save a Menu as HTML
Menu System Design Guidelines
How to: Add Cleanup Code to a Menu System
How to: Add Setup Code to a Menu System
How to: Assign Access Keys and Keyboard Shortcuts
How to: Control Menus at Run Time
How to: Customize a Menu System
How to: Enable and Disable Menu Items
How to: Include Menus in an Application
How to: Perform Tasks with Commands
How to: Perform Tasks with Procedures
How to: Test and Debug a Menu System
Using Controls
Controls and Data Concepts
How to: Create Controls by Dragging and Dropping Fields or Tables
Controls for Accepting Input
Accepting Numeric Input in a Given Range
How to: Define User Input Characteristics
How to: Set the Number of Option Buttons in an Option Button Group
How to: Store User Choices to a Table Using Option Buttons
How to: Use Check Boxes to Specify States
Setting Option Button Properties
User Input in Combo Boxes
User Input in Edit Boxes
User Input in Text Boxes
Controls for Allowing Specific Actions
Performing Specific Actions at Given Intervals
Controls for Displaying Information
How to: Enhance Control Display
Controls for Displaying Lists
How to: Add Pictures to Items in a List
How to: Allow Users to Add Items to a List Box
How to: Allow Users to Select Multiple Items in a List Box
How to: Choose the Type of Data for a List or Combo Box
How to: Create Multicolumn List Boxes
How to: Display Child Records in a List
How to: Refresh a One-to-Many Display Based on a List Value
Controls for Extending Forms
ActiveX Controls Overview
How to: Manipulate Objects with OLE Container Control and OLE Bound Control
Controls for Manipulating Rows of Data
Formatting Grids
How to: Display Controls in Grid Columns
How to: Manually Adjust Grid Display at Design Time
How to: Set the Source of the Data Displayed in the Grid
How to: Set Up a One-to-Many Form Using the Grid Control
How to: Use Grid Objects
Creating Drag-and-Drop Controls
How to: Make Controls Easier to Use
Working with Forms
Creating Forms
Adding Objects to Forms
Manipulating Objects
Example of Manipulating Objects
How to: Display Inherited Code for Objects, Events, and Methods
How to: Set Properties for Objects
How to: Show Properties with Modified Settings
How to: View Properties for Objects
Aligning Controls in Forms
How to: Add Controls to a Form with the Component Gallery
How to: Add Controls to a Wizard-Generated Form
How to: Add User-Defined Objects to a Form
How to: Add Visual FoxPro Containers
How to: Add Visual FoxPro Controls to a Form
How to: Copy and Delete Form Controls
How to: Select, Move, and Resize Form Controls
How to: Set Tab Order for Controls
Understanding Container and Control Objects
Creation of Single- and Multiple-Document Interfaces
How to: Add a Menu to a Top-Level Form
How to: Display a Child Form Inside a Top-Level Form
How to: Hide the Main Visual FoxPro Window
How to: Specify a Form Type
Customizing Forms
How to: Add Graphics to Forms
How to: Add Shapes and Lines to Forms
How to: Assign an Icon to a Form
How to: Change Text Properties
How to: Set Form Colors
Designing Forms
How to: Create a New Form
How to: Set the Data Environment
How to: Add Properties and Methods to a Form
Controlling Form Behavior
How to: Edit Event and Method Code
How to: Extend Forms with Form Sets
Docking Forms
How to: Create Forms with Local and Remote Data
How to: Dock Forms
How to: Hide a Form
How to: Manage Multiple Instances of a Form
How to: Pass Parameters to a Form
How to: Return a Value from a Form
How to: Run a Form
How to: Save a Form as HTML
How to: Save Forms
How to: Set Form Templates
How to: Set Properties at Run Time
How to: Set the Design Area for a Form
Using Form Templates
Working with Projects
Extending Projects in Visual FoxPro
Project Manager Hooks
Project Object Architecture
Project Object Hierarchy
How to: Add Files to a Project
How to: Create Files in Projects
How to: Create Projects
How to: Edit Files in Projects
How to: Remove Files from Projects
How to: Replace Code References
How to: Search For Code References
How to: View Code Definitions
Working with Reports
Distributing Reports with Applications
Setting Protection for Reports
How to: Protect Report Bands
How to: Protect Report Controls
How to: Protect Report Layouts
Report Protection Flags
Including Report Files for Distribution
Integrating Reports with Applications
Extending Report Functionality in Visual FoxPro
Extending Reports at Design Time
How to: Add Your Own Handler to the Report Builder's Registry
How to: Configure the Report Builder's Event Handling
How to: Display the Report Builder Options Dialog Box
How to: Extend or Replace the Report Builder
How to: Replace the Report Builder's Expression Builder Dialog Box
How to: Specify an Alternate Report Event Handler Table
How to: Specify and Distribute ReportBuilder.App
Report Builder Event Handler Registry Table
The Report Builder Event Class
Understanding Report Builder Events
Extending Reports at Run Time
Extending Report Output Functionality
Report Output Application
How to: Register Custom ReportListeners and Custom OutputTypes in the Report Output Registry Table
How to: Specify an Alternate Report Output Registry Table
How to: Specify and Distribute Report Output Application Components
How to: Use the Report Output Application's Reference Collection
Understanding the Report Output Application
Considerations for Creating New Report Output Types
Using VFP Report Output XML
Extending Report Preview Functionality
Creating a Custom Preview Container
How to: Specify and Distribute ReportPreview.App
Leveraging the Default Preview Container
The Preview Container API
Handling Errors During Report Runs
Understanding Visual FoxPro Object-Assisted Reporting
Report XML MemberData Extensions
Understanding and Extending Report Structure
Using GDI in Reports
Report Layout and Design
Working with Page Layouts
How to: Change Page Settings for Reports
How to: Configure the Page Layout Grid for Reports
How to: Define Columns in Reports
Working with Report Bands
How to: Add Bands to Reports
How to: Add Comments to Report Bands
How to: Add User Data to Report Bands
How to: Change Detail Band Order
How to: Change Report Band Height
How to: Configure Output for Report Bands
How to: Delete Bands from Reports
How to: Specify Expressions to Evaluate When Processing Bands
How to: Specify Target Aliases for Detail Bands
Report Bands
Working with Report Controls
Adding Report Controls
Format Expressions for Field Controls
How to: Add Field Controls to Reports
How to: Add General Fields to Reports
How to: Add Label Controls to Reports
How to: Add Pictures to Reports
How to: Add Shapes to Reports
How to: Perform Calculations in Field Controls
How to: Specify Data Types for Field Controls
How to: Specify Expressions in Field Controls
Configuring Report Controls
How to: Add Comments to Report Controls
How to: Add Design-time Captions to Field Controls
How to: Add Tooltips to Report Controls
How to: Add User Data to Report Controls
How to: Assign Structured Metadata to Report Controls
How to: Change Colors in Report Controls
How to: Change Font Settings in Report Controls
How to: Change Line Styles of Report Controls
How to: Change Opacity of Report Controls
How to: Dynamically Format Report Controls
How to: Set Alignment of Report Control Contents
How to: Set Stretching Report Controls
How to: Specify Conditional Output for Report Controls
How to: Suppress Blank Lines in Report Controls
How to: Suppress Repeated Values for Report Controls
Managing Report Controls
How to: Adjust Report Control Position
How to: Align Report Controls Within the Layout
How to: Group Report Controls
How to: Resize Report Controls
How to: Select Multiple Report Controls
Working with Report Data Groups
Data Groups in Reports
How to: Add Data Groups to Reports
How to: Configure Output for Data Groups
How to: Delete Data Groups in Reports
How to: Edit Data Groups in Reports
Working with Report Variables
How to: Change Report Variable Order
How to: Define Report Variables
How to: Reset Report Variables
Running Reports
How to: Control Record Selection in Report Output
How to: Generate Output for Reports
How to: Preview Reports
How to: Save the Printer Environment for Reports
Working with Data in Reports
Controlling Data in Reports
How to: Load Data Environments for Reports
How to: Save Report Data Environments as Classes
How to: Specify a Report's Data Session
Working with Related Tables using Multiple Detail Bands in Reports
Considerations for Creating Reports
How to: Add Document Properties to a Report
How to: Create Labels
How to: Create Reports
How to: Open Reports and Labels
Reports in Visual FoxPro
Distributing Applications
Application Distribution Process
Distributable and Restricted Visual FoxPro Features and Files
How to: Include Files with Applications for Distribution
Preparation for Distributing Applications
Resource Files in Applications
Enhancing Applications Using SQL Pass-Through Technology
Using SQL Pass-Through Technology
Execution of ODBC Extensions to SQL
How to: Access Stored Procedures on Remote Servers with SQL Pass-Through Functions
How to: Control Transactions Manually
How to: Create a Parameterized Query
How to: Return Multiple Result Sets
How to: Use Automatic Transaction Mode
How to: Use SQL Pass-Through Functions
Managing Connections with SQL Pass-Through
Selecting the Right Methods
Sharing Connections for Remote Data
Using Result Sets
Using SQL Server Input/Output Parameters
Visual FoxPro SQL Pass-Through Functions
Working with Remote Data Using SQL Pass-Through
Data Type Conversion Control
How to: Use SQL Pass-Through Asynchronously
Processing Multiple Result Sets
Selecting an Efficient SQL Pass-Through Processing Mode
Setting Cursor Properties for Remote Data
Updating Remote Data with SQL Pass-Through
Handling SQL Pass-Through Errors
How to: Set Up an ODBC Data Source
Optimizing Applications
Optimizing Access to Remote Data
Optimizing ActiveX Controls
Optimizing Forms and Controls
Optimizing International Applications
Optimizing Programs
Optimizing Tables and Indexes
Using Rushmore Query Optimization to Speed Data Access
Testing and Debugging Applications
Handling Run-Time Errors
Class and Object Error Handling
Error Handler Priority
Procedural Error Handling
Structured Error Handling
Using the Debugger
How to: See Stored Values
How to: Suspend Program Execution
How to: Use the Debugger
Output Display
Debugging Before Bugs Exist
How to: Test a Project
How to: View and Save Build Messages
Web Services and Components
Automation and COM Servers
Server Design Considerations and Limitations
Controlling Call Blocking
Language Supported in Run-Time Libraries
Selecting a Run-Time Library
Selecting Process Types
Visual FoxPro Run-Time Libraries
VFP9R.DLL Run-Time Library
VFP9T.DLL Run-Time Library
Working with Automation Servers
Automation Server Programming Notes
Automation Servers in Visual FoxPro
Binding Type Libraries
Compiling Source Code
Early (vtable) and Late (IDispatch) Binding
How to: Build Automation Servers
How to: Create Automation Servers
How to: Register Automation Servers
Passing Arrays to Automation Servers
Scalability and Multithreading
Controlling Visual FoxPro from Other Applications
Referencing Data Types in COM Objects
Visual FoxPro and Advanced COM
Interoperability and the Internet
OLE Drag-and-Drop
Design-Time OLE Drag-and-Drop Support
Dragging and Dropping Data
How to: Implement Intrinsic and Manual OLE Drag-and-Drop Modes
Run-Time OLE Drag-and-Drop Support
Sharing Information and Adding OLE
Dynamic Information Sharing
Considerations for Linking or Embedding Data
Embedding Hyperlinks
How to: Change or Break Links to Data in Tables
How to: Display Embedded or Linked Data from Tables
How to: Display Embedded or Linked Data on Forms
How to: Insert Data in Tables
How to: Replace Linked or Embedded Data with Static Data
Working with OLE Objects
Designing an OLE Application
How to: Add OLE Objects to Applications
How to: Edit OLE Objects in Forms and Tables
How to: Use ActiveX Controls
Manipulating Objects with Automation
XML Web Services in Visual FoxPro
Deploying XML Web Services
How to: Access XML Web Services
How to: Distribute XML Web Services
Testing and Rebuilding COM Servers for XML Web Services
Working with Data
Developing Databases
Creating Databases
Working with Database Container Events
Database Container Events
How to: Add Code to a DBC Event
How to: Enable or Disable DBC Events
Working with Items in Databases
How to: Arrange Tables and Views in Databases
How to: Associate Tables with a Database
How to: Build Referential Integrity Between Tables
How to: Create Persistent Relationships Between Tables
How to: Display Items in Databases
How to: Find Tables or Views in Databases
How to: Manage Persistent Relationships Between Tables
How to: Remove a Table from a Database
How to: Update Table and Database Links
How to: Use Tables from Other Databases
How to: Create and Manage Stored Procedures
How to: Create Databases
How to: View and Set Database Properties
Designing Databases
Determining the Fields You Need
Identifying Fields
Using Primary Key Fields
Analyzing Data Requirements
Database Design Process
Identifying Relationships
Organizing Requirements into Tables
Refining the Design
Sample Database Diagrams
Managing Databases
Handling Database Errors
How to: Add Databases to Projects
How to: Close Databases
How to: Extend Database Files
How to: Open Databases
How to: Remove Databases from Projects
How to: Set the Current Database
How to: Validate a Database
How to: View Database Structure
Databases in Visual FoxPro
Importing and Exporting Data
Appending Data
How to: Append Data to Existing Tables
How to: Append Data with the Import Wizard
How to: Select Fields to Append
How to: Select Records to Append
Exporting Data
How to: Control the Record Export Process
How to: Export a Quantity or Range of Records
How to: Export Data to New Files
How to: Export Numeric or Currency Values
How to: Export Records That Match Conditions
How to: Export Text Files
Importing Data
How to: Import Data into New Tables
How to: Import Data with the Import Wizard
How to: Import from Lotus 1-2-3
How to: Import from Microsoft Excel
How to: Translate Lotus Date Fields
Converting Between XML and Visual FoxPro Data
Data Access Management Using CursorAdapters
Importing and Exporting Concepts
XML Functionality Using XMLAdapters
Programming for Shared Access
Controlling Access to Data
Buffering Data
Customizing the Environment of a Data Session
How to: Append and Delete Records in Table Buffers
How to: Enable Buffering
How to: Set Data Access
How to: Use Data Sessions
Locking Data
Updating Data Using Multiple Form Instances
Updating Data
How to: Detect Updating Conflicts
How to: Perform Updates Using Buffers
Managing Conflicts When Updating Data
Managing Updates by Using Views
Managing Updates Using Transactions
Optimizing Applications in Multiuser Environments
Upsizing Visual FoxPro Databases
Database Creation with Upsizing Wizards
How the SQL Server Upsizing Wizard Works
How to: Start the SQL Server Upsizing Wizard
Mapping Visual FoxPro Databases to SQL Server Databases
SQL Server Upsizing Process Completion
SQL Server Upsizing Wizard Preparation
Goals for Prototyping
How to: Build a Local Prototype of an Application
Visual FoxPro Data Access Using the OLE DB Provider
How to: Access Visual FoxPro Data in Microsoft Office
How to: Access Visual FoxPro Data in Visual Studio
OLE DB Provider for Visual FoxPro
Working with Queries
Setting Query Output Destinations
How to: Choose a Query Output Destination
How to: Display Query Results in a Window
How to: Populate Query Results in a Form Control
How to: Print Query Results in a Report or Label
How to: Store Query Results in a Table, Array, or Cursor
How to: Collect User Input with Queries
How to: Control Record Selection with Joins
How to: Create Queries
How to: Customize Queries
How to: Customize Queries Using SQL SELECT Statements
How to: Define Query Results
How to: Organize Query Results
How to: Query Multiple Tables and Views
How to: Run Queries
Working with Tables
Creating Tables
How to: Create Database Tables
How to: Create Free Tables
How to: Edit Table Structure
How to: Name Tables
Table Creation
Managing Tables
Managing Tables in Data Sessions
How to: Close Tables in Work Areas
How to: Create and Use Table Aliases
How to: Open Tables in Work Areas
How to: Set Temporary Relationships Between Tables
How to: View Open Tables in Data Sessions
Temporary Relationships Between Tables
Work Areas in Data Sessions
How to: Close Tables
How to: Copy Tables
How to: Delete Tables
How to: Open Tables
How to: Save a Table as HTML
Trigger Usage
How to: Create Triggers
How to: Modify Triggers
How to: Remove or Delete Triggers
Working with Fields
Autoincrementing Field Values in Tables
Field Creation
How to: Add Comments to Fields
How to: Add Fields to Tables
How to: Add Indexes to Fields
How to: Choose Data Types
How to: Create Default Field Values
How to: Delete Fields
How to: Format Output for Fields
How to: Name Fields
How to: Permit Null Values in Fields
How to: Restrict Access to Fields
How to: Set Autoincrementing Field Values
How to: Set Default Classes for Fields
How to: Specify Captions for Fields
How to: Specify Input Masks for Fields
Preventing Duplicate Values in Fields
Working with Records
How to: Add Data to Records
How to: Add Records to Tables
How to: Configure Browse Windows or Grids
How to: Delete Records in Tables
How to: Filter Records in Tables
How to: Navigate Records in Tables
How to: Remove Deleted Records
How to: Restore Deleted Records
How to: View Records in Tables
Working with Table Indexes
Considerations for Creating Index Expressions
How to: Create Indexes
How to: Create Less Frequently Used Indexes
How to: Delete Indexes
How to: Display Records in Descending Order
How to: Enhance the Efficiency of Indexes
How to: Filter Data
How to: Select Indexes at Run Time
How to: Set Controlling Indexes
Index Creation Based on Expressions
Indexes Based on Deleted Records
Visual FoxPro Index Files
Visual FoxPro Index Types
Working with Validation Rules
Field and Record Validation Rules
How to: Create Field Validation Rules
How to: Create Record Validation Rules
How to: Remove Validation Rules
Working with Views
Creating Views
Accessing Remote Data Using Views
How to: Add Tables to Views
How to: Create Local Views
How to: Create Remote Views
How to: Define Connections to Remote Data Sources
How to: Generate Results for Views
How to: Select Fields for Views
View Creation
Displaying Data in Views
How to: Create Parameterized Views
How to: Display View Structure
How to: Filter Records in Views
How to: Optimize View Performance
How to: Optimize Filters and Joins
How to: Set the Maximum Number of Records Downloaded
How to: Share Connections for Multiple Remote Views
How to: Test a Connection for Availability
Managing Views
How to: Add Comments to Views
How to: Create Default Values for View Fields
How to: Create Validation Rules for Views
How to: Create Views with Stored SQL Statements
How to: Delete Views
How to: Edit Views
How to: Open Views in Work Areas
How to: Rename Views
How to: Set Field Properties for Views
How to: Set Timeout Intervals for Connections
How to: View and Edit SQL Statements for Views
Opening Views
Setting View and Connection Properties
Manipulating Offline Data
How to: Create Offline Views
Updating Data Using Transactions
Updating Data in Views
How to: Update a Table in a View
How to: Update Data in a View
How to: Update Multiple Tables in a View
Preparing to Update Views
Enforcing Business Rules
Development Productivity Tools
Coverage Profiler Application
Conserving Disk Space During Coverage Runs
Coverage Engine Object
Coverage Profiler Add-Ins
Coverage Profiler Log File
Coverage Profiler Modification
How to: Examine Application Coverage and Profile
How to: Log Code Coverage
IntelliSense Overview
Customizing IntelliSense in Visual FoxPro
How to: Create IntelliSense Scripts
How to: Edit IntelliSense Records
How to: Restore the Default IntelliSense Table
IntelliSense Table Structure
How to: Activate or Disable IntelliSense
How to: Set IntelliSense Options
How to: View IntelliSense When Writing Code
IntelliSense Activator, Navigation, and Terminator Keys
IntelliSense Auto MRU (Most Recently Used) Files
IntelliSense Auto Table, Field, and Variable Names
IntelliSense Support in Visual FoxPro
IntelliSense Syntax Completion
Using the Component Gallery
Component Gallery Catalogs
Component Gallery Class Library (Vpfgallery.vcx)
Component Gallery Object Members
Component Gallery Table Structure
How to: Customize the Component Gallery
How to: Manage Projects with the Component Gallery
Utility Programs
Code Analyzer
Hierarchies Tab, Code Analyzer
Symbols Tab, Code Analyzer
Cpzero.prg
Filer.dll
Gendbc.prg
Genhtml.prg
HexEdit
How to: Add a Label Definition Using Addlabel.app
Customizing the Task List Manager
How to: Create Bookmarks and Task List Shortcuts
How to: Customize the Toolbox
How to: Operate the Command Window
How to: Use the Accessibility Browser
How to: Use the Automated Test Harness
How to: Use the Task List Manager
Using the Object Browser
Overview of Visual FoxPro Features
Advantages of More Power
Application Development with Several Developers
Client/Server Solution Development
Interaction with Other Applications
Rapid Application Creation
User Interface Creation without Programming
Programming in Visual FoxPro
Accessing APIs
Accessing the Visual FoxPro API
Access to Visual FoxPro Variables and Fields
Creating Visual FoxPro Dynamic-Link Libraries
FoxInfo Structure
FoxTable Structure
How to: Add Visual FoxPro API Calls
How to: Build and Debug Libraries and ActiveX Controls
How to: Create a Basic ActiveX Object
How to: Manage Memory
How to: Return Values from ActiveX Controls and FLL Libraries
Library or ActiveX Object Creation
Memory Management Using the Visual FoxPro API
Parameters in External Libraries
Passing Parameters to Visual FoxPro API Functions
Extending Visual FoxPro with External Libraries
Accessing External Libraries
How to: Access a Visual FoxPro Library
How to: Access ActiveX Controls and Objects
How to: Access Dynamic-Link Libraries
Passing Parameters to Dynamic-Link Libraries
Object-Oriented Programming
Understanding the Event Model
Event Binding for Objects
Event Binding for COM Objects
Event Binding for Visual FoxPro Objects
Considerations for Event Code
Event Sequence in Visual FoxPro
Events in Visual FoxPro
How to: Track Event Sequences
Working with Classes in Visual FoxPro
Managing Classes and Class Libraries
Operating the Class Browser
How to: Customize the Class Browser
How to: Filter the Class Browser Class List
How to: Run the Class Browser
How to: View Class Definition Code
How to: View Class Hierarchies
How to: Add Classes and Subclasses to Class Libraries
How to: Copy Classes Between Class Libraries
How to: Create Class Libraries
How to: Open Class Libraries
How to: Redefine Parent Class Relationships
How to: Remove Classes from Class Libraries
How to: Rename Classes in Class Libraries
How to: View Type Library Information
Access and Assign Methods
Base Classes in Visual FoxPro
Classes in Visual FoxPro
Considerations for Creating Classes
How to: Add Classes to Visual FoxPro Tools
How to: Add Code to Methods and Events
How to: Add Methods to Classes
How to: Add Properties to Classes
How to: Create Access and Assign Methods
How to: Create Classes and Subclasses
How to: Implement Strong Typing for Class, Object, and Variable Code
How to: Modify Class and Class Member Attributes
How to: Modify Classes
How to: Remove Properties and Methods from Classes
How to: Specify Design-Time Appearance for Classes
Overriding and Calling Parent Class Code
Overriding Default Property Settings
Protecting and Hiding Class Members
Subclasses in Visual FoxPro
Working with Objects in Visual FoxPro
Adding Objects to a Container Class
Container Hierarchy Object Referencing
Creating Objects from Classes
Creating Table Navigation Buttons
Data Storage with Objects
Defining a Grid Control
How to: Add Classes to Forms
How to: Add Controls to Forms with the Class Browser
How to: Add Objects to a Control or Container Class
How to: Call Methods
How to: Create Instances of Classes with the Class Browser
How to: Set Properties
Object and Data Integration
Object and Member Arrays
Object Reference Creation
Objects in Visual FoxPro
Passing Data to Parameters
How to: Pass Data to Parameters by Reference
How to: Pass Data to Parameters by Value
Working with Procedures and Functions
How to: Call Procedures and Functions
How to: Create Procedures and Functions
Parameters in Procedures and Functions
Returning Data from Procedures and Functions
User-Defined Procedures and Functions
Verifying Data Passed to Procedures and Functions
Working with Programs
How to: Create Programs
How to: Edit Programs
How to: Format Code in Programs
How to: Run Programs
How to: Save Programs
Basic Programming Concepts
How to: Create Quit Routines
What's New in Visual FoxPro
Changes in Functionality for the Current Release
Class Enhancements
Data and XML Feature Enhancements
Enhancements to Visual FoxPro Designers
Guide to Reporting Improvements
Interactive Development Environment (IDE) Enhancements
Language Enhancements
Miscellaneous Enhancements
SQL Language Improvements
Visual FoxPro New Reserved Words