Registration: Click here to register for this class.

Duration: 2 days

Prerequisites: Basic familiarity with databases (FoxPro, dBase, Access, Paradox, etc.) Knowledge of a programming language helpful, preferably an xBase language (FoxPro, dBASE, Clipper, etc.) or a BASIC language (Visual Basic, Quick Basic, or Access).

This course is designed for developers new to Visual FoxPro. The class covers material from Visual FoxPro 9, as well as Visual FoxPro 7 & 8. All three versions are installed on the computer provided for each attendee.

In this hands-on, instructor-led course, attendees are introduced to the Visual FoxPro development environment. Participants will learn how to create databases and tables, as well as how to effectively use all the data dictionary features such as default field values, input masks, persistent relationships, referential integrity, stored procedures and triggers. In addition, participants will learn how to build and manage projects with the Project Manager. Also covered is the Visual FoxPro Application Wizard, the Foundation Classes, the Component Gallery, and new language enhancements.

Programming topics include building and running program files, working with memory variables, controlling program execution, and calling subroutines. Additional topics covered include building forms with the Form Designer, building reports with the Report Designer, and build queries with the Query Designer.

The Visual FoxPro Desktop
Menu Options
The Command Window
Tools | Options Dialog
The Standard Toolbar
Wizards
Accessing Help

Working With the Application Wizard
Running the Wizard
Specifying Databases
Specifying Tables
Generating Forms and Reports
Running the Application

Working With the Project Manager
Adding Files
Modifying Files
Deleting Files
Running Files
Building Projects

Working with Tables and Databases
Using the Database Wizard
Database Container
Table Designer
Input Mask, Format and Other Field Properties
Free vs. Attached Tables
Adding, Editing & Deleting Records
Indexes: Primary & Candidate
Relationships: Persistent & Temporal
Referential Integrity
Data Buffering Basics
TABLEUPDATE() and TABLEREVERT()

Working With Program Files
Using the Editor
Color Coding Syntax
Executing Programs
Procedure List
Object List
Beautify

Working With Variables
Naming Conventions
Scoping: Public, Private & Local
Arrays

Program Control Structures
If..Else..EndIf
Do While...EndDo
Scan...EndScan
Do Case...EndCase
For...EndFor
For Each...EndFor

Procedures and Functions
Calling Subroutines
Returning Values
Passing Parameters by Value
Passing Parameters by Reference

Creating and Using Reports
Bands
Data Environment
Report Expressions
Previewing Reports
Totals & Subtotals
REPORT FORM Command

Creating and Using Forms
Form Designer
Toolbars
Form Controls
Control Properties
Tab Order
Tool Tips

Working With the Query Designer
Joining Fields
Outer Joins
Adding Fields
Setting Selection Criteria
Ordering Results
Specifying Output Destination
SQL Review

Course Prerequisites

Basic familiarity with databases (FoxPro, dBase, Access, Paradox, etc.)

Experience with the Windows environment, including the use of the mouse and common keyboard actions such as cut, copy and paste.

Knowledge of a programming language helpful, preferably an xBase language (FoxPro, dBASE, Clipper, etc.) or a BASIC language (Visual Basic, Quick Basic, or Access).