The Basic Programming Course
Visual FoxPro®
Programming |
The Basic
Programming Course
Data Representation
| Data Types | The Data Dictionary |
| Database Containers | Referential Integrity |
| Database Tables & Free Tables | Validation Rules |
| Indexing | Triggers |
| Persistent Relationships | Hands-on Lab Session |
The Object Oriented Methodology
| Object Oriented Programming Concepts | Events |
| Classes | Methods |
| Sub-classes | Protected Properties |
| Properties | Variables |
Event Driven Programming
| Creating Classes | Creating Sub-classes |
| Class Libraries | The Class Browser |
| Container, Control and Custom Classes | Using Protected Properties & Methods |
| Adding Objects to Classes | Event Programming |
| Class Instantiation | Accessing Controls |
| Class Replication | Hands-on Lab Session |
Creating Visual Forms
| Form Sets | Relation Objects |
| Saving Forms as Classes | Data Sessions |
| Setting Properties | Page Frames |
| Accessing Objects on Different Forms | Adding Controls to Pages |
| Access & Assign Methods | Programmatic & OLE Drag-and-Drop |
| The Data Environment | Drag-and-Drop Moving vs. Copying |
| Cursor Objects | Hands-on Lab Session |
Working with the Grid
| Definition and Components | Coding Events |
| Adding Controls | Modifying Programmatically |
| Setting Fixed & Dynamic Properties | Using Effectively |
| Bound and Unbound Controls | Hands-on Lab Session |
Multi-user Programming
| Data Handling Requirements | Managing Network Conflicts |
| Table and Record Locking and Unlocking | Updating Data Effectively |
| Automatic vs. Manual Locking | Reverting Data Changes |
| Table and Record or Row Buffering | Transaction Processing |
| Buffering Modes | Programming Issues |
| Working with Buffered Data Effectively | Hands-on Lab Session |
Creating Reports
| Elements of the Rport Designer | Formatting Options |
| Creating a Title Page | Adding Pictures to a Report |
| Creating a Summary Page | Printing Variable Length Data |
| Using Group Headers and Footers | Creating Floating Controls |
| Using Report Variables | Hands-on Lab Session |
Using Dynamic Link Libraries (DLLs)
| Definition of Dynamic Link Libraries | Passing Arguments by Value or Reference |
| Using DLLs | Null Pointers |
| Accessing the Windows 32 API | Hands-on Lab Session |
Error Handling & Debugging
| Effective Error Handling | Saving Debugging Information |
| Using the Debugger | Hands-on Lab Session |
Creating & Using Automation Servers - COM Components
| Creating Automation Servers | Remote Automation Servers |
| Automation Server Types | Configuring the Client |
| Class-specific Instancing | Authentication in Remote COM Components |
| Registering an Automation Server | Troubleshooting |
| Using Automation Servers | Hands-on Lab Session |
Wizards & Builders
| Definition of a Wizard | Definition of a Builder |
| Types of Wizards | How to Create Your Own Builder |
| How to Create Your Own Wizard |
Putting it all Together - the Class Project - Creating an Application
| Using the Project Manager | Using One-to-Many Data in Forms |
| Creating Menus and Forms | Adding, Modifying and Deleting Data |
| Using Pageframes and Pages | Using Multi-user Programming Concepts |
Client/Server Programming Course
Developing Client/Server Applications
| The Connection Designer | Synchronous vs. Asynchronous Processing |
| Establishing Connections Programmatically | Batch and Non-batch Modes |
| SQL Pass-through Connections | Fetching Data |
| Local and Remote Views | Setting Cursor Properties |
| Using the View Designer | Updating Data on the Server |
| Creating Views Programmatically | Developing a Model |
| Parameterized Views | The Upsizing Wizard |
Programming Using Views and Cursor Adapters
| Lab 1: Develop an Application in Class using Views. | Lab 2: Develop an Application in Class using Cursor Adapters. |
Programming Using Stored Procedures
| Creating Stored Procedures | Using SQL Server DTS |
| Lab 3: Develop an Application in Class using SQL Server Stored Procedures |
Visual FoxPro is a registered trademark of
Microsoft, Inc.