In Level 2, you will learn to incorporate common coding standards, understand how to create and manipulate variable arrays, and understand and apply recursive programming techniques. You will use the IntelliSense Manager to customize IntelliSense, work with the FoxPro Data Manipulation Language, and understand the FoxPro SQL Implementation. Optimize queries with the Rushmore(tm) technology in Visual FoxPro. Use the Visual FoxPro Database Container to enforce data integrity and edit data with Updatable Views. You will recognize and solve the design issues involved in multi-user programming, increase the flexibility and maintainability of your applications as you begin to master object-oriented programming. View and manage class libraries using the Class Browser.
Visual FoxPro Training Prerequisites
Programming Fundamentals of Visual FoxPro 7.0 - Level 1.
Visual FoxPro Training Audience
Web designers and administrators.
Visual FoxPro Training Course Duration
3 Days
Visual FoxPro Training Course outline
Programming
- Programming Concepts
- Arrays
- Recursion
- Customizing IntelliSense
The Visual FoxPro Data Manipulation Language
- Work Areas
- Data Sessions
- Table/Data Oriented Commands and Functions
Structured Query Language
- Why Use SQL?
- SQL SELECT
- SQL UPDATE
- SQL DELETE
- SQL INSERT
- SQL CREATE
- SQL ALTER TABLE
The Database Container
- What Is a Data Dictionary?
- Using the Database Container
- Table Options
- Database Events
- DbGetProp() and DbSetProp()
- The GENDBC Program
Enforcing Data Integrity
- Types of Data Integrity
- Entity Integrity
- Domain Integrity
- Referential Integrity
Updateable Views
- Updateable Views
- Creating Views Programmatically
- Performance
Multiuser Programming
- What's the Real Challenge in a Multiuser Environment?
- Managing Contention for Resources
- Implicit vs. Explicit Locking
- Buffering Data
- Data Functions in Visual FoxPro
- Transaction Processing
- Resolving Conflicts
Introduction to Object-Oriented Programming
- A Word About OOP
- Understanding Object-Orientation Terminology
- Analysis and Design in an Object-Oriented World
- Using the Visual FoxPro Tools for Class Design
- Defining Classes Programmatically
- Access and Assign Methods
- Instancing Objects Programmatically
Working with Classes
- Viewing Classes in the Class Browser
- Managing Classes with the Class Browser
Form Design
- Coding Methods in a Reusable Way
- Grids
- Page Frames
- Timers
- OLEBoundControl and OLEControl
