GRAFUG Meeting, May 13, 2006


General Information


Thanks to everyone for coming, especially Andy Kramek who came from Ohio to make his presentation.




Faye Pollack and Associates looking for a programmer

16000 Ventura Blvd Suite 702

Encino, CA 91436

Phone 818-501-3390



Optimal Solutions is moving buildings.  Our next meeting will be held at our new address:

1055 Gezon Parkway, Wyoming, MI 49509


Map of 1055 Gezon Pkwy

Directions to 1055 Gezon Pkwy



Main Presentation


This month Andy Kramek gave a very informative discussion on a set of classes regarding data access.  

A link to Andy’s Data Class whitepaper may be found under the download section of our website:


The Tightline Data Classes,

What are they?  A set of classes in VFP that creates a standard interface for standardizing data access for FOXPRO code.  You can either obtain the classes for free, functional and 4 years old, or purchase a current set. The current set, the working ones are for sale by ERW Custom Programming.


In the modern business environment access to data is crucial for any application. However there are many different databases in common use and the problem is how to integrate data from such disparate sources as SQL Server, Oracle and Visual FoxPro. This session discusses the design and implementation of a set of classes which address precisely this problem and which could even be implemented as a COM object if necessary.


These classes help you tackle questions such as: How do you connect to the database?  ODBC or OLE DB


The classes are based on a 3-teir model. 

Data layer design, keep it simple, and the data in the middle tier.  Handle connections and querying database.  Handle multiple connections and switching.  Must handle updates and transactions implicitly.  Requires PK generation by the database.  The middle tier has three layers.  The data classes sit at the bottom of the middle tier.  The dataset is a superset of the business object, or a replacement of it.


For more information, visit our website and read the white paper!



Next Month


Our next meeting is Saturday, June 10, at 10:00 am, and we have a special speaker: Art Bergquist.


Best Practices in Application Development

All sorts of tips and tricks I've gleaned over the years to simplify and generally facilitate VFP development.


Art Bergquist has been developing software since 1984; he holds a B.S. in Computer Science with an emphasis in Management Information Systems. Art has written applications in every version of the Fox from FoxPro for DOS 2.0 and is currently developing in Visual FoxPro 8.  He has authored articles and tips in FoxTalk and FoxPro Advisor magazines (and has also tech-edited articles for FoxPro Advisor magazine) and has been a presenter at the FoxPro Developers Network of San Diego (where he serves on the board as Vice-President) as well as at the Orange County (CA) FoxPro Developers Group. In addition, he has conducted Visual FoxPro training classes.  He develops custom applications at Visionpace in VFP 9 utilizing the powerful Visual MaxFrame Professional (VMP) application framework. He has enhanced and written developer tools for VMP and frequently leads VMP training including the MaxStart workshop.


Be a Volunteer


If you wish to volunteer to be a speaker for a future meeting, information and a link for topic submission can be found on our website:




Sharon Hodgson

GRAFUG Secretary