Wiki Home

VFP Articles Online

Namespace: WIN_COM_API
Here's a page to provide links to useful VFP Articles that have been posted Online.

--- A ---

VFP and Accounting - Part I, by Rafael Copquin (Mar.2007 UT Mag)

A print job to call your own, by Lisa Slater Nicholls (Oct.2005)
VFP handles a single REPORT FORM run, or a set of REPORT FORM commands chained with NOPAGEEJECT, as a single print job -- but sometimes youíd like to send additional printing instructions in mid-report-run. Lisa shows you how to use some of VFP 9.0ís reporting enhancements to tackle this common task, and others like it, with a print job under your direct control.

A utility to document your Crystal reports, by Mike Lewis Consultants Ltd. (May 2007)

Avoiding The "Cannot call SetFocus from within a When, Valid..." Error Message by Carl Warner. Shows the simple way in VFP9 to stay within a VALID event and return the focus to a form object. 2008.

Avoiding Table and Index Corruption, by Craig Berntson (May 2001)

Add security to your data with the Crypto API, by Alex Feldstein (March 2002)

Adding IntelliSense to Runtime Applications and Favorites for IntelliSense by Doug Hennig. This article, a compilation of articles originally published in the August and November 2005 issues of Fox Talk, describes how to add IntelliSense to runtime applications and how to control IntelliSense so it only shows the properties, events, and methods you're interested in seeing, providing a lot more control over IntelliSense than you normally get. Updated 2006/11/22.

Automatic Application Updates over the Web with Visual FoxPro 7.0, by Rick Strahl (Jun.2002)

Automating Microsoft Word by Tamar Granor. (2001)

Automating Outlook with Visual FoxPro, by Ted Roche (2003)

Advantage Database Server for Visual FoxPro Developers by Doug Hennig (free special issue of Fox RockX, April 2008)

--- B ---

Best Practices for User Interfaces, by Tamar Granor (GLGDW 2006)

Bind Events for Better Applications, by Tamar Granor (SWFox 2011, German DevCon 2012)

Building a VFP & Google Mashup, by Barbara Paltiel (Mar.2007 VFUG newsletter)

Building a Web Data Service with Visual FoxPro, by Rick Strahl (Mar.2004)

Building and Using VFP Developer Tools by Doug Hennig. In addition to being the best darn database management system available, VFP also gives us the ability to highly customize the interactive development environment (IDE). You can modify the menu, install new builders and wizards, implement developer toolbars, change the behavior of the Project Manager, and do lots of other things to make your IDE more productive. Even better is that all of this customization is done in the language we all know and love, so we donít have to have some C++ guru create add-ins for us. Even relatively inexperienced VFP developers can customize their environment to work the way they want. This document will show you how to create simple tools that increase productivity for you and your development team. It discusses modifying the VFP wizards and builders to provide additional or customized features, and creating your own builders using the Builder D technology included with VFP.

Building Queries in Visual FoxPro by Tamar Granor. Written as a conference white paper, this article looks at the components of a query, as well as the changes in VFP's Query Designer in VFP 8. Written in 2002.

--- C ---

Calling and Hosting FoxPro Web Services through .NET, by Rick Strahl (Jan.2007)

Collections: Managing Information the Object-Oriented Way by Tamar Granor (SWFox 2010, German DevCon 2012)

#N by Tamar Granor (SoCal 1997)

Creating a Demo Version, by Craig Berntson (May 2001)

Creating a Statusbar control with VFP 8, by Rick Strahl (Apr.2003)

Creating desktop icons for Visual FoxPro applications (VFP6 & earlier only), by Mike Lewis Consultants Ltd. (Apr.2001/Nov.2001)

Creating Helpful User Interfaces by Tamar Granor (2005) (PDF)

Creating Multi-threaded .NET components for COM Interop with Visual FoxPro, by Rick Strahl (Dec.2005)

Creating Web reports from Visual FoxPro with Adobe Acrobat Documents, by Rick Strahl (Mar.2002)

Customize the Property Sheet by Tamar Granor (2005) (PDF)

Customizing VFP's Tools by Tamar Granor. This white paper looks at ways to extend several of VFP's Xbase tools.

--- D ---

Data Scrubbing for Sea Anomalies, by John M. Miller (Jan.2002)

Data Visualization in Reports with VFP 9.0 SP2, by Colin Nicholls and Lisa Slater Nicholls (Sept.2007)
In previous versions of Visual FoxPro, the closest you could get to a custom control in the Report Designer would be some sort of OLE/Bound control, which was limited to the kinds of object data that could be embedded into a FoxPro General field.
In VFP 9.0 SP2 the range of choices has been opened up, and many more possibilities are available to the creative developer.

