Premium Videos

Learn more advanced topics by purchasing a subscription to our premium videos below.

OOP In Bite Sizes- Pt 1

This video is the first in the series that helps the user to understand developing Object Oriented applications in VFP.

Video Length: 00:31:16

View | Download

OOP In Bite Sizes- Pt 2

This second video in the series walks the viewer through creating a simple class; understanding core event methods and finally, building a simple xml generater class.

Video Length: 00:54:24

View | Download

OOP In Bite Sizes- Pt 3

In this video we take a look at inheritance (or subclassing). We also look at redefining the base classes provided by VFP and talk about why you would want to do this. Finally I show you how to have VFP automatically use your classes when you drag and drop fields unto a form.

Video Length: 00:28:38

View | Download

OOP In Bite Sizes- Pt 4

In this video we talk a little bit about data hiding (encapsulation) which relates to the visibility of properties and methods in our classes. The highlight of this video shows how to create special event methods to test when a user attempts to access or change a property value. This is accomplished by using the ACCESS and ASSIGN method suffixes.

Video Length: 00:43:11

View | Download | Source

OOP In Bite Sizes- Pt 5

We get practical in the next series of videos and create a few reusable components. In this video we create a navigational component that can be dropped unto any form.

Video Length: 00:17:59

View | Download

OOP In Bite Sizes- Pt 6

In this video we continue to create components. Here we look at the ToolBar control and working with FORMSETs.

Video Length: 00:14:32

View | Download

OOP In Bite Sizes- Pt 7

Want to see how to build an autocomplete combo box? Check out this video.

Video Length: 00:27:34

View | Download | Source

The Grid Master

See how to embed a combobox, checkbox or spinner control in a grid.

Video Length: 00:40:32

View | Download

Building a Simple Object Oriented Application - Pt 1

This first video in the series looks at converting an existing quasi-procedural based application, demonstrating how to convert it to an object oriented application, resulting in a completely class-based as opposed to a form-based architecture.

Video Length: 00:53:32

View | Download

Building a Simple Object Oriented Application - Pt 2

In this video we create a few more custom classes and build a grid "ListView" base class for use later on in building our customer and issue list screens. This video highlights the thought process that goes into building a truly generic component. It's a lengthy video, but I think you'll find it interesting.

Video Length: 01:33:42

View | Download

Building a Simple Object Oriented Application - Pt 3

In this video we wrap up our series on object oriented design and programming constructs in VFP.

Video Length: 00:49:36

View | Download | Source

Error Handling - Pt 1

This video is the first in a four part series on error handling in VFP. The series will cover: ON ERROR, Error Events in objects/classes and the new TRY/CATCH structured error handling mechanism, introduced in VFP 8.0.

Video Length: 00:34:09

View | Download

Error Handling - Pt 2

Part Two in the series: Error Events.

Video Length: 00:21:47

View | Download

Error Handling - Pt 3

Part three in the series: TRY/CATCH structured error handling.

Video Length: 00:38:12

View | Download | Source

Distributing Your Application - Pt 1

See how to create a setup application to distribute your own VFP apps. This is a two part series, showing how distribution is done both in VFP 6.0 and VFP 9.0.

Video Length: 00:28:40

View | Download

Using ODBC and SQL PASS THRU

This video demonstrates how easy it is to connect to any ODBC compliant data source. The example uses MS SQL server, however, the concept is applicable to any database that supports ODBC.

Video Length: 00:34:51

View | Download

Distributing Your Application - Pt 2

Part two of the series, this video demontrates how to use InstallShield Express to create a basic setup package for your VFP 7, 8 or 9 applications.

Video Length: 00:37:06

View | Download

Optimizing Queries

This video provides a few tips on how to specify search expressions in order to minimize data access times using indexes and FoxPro's Rushmore Technology.

Video Length: 00:55:27

View | Download

Indexes Based On Deleted Records

This video is a follow-up to the earlier video "Optimizing Queries". Changes regarding indexes in VFP 9 are explained and compared with indexes in VFP 8 and lower. Also, a few erroneous statements from the earlier video are corrected.

Video Length: 00:22:11

View | Download

Building a Simple Indexing Utility - Pt 1

Almost all xBase application will have a need to reindex their data files from time to time. This video is a walk through on creating a simple utility that will build index data from existing tables and automatically recreate indexes (reindex) when required. This part 1 of a 3 part series.

Video Length: 00:51:35

View | Download

Building a Simple Indexing Utility - Pt 2

In this video we take the object oriented approach and wrap a class around our procedural reindexing code, in preparation for our GUI interface to be completed in part 3 of the series.

Video Length: 00:38:20

