GRAFUG Meeting, May 13, 2006

 

General Information

 

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

 

Announcements

 

Faye Pollack and Associates looking for a programmer

16000 Ventura Blvd Suite 702

Encino, CA 91436

Phone 818-501-3390

www.fpainc.com

 

 

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: http://www.GRAFUG.com.

 

The Tightline Data Classes, www.tightlinecomputers.com

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: http://www.GRAFUG.com.

 

 

*-*-*-*-*-*-*-*-*-*-*-*-*-*

Sharon Hodgson

GRAFUG Secretary

hodgsons@optimalinternet.com

www.GRAFUG.com

www.optimalinternet.com