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, recent conferences include Advisor DevCon (2001, 2002), GLGDW (Milwaukee
2000, 2001, 2002, 2003), Essential Fox (Kansas City, 2002, 2003, 2004), European Devcon
(Frankfurt 2001, 2002, 2003), OzFox (Sydney, Australia, 2003), UK VFPCon (London,
2000, 2002), CTTM( Amsterdam, 2000, 2002) and the Praha Devcon (Prague, 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
Designing a database (or how to do it right, first time)
One of the perpetual challenges that we all face from time to time the creation of a new database. This may be for an entire new application or simply to support a new module or new functionality for an existing application. Before we can even start thinking about table definitions, data normalization and referential integrity we need to ensure that the database accurately models the process (or processes) that it will have to support. It doesn’t matter whether we are using Visual FoxPro, SQL Server or some other database, getting this right is the key to a successful database implementation.
As for any other design task there are various options that can be chosen and rules that must be followed. In this session Andy explores the difference between ‘information’ and ‘data’ and the patterns that apply to database design. He covers the two separate sets of patterns, ‘Structural’ and ‘Relational’ and briefly reviews the role of rules.
If you have ever found yourself wishing that you had structured things differently to start with, or just have a new project looming, this session will be invaluable.
Level: Foundation/ Intermediate: Attendees should be familiar with the basic components of a database (tables, rules, triggers, relationships and constraints).
Implementing Design Patterns in Visual FoxPro
Design Patterns have long been a topic of interest to Visual FoxPro developers, but one of the biggest problems associated with them is that good examples of how and when to use them in Visual FoxPro are hard to find. In this session Andy addresses a number of typical development problems and shows how to implement the relevant Design Pattern to help solve them. Starting with the Bridge, he develops the theme by illustrating the Strategy, Chain of Responsibility, Decorator/Adapter and Wrapper patterns in the context of specific development issues. Simple examples, written using Visual FoxPro, illustrate how you can implement these patterns in your own work.
If you have ever wondered what design patterns are for, or how to go about putting them to use, then this is a session you will not want to miss.
Level: Foundation: Attendees should be familiar with creating and using Forms and Visual Classes in Visual FoxPro