View | Download | Source

Building a Simple Indexing Utility - Pt 3a

Continuing with the OO approach, we take the reindex utility class built in the previous video and wrap a GUI around it to give the user much more control over indexing their tables.

Video Length: 00:39:59

View | Download

Building a Simple Indexing Utility - Pt 3b

In this video we modify our utility class by creating a custom event method that fires when tags are being created and using the BINDEVENT() method in the modified GUI, build a sophicated mechanism for reporting progress on the indexing process.

Video Length: 00:18:49

View | Download | Source

SQL Revisited Pt 1

In this video we revisit the SQL commands, namely: INSERT, UPDATE, DELETE and SELECT.

Video Length: 00:23:37

View | Download

SQL Revisited Pt 2

In this video we revisit the SQL commands, focusing on SQL JOINS: EQUI-JOINS, LEFT OUTER, RIGHT OUTER AND FULL OUTER JOINS.

Video Length: 00:31:30

View | Download

SQL Revisited Pt 3

In this video we address an error we encountered in the previous video dealing with OUTER JOINS.

Video Length: 00:06:15

View | Download

Using the Query Wizard

See how to build queries using the query wizard and query designer. If you're new to SQL or just prefer working from the menus, you'll find this video helpful.

Video Length: 00:40:43

View | Download

Working with Views (Local and Remote)

Views are a great help in creating client/server apps: see how to create local and remote views in this video.

Video Length: 00:55:35

View | Download

Working with CursorAdapters

See how to use a CursorAdapter instead of a Remote View to connect to a backend database and perform data queries and updates as with Remote Views.

Video Length: 00:37:12

View | Download

Multi-user Considerations Pt 1

This is the first of a two part series in which I examine a few considerations for developing a multi-user Visual FoxPro application.

Video Length: 00:30:57

View | Download

Multi-user Considerations Pt 2

This is the second video in the series where we look at implementing an OPTIMISTIC locking scheme for data updates, with a few suggestions on how to handle update conflicts when they occur.

Video Length: 00:53:55

View | Download

Multi-column reports and Labels

This video tries to answer the question on creating multi-column reports, with a brief look at labels.

Video Length: 00:11:04

View | Download

Member Classes

This video tries to answer the question of how to create custom headers and columns for the grid. Member classes introduced in VFP 9.0 makes this real easy.

Video Length: 00:15:35

View | Download

Triggers and Stored Procedures

In this video we take a look at Triggers, Stored Procs and Referential Integrity and how this is implemented in VFP.

Video Length: 00:40:08

View | Download

More on Reports

In this video we look at working with reports and variables. We also answer the question of how to place an image on your report. While at it, we take a look at groups in our report for doing sub-totals.

Video Length: 00:40:38

View | Download

Control Resizing

How do you auto resize the controls on your forms prior to the Anchor property that was introduced in VFP 9.0? Take a look at this video for the answer.

Video Length: 00:09:32

View | Download

Creating Formatted Excel Reports

See how to create formatted report from a template using Ole Automation with Excel from within VFP.

Video Length: 00:24:13

View | Download | Source

Using Business Objects Pt 1

In this series of videos we take a look at using business objects in VFP. This first video is an introduction to the topic.

Video Length: 00:32:46

View | Download | Source

Using Business Objects Pt 2

Part 2 in the series of using business object in VFP. In this video we look at how to implement simple business rule logic in our business class.

Video Length: 00:33:00

View | Download

Using Business Objects Pt 3

Part 3 in the series of using business object in VFP. In this video we look at how to implement a more comprehensive business rule manager in our business class. We also look at how to manage (dirty state)changes in our object.

Video Length: 01:13:08

View | Download | Source

User Sign On and Password Encryption

This video is a follow-up to the "Building a Simple Application" series. In it we look at creating a sign on form for the users of your application and also how to create a very simply encryption class for passwords in your tables.

Video Length: 01:06:09

View | Download | Source

Building Scalable Applications - Pt 1

This is the first in a three part series of videos that takes and introductory look at using views and cursor adapters to build scalable applications. By scalable, we mean an app that can easily be made to point to a remote database without having to recode your app and in some cases not even having to recompile your existing app.

Video Length: 00:29:59

View | Download

Building Scalable Applications - Pt 2

Here we take a look at using cursor adapters to connect to our remote data store and the advantage of the cursor adapter over the view.

Video Length: 00:16:31

View | Download

Building Scalable Applications - Pt 3

We conclude our discussion of building/designing scalable applications, with a quick look at wrapping an object oriented design around our cursor adapters to function as business objects as well as for pulling down the data.

Video Length: 00:31:44

View | Download | Source