Andy is an independent consultant and long-standing FoxPro
developer. After many years working in England and mainland Europe Andy moved to Ohio
at the beginning of 2001. As well as having been a Microsoft Most Valuable Professional
every year since 1998 he is also a Microsoft Certified Professional for Visual FoxPro
in both Desktop and Distributed applications. Andy has been active for many years
on the FoxPro support forums on Compuserve, where he is a SysOp and on the Virtual
FoxPro User Group and Foxite.com.
He has spoken at User Groups and Conferences all over the world and conferences include Southwest Fox (Tempe, 2004, 2005), GLGDW (Milwaukee 2000, 2001, 2002, 2003, 2006), European Devcon (Frankfurt 2001, 2002, 2003, 2005), Essential Fox (Kansas City, 2002, 2003, 2004), Praha Devcon (Prague, 2002, 2005), CTTM( Amsterdam, 2000, 2002), OzFox (Sydney, Australia 2003) and Advisor DevCon (2001, 2002).
In addition to helping write white papers on Visual FoxPro 7.0 for Microsoft, his published work includes "The Revolutionary Guide to Visual FoxPro OOP", Wrox Press, 1996. Together with Marcia Akins and Rick Schummer, he co-wrote the very successful "1001 Things You Wanted to Know About VFP" also known as “KiloFox” (which won the Universal Thread Members Choice Award 2001 for Best VFP Book). The same writing team followed up with “MegaFox: 1002 Things You Wanted to Know About Extending Visual FoxPro” which was published in November of 2002. He has co-authored the monthly "Kitbox" column in FoxTalk Magazine since April 1998 partnered by Paul Maskens until December 2001, and then with his wife, Marcia Akins. He has more than 70 articles in this series to his credit.
You can reach Andy at: AndyKr@TightlineComputers.com
Metadata to the Max
The technique of storing code snippets in metadata has long been popular with VFP developers and has a pedigree that extends back to the earliest versions of FoxBase. The ability to define highly functional classes in code offers the prospect of embedding not just snippets, but blocks of functional code, as objects in metadata and compiling them 'on the fly' when needed. The most significant benefit of this technique is that it allows for functional changes to be made to an application without needing to re-compile any code, or even stop the application. Since the metadata is only ever read from by the application core updates can be made while everything is running.
Attendees will learn how to:
1. Implement an Abstract Factory pattern
2. Create a COM+ compliant DLL
3. Write generic code to extract and compile object definitions 'on the fly'
4. Handle the instantiation and clean-up of transient middle tier objects
5. Implement a novel variant on the traditional three-tier architecture
Skill level: Intermediate
Suggested prerequisites: Familiarity with defining objects in code and working with COM DLLs.
Advanced SQL Queries with VFP 9.0
As Visual FoxPro developers we are all very familiar with using Structured Query Language (SQL) to retrieve, add, update and delete data from a database. However we often forget that SQL is an extremely powerful and potent weapon in our developer's arsenal. The purpose of this session is to illustrate some more advanced techniques involving SQL that can be implemented directly in Visual FoxPro Version 9.0. The session covers Uncorrelated and Correlated Sub Queries, Derived Tables and Computed columns and offers some general advice on techniques for defining complex queries.
Attendees will learn:
1. How and When to use Uncorrelated Sub Queries
2. How and When to use Correlated Sub Queries
3. How and When to use Derived Tables
4. How and When to use Computed Columns
5. How to tackle creating complex queries for reporting
Skill level: Foundation
Suggested prerequisites: None