A fast-paced practical course covering the advanced features of VFP

Designed for experienced VFP developers, this course will help you create sophisticated applications which take full advantage of VFP's advanced features. The focus is on integration within the Windows environment. Client/server, Internet, OOP and user interface issues are also fully covered.

WHAT YOU WILL ACHIEVE

At the end of the course, delegates who meet the pre-requisites will be able to develop sophisticated applications which fully exploit Visual Foxpro's advanced features. You will also learn how to work with back-end databases, and how to approach the development of Internet-based applications.

PRE-REQUISITES

To benefit from the course, you should have at least six months experience of developing VFP applications. You should also be familiar with the topics covered in our Stage 2 course, especially VFP's OOP features.

COURSE CONTENTS

• Introduction to client-server concepts and terminology.
• Using ODBC to connect to back-end databases.
• Remote views vs. SQL pass-through.
• Design issues; optimizing data access.
• The development process: prototyping with local views.

• Overview of API functions, calling sequences and data types.
• Using API calls to extend your application's functionality.
• Getting information about the Windows environment.
• Accessing and updating the Windows Registry.

• Understanding ActiveX Automation, COM and DCOM.
• Using ActiveX Automation to integrate with Microsoft Office: the Office object model.
• Sharing documents with Word; using Word for spell-checking and mail-merge.
• Passing data to and from Excel; calling Excel's workbook functions.
• Working with registered document types; using ShellExecute().
• Working with Outlook folders.
• Exploiting the Windows Scripting Host.
• Calling VFP functions from other applications and languages.

• Overview of available controls.
• How to acquire, deploy and register controls; dealing with common problems.
• Some examples of ActiveX controls: date-picker, tree-view, list-view.

• Adding a browser to the application.
• Publishing VFP data as static web pages.
• Sending and receiving e-mail from within the application.
• Using the Internet Transfer Control for FTP and HTTP transfers.
• Developing web-based VFP applications with FOXISAPI.

• Planning, designing and building a sound class library; communicating between classes.
• Using polymorphism to simplify class design.

• Techniques for developing a sound, consistent and friendly user interface.
• Progress-reporting; interrupting the event loop.

VERSION

The course is designed for Visual FoxPro 7.0. About 60 percent of the material is also relevant to VFP 5.0 and 6.0. 

MICROSOFT CERTIFICATION

Between them, our Stage 2 and Stage 3 courses cover 80 percent of the requirements for Exam 70-156 (Visual Foxpro Desktop) and 70 percent of those for Exam 70-155 (Visual Foxpro Distributed). As a  matter of policy, we no not use official Microsoft course material. All courses are taught by a Microsoft Certified Professional, qualified in Visual Foxpro.