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
|