DBCs or free tables? The pros and cons, by Mike Lewis Consultants Ltd. (Nov.2003/Jan.2006)

Designing User Interfaces that Work by Tamar Granor (1997)

Developing Applications for Everyone by Tamar Granor. This article discusses the reasons for considering users with physical disabilities when designing a user interface, reviews ways that Windows provides support, and then looks at the design issues and VFP support for accessibility. Written in 2001.

Developing Microsoft Visual FoxPro Applications for Windows Vista by Doug Hennig (Aug. 2007). This two-part article examines the things you need to know to create Vista-compatible VFP applications. I start by briefly looking at what benefits Vista brings to users and why they may chose to move to it. I then discuss how Vista impacts applications in general and VFP applications in particular, especially when it comes to security, folder and Registry virtualization, and deployment. The second article is Using Windows Vista Features in Microsoft Visual FoxPro Applications, listed below under "U".

Digilock Activation System, by Saeed Afshari (Mar.2007 VFUG newsletter)

Driving Word and Excel from Visual FoxPro by Tamar Granor (1991)

--- E ---

Enumerate Available Drives, by Sergey Berezniker (undated)
Three code samples using 1) the DRIVETYPE() function, 2) another for VFP8 and later that returns a collection, and 3) an example using a Shell Application object to distinguish between Floppy and Removable drives.

Error Handling in Visual FoxPro by Doug Hennig. Like most things, error handling is more flexible but a lot more complex in Visual FoxPro than it was in FoxPro 2.x. While objects have Error methods to provide local error handling, how do you provide common, global error handling services to your application? How do you recover when an error occurs? This paper looks at a proven strategy for implementing error handling in Visual FoxPro applications, starting from individual controls and working up to a global error object. Updated 1999/03/16.

VFP9: Exploring and Extending Report Preview, by Colin Nicholls (Jun.2005)

--- F ---

--- G ---

Gaining Image Control in Reports, by Lisa Slater Nicholls (Apr.2006)
The ability to use image controls in reports is one of the subtler changes to the VFP 9 Report System, and it's easier than it may look. It's also ridiculously under-documented. Here is some information that will help.

Getting Assorted IP Addresses from Within VFP by Carl Warner. Covers ways to get a local IP address, the IP address for a URL, the IP address for your WAN (the internet), and whether your system is connected to the internet‎ all from inside Visual FoxPro. 2008.

Getting Started with Office Automation by Tamar Granor. Covers the fundamentals of automating the Office applications and the tools for learning about their object models. 2000.

Getting Your Head Around Business Objects by Tamar Granor. Explains what business objects are and how to create them, using a concrete example. 2009.

Graphing with Visual FoxPro, by Ted Roche (2003)

--- H ---

Handling .NET Events in Visual FoxPro via COM Interop, by Rick Strahl (Dec.2005)

The Hooks and Anchors Design Pattern, by Steven Black (Apr.2003)

How to rebuild from Class Browser's export, by Dragan Nedeljkovich (Nov.2006 UT Mag)

--- I ---

Implementing Offline Views by Doug Hennig. Offline views are an exciting new feature in Visual FoxPro 5. They allow you to "disconnect" a view from the source of its data so data entry can continue while the tables the view is based on are unavailable, and then update the tables when the view is "reconnected" to the database. Obvious uses for this are laptop applications which allow querying and data entry on the road and dial-up applications that minimize line charges. However, this paper will also discuss another interesting use of offline views: permitting data entry to carry on while table maintenance (reindexing, updating structures, packing, etc.) is being done. Updated 1998/11/01.

Integrating Crystal Reports with Visual FoxPro, by Craig Berntson (Jan.2003)

In-Your-(Inter)Face, by John Koziol (Dec.2006 UT Mag)

Introduction to Visual FoxPro, by Ted Roche (2002)

Introduction to Database Design, by Ted Roche (2004) (PDF)

Introduction to Object Oriented Programming, by Craig Berntson (2004) (PDF)

Invoke a Quick Thermometer Bar for your Apps by Carl Warner. Covers a very basic quick and dirty way to invoke a thermometer or progress bar from within a Visual FoxPro application. 2008.

--- J ---

Joins and Subqueries: Using SQL Commands for the Hard Stuff by Tamar Granor (SWFox 2011)

--- K ---

Killing Objects, by Oscar Zarate (Mar.2007 UT Mag)

--- L ---

Limiting Simultaneous Users, by Craig Berntson (May 2001)

--- M ---

Making the Most of SQL-SELECT by Tamar Granor (1999)

Making the Most of the Toolbox, by Tamar Granor (2007) (PDF).

