Visual FoxPro Training : Programming Visual FoxPro 7.0 Applications

Programming Visual FoxPro 7.0 Applications - Level 2

Visual FoxPro Training Overview

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