Introduction to Visual FoxPro 6.0

 

Course Overview

This two-day course is designed for developers new to Visual FoxPro. In this course, the student will be introduced to the Visual FoxPro 6.0 development environment. The student will learn how to create and maintain databases and tables. All the data dictionary features such as default field values, input masks, persistent relationships, referential integrity, stored procedures and triggers are covered. The student will also learn about the Project Manager and how to use it effectively. Also covered is the new VFP 6.0 Application Wizard and the associated development framework, the Component Gallery, catalogs such as the World Wide Web and ActiveX catalogs, the Foundation classes and new language enhancements. Programming topics include building and running program files, working with memory variables, controlling program execution, and calling subroutines. Topics also covered include working with the Form Designer, the Report Designer, and the Query Designer. Upon completion of the course, the student will keep the course materials and will receive a diskette containing all the course examples and exercises

 

Course Outline

Development Interface

  • Command window
  • System menus
  • Standard Toolbar
  • VFP Environment Settings

Using the Project Manager

  • Adding Files
  • Modifying Files
  • Deleting Files
  • Running Files
  • Building Projects

Data Interface

  • Database Container
  • Table Designer
  • Free vs. Attached Tables
  • Adding, Editing & Deleting Records
  • Indexes: Primary & Candidate
  • Relationships: Persistent & Temporal
  • Referential Integrity
  • Data Buffering Basics
  • TABLEUPDATE() and TABLEREVERT()
  • Stored Procedures
  • Triggers

Variables and Constants

  • Data Types
  • Operators
  • Assigning values
  • Data Conversion
  • Date math
  • Arrays
  • Constants
  • Scoping Public, Private and Local

Program Creation

  • Naming Conventions
  • Creating/Modifying programs
  • VFP Editor
  • Procedures
  • Functions
  • Parameters

Program Control Structures

  • If..Else..EndIf
  • Do While...EndDo
  • Scan...EndScan
  • Do Case...EndCase
  • For...EndFor
  • For Each...EndFor
  • IIF()
  • DO
  • Commenting code

Creating and Using Reports

  • Bands
  • Data Environment
  • Report Expressions
  • Previewing Reports
  • Totals & Subtotals
  • REPORT FORM Command

Creating and Using Forms

  • Form Designer
  • Dataenvironment
  • Toolbars
  • Form Controls
  • Control Properties
  • Tab Order
  • Tool Tips

Query Designer

  • Joining Fields
  • Outer Joins
  • Adding Fields
  • Setting Selection Criteria
  • Ordering Results
  • Specifying Output Destination
  • SQL Review