Managing VFP Class Libraries, by Steven Black (undated)

Memo and Index File Bloat, by Craig Berntson (Mar.2000)

Multi-user and Data Buffering Issues by Doug Hennig. In FoxPro 2.x, developers edited records using SCATTER MEMVAR, editing the memory variables, and GATHER MEMVAR. The purpose of this indirect editing of fields was to protect the record by buffering it. With Visual FoxPro, data buffering is built in, so fields can be edited directly. This document discusses how data buffering works and explores strategies for selecting which buffering mechanism to use and how to handle multi-user conflicts.

--- N ---

N-Tier Application Design by Doug Hennig. This is the article and source code for Doug's article, N-Tier Application Design, that appeared in the Summer 2000 issue of Code Magazine. Updated 2002/03/25.

New Language Features in VFP 6 by Tamar Granor (1998).

New Language Features in VFP 7 by Tamar Granor (2000).

--- O ---

Object Orientation In FoxPro, by Gregory L. Reichert (Jan.1995)

Object-Oriented Menus by Doug Hennig. This article, originally published in the August 2001 issue of Fox Talk, describes how to create object-oriented menus in VFP. Updated 2002/04/13.

Office Automation Beyond the Basics by Tamar Granor. Originally written as a conference white paper, this article addresses some of the issues you run into automating Microsoft Office, once you've gotten beyond the "create a server, add a document, put something in it" stage. Among other things, it looks at differences among the servers. Written in 2003, updated in 2004.

Office Automation Tips, Tricks and Traps by Tamar Granor (SWFox 2010)

OLE DB Provider for VFP9: Three Ways To Change Session Settings, Useful When One Way Seems Not To Work by Carl Warner. Covers multiple ways to override VFP session settings when using the OLE DB Provider for VFP9. 2008.

--- P ---

Passing objects between FoxPro and .NET COM Components, by Rick Strahl (Dec.2005)

PDF Power to the People, by Lisa Slater Nicholls (Jun.2005)
PDF document output is one of the most often-requested enhancements to Visual FoxPro, but it is not available out-of-the-box. In this article, originally published in Fox Talk, Lisa shows you how to generate PDFs in all versions of FoxPro, and showcases some VFP 9.0 techniques and print-related features that can make PDFs easier to create now than in any previous version.

Performance Tuning Tips in Microsoft Visual FoxPro, by Erik Svenson, Microsoft Corporation (1997)
This document is intended to provide you with practical tips and techniques for improving the performance of your applications. By applying these techniques to your applications appropriately, you can make significant improvements to your user interface and data access performance.

Practical Tips for Working with Existing Applications, by Tamar Granor. Covers a variety of tips and tricks for working with an inherited application. 2007, 2008.

Primary Keys, by Craig Berntson (May 2001)

Providing Cut/Copy/Paste in Your Application, by Craig Berntson (May 2001)

Putting the Task Pane Manager to Work, by Tamar Granor. This article covers both using and extending the Task Pane Manager, introduced in VFP 8. 2003, 2004.

--- Q ---

The Basics of Querying in FoxPro with SQL SELECT, by ? (Aug.1996)

--- R ---

REPLACE FOR ErrorIn(REPLACE), by Christof Wollenhaupt (Apr.2008)
REPLACE is one of those 174 commands in Visual FoxPro that looks easy at first glance. The only easy thing about REPLACE, though, is the easiness of introducing subtle errors in your code.

Report Objects by Doug Hennig.
This article describes how a set of classes can expose the VFP report (FRX) file as objects. This allows you to manipulate reports programmatically simply by setting properties and calling methods. Updated 2000/04/12.

Reporting -- Converting Data into Information, by Andrew Coates (Mar.1999)

VFP 9.0 Reporting System Fundamentals, by Colin Nicholls (Feb.2007)
One important thing about VFP9 is that it is the first version in which fundamental components of the reporting system have been implemented in the FoxPro language itself. FoxPro has always featured an extensible development environment.... Up until version 9.0, the reporting engine in FoxPro has always been a "black box", implemented in Visual C, with the internals hidden from view. As a result of the 9.0 re-write (in Visual C++ and FoxPro), a new array of techniques are available to the developer to create new kinds of report output. (Based on a whitepaper prepared for OxFox 2007 and refined for LA Fox Bootcamp 2007.)

RSS for VFP Programmers, by Ted Roche (2004) (PDF)

RSS: XML Publish and Subscribe Using Visual FoxPro, by Ted Roche (Apr.2004)

RSS: Publishing News via XML, by Ted Roche (Apr.2004)

Running VFP 9.0 SP1 apps on Windows Vista, by Markus Winhard (May 2007)

