GRAFUG Meeting, May 13,
2006
General
Information
Thanks to everyone for coming,
especially Andy Kramek who came from
Announcements
Faye Pollack and Associates looking
for a programmer
Phone
818-501-3390
Optimal Solutions is moving
buildings. Our next meeting will be held at our new address:
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.
*-*-*-*-*-*-*-*-*-*-*-*-*-*
GRAFUG Secretary