Rushmore Opitimization, by Craig Berntson (Jul.2001)

--- S ---

Security in FoxPro (protecting application and data), by Christof Wollenhaupt (date not specified)

Software Licensing: EULA vs. GPL, OSI, Open Source, and Free Software, by Ted Roche (2003) (PDF)

Solving Common Problems with VFP's SQL, by Tamar Granor (2006) (PDF)

The Straight POOP: Event binding and loose coupling, by Nancy Folsom (Mar.2002) (PDF)

Structured Error Handling Matrix, by Randy Pearson (Dec.2002/Aug.2006)

--- T ---

Taking Advantage of ADSI, by Paul Mrozowski (Winter 2001) (VFP7)

Taming the VFP report preview window, by Mike Lewis (Dec.2007)
When you preview a report in Visual FoxPro, the standard output provided is disliked by most users, to such an extent that developers often feel compelled to find alternative ways of displaying their reports on the screen.

Techniques for alternate Report Previews in VFP 9.0, by Colin Nicholls (Aug.2005)

Text and String Handling in VFP, by Steven Black (undated)

Top 10 (or more) Reasons to Use the Toolbox, by Tamar Granor. Shows ways that the Toolbox makes everyday application development in VFP easier. 2009.

--- U ---

User Interface Design in Visual FoxPro, by Jim Booth (undated)

Using Crystal Reports with VFP, by Craig Berntson (May 2001)

Using SQL-SELECT Effectively by Tamar Granor (1997).

Using the Debugger Effectively by Tamar Granor. This paper covers the various components of the Debugger and shows how to put them to work.

Using the Software Update Wizard with Visual FoxPro by Mike Lewis (August 2011). The Software Update Wizard is a component that helps you add "over the web" updating to your applications. This article describes the product, and shows how to implement it in VFP.

Using the Windows Event Log from Visual FoxPro, by Craig Berntson & Cole Gleave (2004/2005)

Using the Windows Shell API and Internet Explorer Controls in Visual FoxPro Desktop applications, by Rick Strahl (Sep.2004)

Using Unicode in Visual FoxPro Web and desktop Applications, by Rick Strahl (Jan.2005)

Using Visual FoxPro ActiveX Controls by Doug Hennig. VFP includes a lot of ActiveX controls that can add great features to your applications. Many of these, including the Tree View, List View, StatusBar, and Common Dialog controls, allow you to create a Windows 9x interface for your applications. However, the documentation for these new controls is sparse or misleading, and the examples are all in Visual Basic. This paper focuses on how to use these controls in Visual FoxPro, gives example of when they're useful, and discusses the most commonly used properties, events, and methods so you can customize their appearance or behavior. Updated 1999/09/10.

Using Visual FoxPro to call .Net Web Services for Data Access, by Rick Strahl (Oct.2004)

Using VFP's SQL Commands in VFP 9, by Tamar Granor (2004) (PDF).

Using Windows Vista Features in Microsoft Visual FoxPro Applications by Doug Hennig (Oct. 2007). With the rollout of Windows Vista, we have to think about new and modern ways to display and present information in VFP applications. The new version of Windows gives us far more configuration power then before, but it requires us to spend some extra time to learn all the new features in Vista. In the first of this two-part article on how to create Windows Vista-compatible VFP applications (Developing Microsoft Visual FoxPro Applications for Windows Vista, listed above under "D"), I discussed the ways Vista impacts VFP applications, with a focus on security, folder and Registry virtualization, and deployment. In this article, I go over opportunities to take advantage of new Vista features, including user interface improvements, Windows Desktop Search, RSS feeds, and XML Paper Specification.

Using XmlAdapter to Create and Load Nested XML, by Sergey (Jan.2008) Sample code.

--- V ---

VFP Automates, by Ted Roche (May 2003)

VFP menus and XML, by Rafael Copquin (UTMag Sep.2006)

Visual FoxPro Coding Standards, by Craig Berntson (Sep.2003)

Visual FoxPro Quirks by Tamar Granor (1999).

--- W ---

We Used to Do It That Way, But ..., by Tamar Granor. Looks at newer ways to do a wide variety of tasks in VFP. 2008.

Whatís my (IP) Address?, by Paul Mrozowski (Aug.2001) (PDF)

The Why and How of Test Data, by Tamar Granor. (2007) (PDF)

--- X ---

--- Y ---

You Need Arrays by Tamar Granor. This article covers the fundamentals of VFP's arrays, and looks at the built-in functions for working with them, and those that rely on them. Written in the VFP 7 era.

--- Z ---

Category Learning VFP
title, by author (date)
Also see White Paper Directory
( Topic last updated: 2013.04.11 09:29:58 AM )