Wiki Home

Philadelphia VFP User Group


Namespace: WIN_COM_API
Starting in March 2017, we meet the second Tuesday of March, May, July, September and November at 7 PM.

A user group for Visual FoxPro developers in the greater Philadelphia area, including New Jersey, Delaware and the Lehigh Valley. We currently meet at Smooth-On, Inc., 5600 Lower Macungie Rd, Macungie, PA 18062. If you arrive at Smooth-On and there’s no one to let you in, call Bob Pierce at (610) 865-6910.

Feel free to bring something to eat and arrive as early as 6:30.

Check out our blog at vfpphilly.blogspot.com.
We're on Twitter: @VFUGPhilly

If you'd like to speak at our group or join our email list, send a message to tamar@tamargranor.com

Next Meeting:


Tuesday, November 13 ScottPMalinowski will present “Leveraging your product's website to expedite product development and stability.”

Scott works for NEMRC (New England Municipal Resource Center). He has been a VFP Developer for 26 years from FoxPro Base upward, with some Quicksilver and Xbase 3.

Abstract: Most vertical market applications have a corresponding website to market the sales of their application. The purpose of this session is to show you how easy it can be to use the same website to serve updates, collect and report error information, collect and report other system information, validate active clients and keep your customer databases up to date with current information. The session will show the use five technologies, Visual FoxPro, HTML, perl and FTP and Windows Scheduled Tasks.

Future Meetings:


November 13 is our last meeting for 2018. We expect to meet on March 12, May 14, July 9, September 10, and November 12, 2019.



Past Meetings:


Wednesday, September 12 Tamar Granor in a Southwest Fox preview: "Drag Your Applications into the 21st Century with Drag-and-Drop"

Abstract: Users today expect to be able to interact with applications by dragging and dropping. FoxPro has offered drag-and-drop capability since VFP 3, but many developers have never worked with it. In fact, VFP offers two separate approaches for drag-and-drop, a native capability and OLE drag-and-drop, which allows you to interact with other applications and gives you greater control over the process. In this session, we'll look at both approaches and show both how easy simple drag-and-drop is, and the complex things you can accomplish with it.

Tuesday, July 10 Menachem Bazian: Harnessing the power of WordPress

Abstract: WordPress is the most popular CMS on the market today. Using WordPress, you can create robust websites with relative ease. But, like everything, using WordPress has its costs as well. This session will discuss how to use WordPress, some of the must have plugins for your site and how to write your own plugin so you can show data from your Visual FoxPro application on the site.

Tuesday, May 8 Robert Pierce

Here’s Bob’s description of the session: I will be showing many examples of interface design elements that are included in Smooth-On’s ERP/MRP. These examples, made entirely in VFP, will show a number of approaches that were used to solve diverse problems, and a brief glimpse of how they were put together. If time permits I can also show a couple of Tricks & Tips that I use on a regular basis.

Tuesday, March 13, 2018 Tamar Granor: "You Mean I Have to Write About It, Too?”

Abstract: Many software developers would prefer never to have to write in a natural language; they're much happier with programming languages. But the ability to communicate in writing is actually an essential skill for successful software development. Developers need to be able to write specifications and developer documentation, as well as to clearly ask questions of their customers and to answer customer questions. In some cases, developers are responsible for end-user documentation, too.

In this session, we'll see how to produce documents that say what you need to say in an accessible way, whether you're writing a user manual or an email. We'll look at all stages of the writing process, from organization to writing to editing to proofing. Come prepared to write and edit both your own work and that of a peer. Please bring something on which to write and something to write with.


Tuesday, November 14, 2017 G. N. Shah, Chief Technology Officer of Macrosoft on "Technology Outlook and VFP Migration in Real Life."

Abstract:

Presentation and discussion will cover real life case studies including:
G. N. Shah is a forward thinking, corporate leader with twenty years’ experience delivering top notch customer solutions in large scale and enterprise business environments. His proven abilities as a technology visionary and driver of strategic business systems development allow Macrosoft to deliver best in class software solutions.

At Macrosoft, Shah has successfully delivered multiple migration projects. Shah holds an MBA in addition to multiple professional and technical certifications. His areas of expertise include enterprise-wide architecture, application migration, IT transformation, mobile, and offshore development management.


Tuesday, September 12, 2017> BobPierce on Dashboards and Graphics

"I will show how I have integrated graphics and dashboards to make information faster to digest. I will explore several different techniques to present data with and without graphics. Several of the styles are straight VFP implementations, but also will show a couple tools from VFPX."

Tuesday, July 11, 2017

We'll provide dinner. Email tamar @ tamargranor.com (remove spaces) if you'll be joining us for dinner.

Speaker: Menachem Bazian
Title: Enhance Data Presentation with DataTables
Abstract: DataTables is a jQuery plugin that is a must for any web developer that uses tables. DataTables packs a huge one-two punch in terms of quick, out of the box functionality and incredibly powerful options to customize it just for your needs. If you use tables in your webapps, this session is a must for you.

Tuesday, May 9, 2017Tour of Smooth-On, a chemical manufacturing facility automated with VFP--

We'll begin meeting again Tuesday, May 9 with a special treat, a tour of the Smooth-On plant in Macungie, PA. The meeting will begin at 7 PM, but come as early as 6:30 PM for dinner, which the group will provide. (If you’re coming for dinner, please email Bob Pierce ([email protected]), so we get enough food.)

The address is:

Smooth-On Inc.
5600 Lower Macungie Rd
Macungie, PA 18062

Abstract: Smooth-On is a large chemical manufacturer that recently moved into a new facility just south of Allentown. Prior to the move, we used VFP to do Order Entry, Inventory Control, Purchase Orders, Formula Management and Batch Scheduling, among other things. When we made the move, we took it to the next level and used VFP to Automate much of the manufacturing process. This tour will be conducted by the COO and explain the process, show examples of the types of things are made with our products, and discuss the benefits and challenges of the transformation.

Tuesday, March 14, 2016 Cancelled due to snow

Tuesday, December 13, 2016 Dinner and reorganization, plus “Amazon EC2 – A Free Web Hosting and Development Tool.”

Given the recent dip in attendance, we’ll discuss the future of the group. Please consider ahead of time what you’re hoping to get from the group and what you can contribute. If you will be joining us for dinner, please email [email protected], so we have enough food.

In addition, we’ll have a brief presentation from member Jim Connolly titled “Amazon EC2 – A Free Web Hosting and Development Tool.”

Abstract: Are you looking for a web server for development? Review of the Amazon EC2 web server product as a free service for a year!

One year ago, I signed up with the Free Web Server offering from Amazon. At this time, I would like to share my experiences with the group. I’ll present a review and evaluation of the Amazon EC2 web server. What can the Amazon service do for you as a developer! I can show you how to sign up and create your own web server.

Tuesday, September 13, 2016 Kevin Goff on “SQL Server Reporting Productivity Tips.”

We're in room 121.

Abstract: In this presentation, I'll show over a dozen different SSRS topics, and allow attendees to select which topics to cover.

Topics include:
- Advanced charting (sparklines, heatmaps, performance gauges)
- Subreports/drilldown reports
- Matrix (crosstab) capabilities
- Page/Group Control Features
- Data Driven Subscriptions
- Cross-chart filtering ("hot-linking" from one section of a report to another)
- Column visibility and hiding columns from users
- Parameter handling
- Aggregations and running totals

Bio:

Kevin S. Goff
- Microsoft Data Platform (SQL Server) MVP
- Microsoft MVP since 2005
- Frequent community speaker in Mid-Atlantic region
- SQL Live/VS Live conference speaker 2012 to 2015
- Database developer/architect since 1987

Tuesday, August 9, 2016 Menachem Bazian: Map It with Google!

Abstract: Google maps is a tremendously powerful service that can really add useful functionality to your apps. This session will introduce the Google Maps API and show an application that was built around it.

We'll eat in the far hallway and move to room 128 at 7 PM.

Tuesday, July 12, 2016 NO MEETING

Tuesday, June 14, 2016 BillFitzgerald: A VFP programmer looks at .NET – again


Abstract: Since I first started using C# .NET in 2005 both the platform and the way I use it have evolved in several important ways. I’ll walk through three existing production .NET/SQL Server data processing applications which I wrote over a period of ten years and show how the language and the techniques I use with it have changed.

Finally, I’ll show my first attempt at using the recently-released multi-platform .NET core.

Tuesday, May 10, 2016 Tamar Granor: Crosstabs and Pivots: Turning Data on its Side

Abstract: While normalization is the best choice for storing data in tables, there are lots of reporting tasks that require you to turn some data into column headers and accumulate results in those columns. In this session, we’ll see how to do that using crosstabs in VFP and the PIVOT clause in SQL Server. For VFP, we’ll take a good look at an alternative to VFPXTab, the crosstab generator that comes with the product.

We'll meet in room 128, but dinner beforehand (bring your own) will be in the student cafeteria.

Tuesday, April 12, 2016 Robert Pierce: Managing mission critical, high availability VFP applications in real time

Member Robert Pierce will present this month. His topic is “Managing mission critical, high availability VFP applications in real time.”

Abstract: In this session I will explore performance, monitoring and maintenance issues when dealing with programs that must be updated and continuously available with limited maintenance windows. I will delve into some code that lets me maintain and monitor dozens of VFP applications running a 24/6 manufacturing operation using VFP.

Tuesday, March 8, 2016 Tamar Granor: "Going OVER and above with SQL"

We'll be in room 125.

Abstract: The SQL 2003 standard introduced the OVER keyword that lets you apply a function to a set of records. Introduced in SQL Server 2005, this capability was extended in SQL Server 2012. The functions allow you to rank records, aggregate them in a variety of ways, put data from multiple records into a single result record, and compute and use percentiles. The set of problems they solve range from removing exact duplicates to computing running totals and moving averages to comparing data from different periods to removing outliers.

In this session, we'll look at the OVER operator and the many functions you can use with it. We'll look at a variety of problems that can be solved using OVER.

You will learn:

How to find the top N records in a group
How to compute running totals and moving averages
How to compare data from multiple records side-by-side
How to divide records into n-tiles, including percentiles
How to search for records in a particular percentile

Tuesday, February 9, 2016 Menachem Bazian: "Map it with Google!" Cancelled due to predicted snow

Abstract: Google maps is a tremendously powerful service that can really add useful functionality to your apps. This session will introduce the Google Maps API and show an application that was built around it.

Tuesday, January 12, 2016 JimConnolly on West Wind Web Connection 6.0. Room 125

From the West Wind web site,

here’s the description of the product:

Create Web applications with Visual FoxPro and take advantage of a powerful and proven framework using the FoxPro environment you already know. Develop and test your code inside of the VFP IDE against live Web requests. Web Connection provides a core foundation engine, and several high level frameworks for developing just about any kind of Web application you can imagine.

Create server driven HTML with our ASP.NET like Web Control Framework, or chose a more MVC like Templating approach. Build rich Java Script apps and use REST services to feed data. Build raw POX or SOAP backend or use no framework at all and create your own low level engine on top of the core. If you need Web for FoxPro - Web Connection can do it all.

Jim will show the new features and give examples of setting it up on a computer.

Tuesday, December 8, 2015 Toni Feltman: An introduction to SQL Server Reporting Services (Part 2). Room 125.

Last month we looked at the basics of SSRS. This month we will pick up where we left off and:
• See how to accomplish some more complicated reporting tasks.
• Ways to render SSRS Reports in Visual FoxPro
• A way to "centralize" reporting services to be used by more than one type of client
• Differences between SSRS "express" and paid versions

Tuesday, November 10 Toni Feltman: An introduction to SQL Server Reporting Services (Part 1)

Note that this month's meeting will be in room 125

SQL Server Reporting Services (SSRS) is the Microsoft answer to reporting tools like Crystal Reports. The really nice thing about SSRS is that a version is now included with SQL Server Express which is FREE. Free is good, right? SQL Server Reporting Services is a quick and inexpensive way for developers to create and deploy reports when using SQL Server as the database engine. It is not difficult to use and is similar to other reporting tools that may already be in your toolbox. There are benefits to having a language-agnostic reporting tool such as the ability to share reports between different applications and platforms. It also makes really good sense to have a reporting tool tightly coupled with the data used for reporting.

Desktop applications need reporting. These applications are being extended through other technologies such as the web and mobile. Even if your development environment has its own reporting engine, SQL Server Reporting Services is a great way to get query and reporting capabilities that are available on the desktop, web and mobile device all from one code base.

In this Part I session we will talk about:
• Where to find and how to install SQL Server Express and SQL Server Reporting Services
• The basics of the Report Builder and Visual Studio Data Tools
• Different Ways to tie data to reports
• The native Report Output Options
• How to accomplish some simple reporting tasks.


Tuesday, October 13 Christof Wollenhaupt: Computer Sensors in Business Applications

Our October meeting will be in room 127, DeVry University, 1140 Virginia Drive, Fort Washington, PA. Note the change of room; this new room is a computer lab and no food or drinks are permitted. You can still plan to come as early as 6:30 and bring some dinner, but you’ll have to eat in the commons area (where the vending machines are located) before coming to the meeting room.

This month, Christof Wollenhaupt returns to do a Southwest Fox preview on his way to Phoenix. He’ll present “Computer Sensors in Business Applications.”

Abstract: Most notebooks have a variety of sensors that were uncommon when Visual FoxPro 9 was released. In this session we cover a variety of modern sensors and devices and how to access them from Visual FoxPro by using some .NET helper code. These devices include the camera to take pictures and the microphone for audio recording, the touch screen to respond to finger input and multi-touch gestures, the GPS receiver to determine the current location, the compass to obtain directions, and the accelerometer to measure device movements.

Sensors are useful in many mobile business applications. For instance, you can automatically track time and route of mobile workers. The camera takes pictures that are directly added to the VFP application when entering orders at a client site.

Bio: Christof Wollenhaupt, head of Foxpert, offers FoxPro and .NET development and consulting services to customers who benefit from his nearly 20 years of experience. Christof is a regular speaker at conferences and user groups around the world, organizes the Hamburger Stammtisch für Microsoft Datenbankentwickler (Hamburg user group for Microsoft database developers), has written for various magazines including a regular column in FoxPro Advisor for more than 10 years, and was a Visual FoxPro MVP from 1997 to 2010.

Tuesday, September 8 Toni Feltman was supposed to present "SQL Server Reporting Services," but had to cancel at the last minute.

A pizza dinner will be provided!

Abstract: SQL Server Reporting Services (SSRS) is the Microsoft answer to reporting tools like Crystal Reports. The really nice thing about SSRS is that a version is now included with SQL Server Express which is FREE. Free is good, right? SQL Server Reporting Services is a quick and inexpensive way for developers to create and deploy reports when using SQL Server as the database engine. It is not difficult to use and is similar to other reporting tools that may already be in your toolbox. There are benefits to having a language-agnostic reporting tool such as the ability to share reports between different applications and platforms. It also makes really good sense to have a reporting tool tightly coupled with the data used for reporting.

Desktop applications need reporting. These applications are being extended through other technologies such as the web and mobile. Even if your development environment has its own reporting engine, SQL Server Reporting Services is a great way to get query and reporting capabilities that are available on the desktop, web and mobile device all from one code base.

You will learn:
• Where to find and how to install SQL Server Express and SQL Server Reporting Services
• How to use Report Designer
• Ways to tie data to reports
• About the native Report Output Options
• Differences between SSRS "express" and paid versions
• Ways to "centralize" reporting services to be used by more than one type of client
• Ways to render SSRS reports in Visual FoxPro
• Methods for integrating existing report technology with SSRS reporting to create a common look and feel between reports


Tuesday, July 14 Tamar Granor: “Can’t this application go any faster?”

bstract: What do you do when your customer says that your application is too slow? How can you figure out what's slowing things down? How can you make it faster?

Optimization of a VFP application is more than just applying Rushmore correctly, though that's an important step. In this session, we'll explore techniques for measuring performance of a VFP application and look at things you can do to speed it up.


Tuesday, June 9 BobPierce: Manufacturing Automation powered by VFP – Part 1


Smooth-On Inc., with $50 Million annual production recently moved into a much larger facility to accommodate our growth. It was decided that we take the opportunity to modernize the operation using automation controlled by Visual FoxPro. In our process we use 600 chemicals to produce 1400 formulas that go into 6000 finished goods that are sold globally through our distributer network, and ecommerce. I will explain why VFP was selected for this project, some of the pitfalls of that choice, and the complexities of interaction with pumps/valves/ mixers/sensors in the real world. There was quite a bit of planning and advanced preparation. But not unexpectedly a lot of nuance we didn’t anticipate and a number of things we missed altogether. Although the process is not complete, we are well on our way; In Part 2 I will discuss further developments including full formula automation and automation of the pack out process.

Tuesday, May 12 Rick Schummer will present the “director’s cut” of his Southwest Fox 2014 session “Inspiring Everyday Practical IntelliSense”

Abstract: Microsoft introduced Visual FoxPro's highly extensible IntelliSense capability 14 years ago with the release of Visual FoxPro 7.0. I remember seeing the first live demo of IntelliSense at DevCon and recall the chills it sent up my spine because I knew this new feature would instantly make me more productive. This single VFP feature has been heralded as "the greatest thing since sliced bread" and is, at least in my mind, the single biggest productivity boost to developers. Yet to this day I feel I under-use it and wish I would take the time to make things better for myself.

This session reveals how IntelliSense works using scripts and settings, and how it can be implemented, using real world examples authored by numerous Visual FoxPro developers. The implementation will be demonstrated and analyzed with the number one goal of inspiring you to boost your own productivity in the VFP IDE, and later to share those items that might help other developers in the FoxPro community.

Discover the details needed to take advantage of Quick Info, Member Lists, Command and Keyword expansion, Types, and MRU Lists. Techniques include leveraging the FoxCode object, text merge, and more. If time allows, we will explore other IntelliSense implementations and extensions like MY, Intellisense X, ISX, and FoxCodePlus.


Bio: Rick Schummer is the president and lead geek at White Light Computing, Inc., headquartered in southeast Michigan, USA where the team guides the customer's Information Technology investment toward success. He enjoys working with top-notch developers, thrives on the mode of continuous learning, has a passion for developing software using best practices, strives to surpass customer expectations, and shares his knowledge with others whenever he can. After hours you might find him creating developer tools that improve developer productivity, or writing articles for his favorite technology journals and his blog.

Rick is a co-author of VFPX: Open Source Treasure for the VFP Developer, Making Sense of Sedna and SP2, Visual FoxPro Best Practices for the Next Ten Years, What's New In Nine: Visual FoxPro's Latest Hits, Deploying Visual FoxPro Solutions, Mega Fox: 1002 Things You Wanted To Know About Extending Visual FoxPro, and 1001 Things You Always Wanted to Know About Visual FoxPro. He is a regular presenter at user groups across North America and is founding member and Secretary of the Detroit Area Fox User Group (DAFUG). Rick is the lead organizer of the Southwest Fox Conference, and is a regular presenter at other conferences in North America, Europe, and Australia. He is an administrator of VFPX, and a Microsoft Visual FoxPro MVP from 2002 to 2011. Rick was awarded the FoxPro Lifetime Achievement Award in October 2010.

Tuesday, April 14 JamesConnolly: Document Management within Visual FoxPro

Abstract: I created programs that will create an electronic filing system. The programs read the bar codes from the invoices and files them in electronic storage. This allows the end user to view the documents with a single click in the app. I will show the class how to setup the bar code reader and to accept individual scans for easy access. There are some recommended programs that will assist in the process. I will present them along with the Fox Pro program.

Tuesday, March 10 BillFitzgerald: “SSRS 101: SQL Server Reporting System for beginners”

SSRS – SQL Server Reporting System has been evolving quietly over the past decade and has now emerged as Microsoft’s preferred tool for preparing and displaying database reports. It is the default reporting system for SQL Server and .NET, and also is a powerful standalone report generator. At the same time there has been a decline in the support for the integration of Crystal Reports with .NET, creating a need that Microsoft has moved to fill.

SSRS is well supported, there are many tutorials available and perhaps most important for some of us – it’s free!

This presentation will look at SSRS from a VFP programmer’s point of view and show how one VFP programmers made the journey to learning enough about SSRS to do most of the things we do with the VFP report writer. (Alas- not all- but most.) It will also show a few things that can’t be done with the VFP report writer.

Tuesday, February 10 Open Mike Night: Tips & Tricks

This month is part 2 of our VFP Tips and Tricks series. Come prepared with one or two (or more) short items you want to share with the group. They can be about the VFP UI, the language, application design, great tools, or pretty much anything else VFP-related. (And it’s okay to come even if you have no tips to share.)

Tuesday, January 13 Tamar Granor: VFP Tips & Tricks

Abstract: I love to watch other people work at their computers. Every user makes a unique set of choices about when to use the mouse and when to use the keyboard, whether to use the menu or a keyboard shortcut, and so forth. But people often get set in their ways, and continue to do something one way when there's a much more efficient way to do it.

The same thing applies to Visual FoxPro. It's been said that if you can do something at all, you can do it three ways. But most of us learn how to do something and move on, even if a different way is more efficient or more effective. When new ways of doing things come along, we don't always pay attention to them.

In this session, we'll look at a variety of ways to work smarter in VFP. Some apply to the IDE, while others address the language. In the tradition of Drew Speedie, we'll cover as many of these tips and tricks as time permits.

Tuesday, December 9--MenachemBazian: Jazz your Web Applications with JQuery!

Abstract: This session is an introduction to the most powerful and widely used client side function library in the web development world. JQuery is both a function library and a foundation that makes web development easier and more powerful. It is also the basis for hundreds of really handy plugins that can make you look like a master web developer with little effort.

This is an introductory session to JQuery and will introduce you to how it works and show you some of the great plugins I use daily in my web application development

Tuesday, November 11--BobPierce double-header

Loosely coupled VFP data

While trying to get a forklift program going, I was having trouble with dropped wifi signals in the warehouse. So I developed a background data program that maintains data on a local drive that gets updated from data on the server. I realized later that this technique can also be used during our move to the new facilities when running the in house MRP from multiple locations. In addition it can be used as a mechanism to sync remote data and even reduce total network traffic.

Working with VFP and SQL together and providing easier migration path

I have developed a simple technique that allows me to work with My Sql, Sql Server and other SQL flavors within the VFP environment. No big deal you say, been there done that… The class I developed allows you to mix and match the data using VFP syntax without knowing where the data is or what type of host it is on. This allows me to move data piecemeal in my migration, not change the code in the program (except the added class), to eliminate case sensitivity (My Sql on Linux), and to use VFP user defined functions against any data.

Tuesday, October 14--SouthwestFox preview: Toni Feltman: I Need a REST! and Should I be Concerned?

Title: I Need a REST!
Abstract: Web APIs are one way to enable distributed systems to interact with each other over HTTP. In the past, SOAP-based Web Services were the Web API of choice. Today developers prefer to use RESTful Web APIs to enable system to communicate. Our Visual FoxPro applications are just one of the types of systems that may need to communicate with others over the web. It is very possible, and pretty easy, to do so using RESTful APIs. In order to take advantage of all that is available using the web you must first
understand Web APIs, know how to find them (or write them) and then plug them into your applications.

Title: Should I be Concerned?
Abstract: I remember way back around 1994 when people started talking about the concept of business objects and application layers. I know that when I spoke on the topic, many people looked at me like I was completely nuts. Why would anyone want to add such layers of complexity to an application? Fast forward a couple of years (or decades) and we have complex business applications that are screaming for features that FoxPro can't provide such as Metro interfaces, offline databases, interactions with specialized hardware such as cameras and GPS. I am really glad that I added that layer of complexity back then because moving portions of my applications to other platforms is significantly easier than it could have been. But what about you? How can you retrofit monolithic FoxPro applications into an n-tier model in an efficient manner that does not require extensive rewrite or testing?

Toni Feltman, a Microsoft Certified Professional, is an experienced software developer, project manager, instructor and speaker. Currently Toni serves as the Application Development Manager for CoreLogis, LLC, a Westerville, OH company that specializes in Inventory and Asset management software for local to international government entities. She is also Vice President and a Partner at F1 Technologies and is still an integral part of the company. During her 15 years at F1 Technologies she has served as both a developer and project manager on numerous projects and as Product Manager for the highly successful FoxExpress product line.

Toni is a well known contributor to the Visual FoxPro development community. She has spoken at most major FoxPro conferences in North America and Europe over the last several years. Although Toni has expertise in a number of areas, she generally focuses her presentations on Team Development, XML, n-Tier Development and new features in Visual FoxPro. In 2011, Toni was honored by the FoxPro community with a lifetime achievement award in recognition of her contributions to the community throughout her career.

Toni has penned several articles for Advisor Guide to Microsoft Visual FoxPro and is co-author of What's New in Visual FoxPro 9.0 (Hentzenwerke Publishing). Toni also designed and developed Project HookX, a public domain utility designed to allow developers to manage and use multiple project hooks on a single Visual FoxPro Project. Toni is one of several co-authors of DBCX, a public domain data dictionary tool used or supported by many notable Visual FoxPro products including the Stonefield Data Dictionary, Visual FoxExpress, Fox Fire! and Stonefield Query.

Toni taught for several years at the University of Toledo on a wide variety of technologies including Microsoft Office applications, XML, various Internet development technologies and database design and programming. Toni also enjoyed a stint as an instructor for AppDev.

Toni's introduction to the FoxPro community came while she worked in the technical support department at Fox Software. Toni was a senior level support technician and Sysop of the Fox Software Forum on CompuServe.

Toni graduated from Bowling Green State University in 1989 with a BA in Management Information Systems.


Tuesday, September 9--SouthwestFox preview: Tamar Granor

Topic: Go Beyond VFP's SQL with SQL Server
Abstract: The subset of SQL in Visual FoxPro is useful for many tasks. But there's much more to SQL than what VFP supports. Those additions make it easy to do a number of tasks that are difficult in VFP.

In this session, we'll solve some common problems, using SQL elements that are supported by SQL Server, but not by VFP. Among the problems we'll explore are combining a set of values contained in multiple records into a delimited list in a single record, working with hierarchical data like corporate organization charts, finding the top N records for each group in a result, and including summary records in grouped data.

Tuesday, August 12--SouthwestFox preview: Doug Hennig on PowerShell

Bio: Doug Hennig is a partner with Stonefield Software Inc. He is the author of the award-winning Stonefield Database Toolkit (SDT); the award-winning Stonefield Query; the Member Data Editor, Anchor Editor, and Cursor Adapter and Data Environment builders that come with Microsoft Visual FoxPro; and the My namespace and updated Upsizing Wizard in Sedna.

Doug is co-author of VFPX: Open Source Treasure for the VFP Developer, Making Sense of Sedna and SP2, Visual FoxPro Best Practices For The Next Ten Years, the What's New in Visual FoxPro series, and The Hacker's Guide to Visual FoxPro 7.0. He was the technical editor of The Hacker's Guide to Visual FoxPro 6.0 and The Fundamentals. All of these books are from Hentzenwerke Publishing (http://www.hentzenwerke.com). Doug wrote over 100 articles in 10 years for Fox Talk and has written numerous articles in FoxPro Advisor, Advisor Guide to Visual FoxPro, and CoDe. He currently writes for Fox RockX (http://www.foxrockx.com).

Doug spoke at every Microsoft FoxPro Developers Conference (DevCon) starting in 1997 and at user groups and developer conferences all over the world. He is one of the organizers of the annual Southwest Fox and Southwest Xbase++ conferences (http://www.swfox.net). He is one of the administrators for the VFPX VFP community extensions Web site (http://vfpx.codeplex.com). He was a Microsoft Most Valuable Professional (MVP) from 1996 through 2011. Doug was awarded the 2006 FoxPro Community Lifetime Achievement Award (http://tinyurl.com/6po3pwv).

Abstract: Windows PowerShell has been included with the operating system since Windows 7 and is available for download for Windows XP and Vista. What is PowerShell? It's Microsoft's task automation scripting framework. PowerShell isn't just a replacement for batch files; it can do a lot more than batch files ever could. This session looks at PowerShell, including why you should start using it and how to create PowerShell scripts.

Tuesday, July 8--NO MEETING.

Tuesday, June 10 --A Double Dose of XML

Bill Fitzgerald will present “Using XML to store data.”

Abstract: There are some cases where storing data in SQL Server or VFP tables is not practical. Because of its ability to structure data, XML is a good alternative.

Bill will walk through the code of two working applications that use XML for data storage and discuss XML’s pro’s and con’s and why he chose to use XML in these cases.

Then, Tamar E. Granor will talk about an application that uses XML for both long-term data storage and data transport.

Tuesday, May 13-- KevinGoff on T-SQL for Application Developers

That's right, attendees choose! I'll show 25 possible topics on the screen, and the attendees vote at the beginning on which topics I'll cover.

Everything from isolation levels to ranking...everything from GUIDs to table-valued functions....everything from querying temporal data to instances where subqueries are necessary....everything from update triggers to reading execution plans...everything from cumulative totals to uses for UNPIVOT....and more!

You'll walk away with over 25 code samples, even though we'll only cover a portion of them in the presentation. This has always been a very popular session.

Tuesday, April 8-- Eric Selje --"Don't be a Target!"

For the last few months we've watched with fascination the developing story of the data breach at Target, Neiman Marcus, Michael's and others. In this session we'll take a look at how the thieves accomplished this feat including what they do with their takings, how it might have been prevented, and why the banks may not care all that much.

Along the way you'll learn ways to secure your own information so your business doesn't become the next Target. Though this doesn't particularly have to do with VFP directly, many of us are subcontractors as well as network pros, DBAs, etc. and there are quite a few lessons to be learned from the Target data breach.


Tuesday, March 11 Tamar Granor: Office365: An IT Department for Small Business

Abstract: Small development shops (and other small businesses) generally don't have the skills in-house to operate a mail server or host their own website. Time spent on these and other IT tasks comes out of billable hours. Microsoft's Office 365 offers an inexpensive way of outsourcing these tasks. For a small monthly fee, a company gets an Exchange server, web hosting, cloud storage, and the latest version of Office.

In this session, we'll look at what Office 365 has to offer, including a look at the SharePoint-based team and public sites you can create.


Tuesday, February 11--MenachemBazian: Web Services: How to create them and use them to share data between your web applications and Visual FoxPro--rescheduled from December due to snow.

This session combines the work we have been doing on PHP with Visual FoxPro and shows you how you can easily create and use web services to easily push data down to you Visual FoxPro applications from your web applications.

If time permits, Menachem will also discuss “MySQL Triggers -- The hidden gem...”

Tuesday, January 14--BobPierce, who describes his session as follows:

VFPX has some very powerful tools that are literally take off where Microsoft left off. This month I will be looking at the new E-Book explaining how to get the most from VFPX. This will explore the contents of this book and explain how it will help you maximize your time deciding which tools are worth exploring for your needs and how to get up and running quickly with those tools even though there is some lacking in documentation for some of the projects. With the breath of VFPX addons available, this will give you an overview of how to get started quickly to give you enhanced productivity in the IDE as well as give your projects a fresh look and feel that is more modern. I would also like to have an interactive discussion of some currently topical subjects such as Big data, Data Mining, Business Intelligence, CRM and the like to find out what is already being handled by VFP in our daily use and the hype of some of these buzzwords.

Tuesday, December 10, 2013 Menachem Bazian: Web Services: How to create them and use them to share data between your web applications and Visual FoxPro Cancelled due to predicted snow. Will be rescheduled.

This session combines the work we have been doing on PHP with Visual FoxPro and shows you how you can easily create and use web services to easily push data down to you Visual FoxPro applications from your web applications.

Tuesday, November 12, 2013

Member Jim Connolly will present “Foxpro and the Internet – The West Wind Connection.” Jim will show how to set up the web server and install West Wind, set up Visual Studio for editing West Wind Pages. He will teach how to create basic web pages with connections to the FoxPro tables on a web server, show how to use grids for display on the web, and show how to move data entered via the web to the tables.


Tuesday, October 8, 2013

Member Bill Fitzgerald will talk about Excel automation. Bill says “Several customers have asked for outputs in Excel form of late and that wonderful resource- Microsoft Office Automation by Tamar Granor and Della Martin - is never far away when I'm doing those projects. While doing the past few projects I came across two techniques - one covered in the book but worthy of some more emphasis - and another that has surfaced since the book's publication - that I thought would merit the group's attention.”

In addition, bring your questions about VFP for answers from the group.

Tuesday, September 10, 2013SouthwestFox preview: Tamar Granor on "Make Thor Your Own"


Abstract: While using Thor exactly as it's installed offers lots of benefits, Thor also can be customized in lots of ways. From adding your own tools to specifying plug-ins that change the behavior of tools to setting up options for tools, you can tailor Thor's behavior to provide yourself and your team exactly what you need. The Thor Framework and Thor Procs provide basic code that makes it easier to customize Thor.

In this session, we'll see how to take Thor to the next level by adding tools, setting up options, and modifying and adding plug-ins. We'll also explore the Thor Framework and Thor Procs to understand the rich environment Thor providesTuesday, August 13, 2013 Southwest Fox preview: Hank Fay on Lianja (http://www.lianja.com/)

We continue our Southwest Fox previews this month. Our speaker is Hank Fay and he’ll be presenting the instructional material from the pre-conference “Workshop on Migrating Applications to Lianja.” During the workshop, this material will be interwoven with hands-on work relevant to the instructional material, when participants will have the option to perform these actions on an app of their own choosing.

Hank Fay is President of Professional Systems Plus, Inc, (ProSysPlus) and Chief Technology Officer of DataWorks, Inc. His interest in enhancing software development through the use of metadata began in 1995, shortly after his book on "Event-driven Programming in FoxPro 2.5" was published. Together with Frank Camp, he wrote a tool integrating xCase with the Visual Pro Matrix framework for VFP, along with libraries that supported and extended VPM. That toolset has delivered, and continues to deliver, enterprise applications world wide. Hank is a Lianja MVP for both 2012, when the award was initiated, and for 2013. Lianja is the toolset that meets his criteria for being able to provide a development platform for domain experts to create enterprise-class software that runs everywhere, on everything. ProSysPlus created the ERD tool integrated into Lianja.


Tuesday, July 13, 2013 Southwest Fox preview: Tuvia Vinitsky on "Credit Cards and EFT/ACH in VFP."

Abstract: Many applications today require the user to charge a credit card or process an ACH bank account transfer. Processing credit cards and EFT transactions in VFP involves both technical aspects and security aspects.

What is the best approach? What does PCI-compliant mean? What is the best way to connect securely to the credit card processor? What are terms like AVS and CPS? What do I have to do to keep my app current?

Software like PC-Charge and gateways like Authorize.net are essential to credit card processing. They serve different purposes, however, and knowing what services to use when can be confusing.

The requirements are very strict as to what information you can store and how it is stored. Violating these rules can result in the client losing their credt card processing priveleges.

EFT's are increasingly popular. Learn the difference between EFT and e-checks and how to process both.


Tuvia Vinitsky is a principal in Vinitsky Consulting Inc. VCI develops and markets major vertical applications for non-profit organizations and community centers (JCC, YMCA). They also provide custom software and website development.

Tuvia's Fox experience dates back to the days of FoxBase and Compuserve. He has written for Fox Talk and has been a presenter numerous times at regional users' groups. Tuvia has always enjoyed expanding the capabilities of Foxpro, whether it was graphic printer drivers in the days of DOS or Web enabling the latest VFP 9 features.

Tuvia believes in having both breadth and depth of experience. He has served as project leader for many large projects, including projects at companies like Avis-Rent-a-Car, Chicago Board of Trade, Marmon Group and Lotus.

Tuvia and his family are long time Chicago residents. He attended Northwestern University, and is an ordained Rabbi. His years at Northwestern, with its reputation for the performing arts, must have left a mark—not only is he known for his popular presentations on software development, but he frequently is a guest speaker on Jewish philosophy and teachings.


Tuesday, June 11, 2013
This month, Menachem Bazian returns to continue teaching us about Php. The title of his session is “Robust Web Application Development with PHP, CodeIgniter and MySQL.”

Abstract: This session builds on topics we have covered in the past. The session will cover in detail an application written in PHP and MySQL with features including security, menus, data entry and more. MySQL plays a large role in this solution and we will spend significant time on MySQL programming as well.

Tuesday, May 14, 2013 SteveBodnar on HTML5

We’ll supply dinner for the group starting at 6:30 PM. If you’re planning to join us for dinner, please send an email to [email protected], so we buy enough food.

Bio: Steve Bodnar is the President of Geeks and Gurus, Inc., a software development company with offices in Detroit, MI, Kalamazoo, MI and Colorado Springs, CO.

Steve started developing FoxPro applications with FoxPro for DOS 2.0. He actively develops VFP line of business applications as well as websites using Microsoft's ASP.NET MVC and jQuery. Steve was one of the founding members of the Detroit Area FoxPro Users Group and has attended Fox conferences as often as possible since the early 1990's.

Steve has spoken at VFP conferences and user groups in Detroit, Grand Rapids, Kansas City, Toledo, Milwaukee, Sacramento and Atlanta. He's also spoken at .NET user groups, Code Camps and conferences in Grand Rapids, Raleigh, Richmond, Roanoke, Northern Virginia, Chattanooga, Philadelphia, Knoxville and The Wisconsin Dells.

Geeks and Gurus develops line of business applications and websites for small and medium sized organizations. We deliver solutions based on Microsoft technologies such as Visual FoxPro, SQL Server and .NET.

You can learn more about Steve and Geek and Gurus at http://www.geeksandgurus.com.

Abstract: There is a lot of confusion and hype surrounding HTML5. The confusion is because the HTML5 standard isn't scheduled to reach "full recommendation status" until 2022! Yet we're seeing it in all the latest browser for both desktops and mobile devices. (Of course, they don't all implement HTML5 exactly the same as the others!) The hype comes with all the new features available to us today.

In this session, we'll take a look at the timeline and discuss what it means to us - specifically why we shouldn't wait until 2022 to start using HTML5.
We'll dive into several of the new HTML5 features and look at examples of how these things are to be implemented into our websites. We'll look at the new semantic HTML (new tags such as «header» and «footer»); video and audio; Canvas; geolocation; inline elements («mark», «time», «progress»); form input types («datetime», «range», «email»); interactive elements («details», «datagrid», etc.); offline capabilities; mobile implications and more.
http://vfpphilly.blogspot.com/

Tuesday, April 9, 2013

Our speaker is Susan Gausch, Senior Solution Development Manager at SalesForce. She’ll introduce us to SalesForce:
Salesforce is an online, web-based, CRM application that runs in "the cloud" allowing users to manage and perform nearly every detail of their job. Located in San Francisco, CA, Salesforce was founded by Marc Benioff and Parker Harris in 1999. Salesforce started out as a business software company distributing its product on a subscription basis. Now it has evolved into the #1 CRM solution in the world. Salesforce is also known for the force.com platform which allows external developers to create add-on applications that integrate seamlessly with Salesforce, enabling full customization to fit any business need.

Tuesday, March 12, 2013 Bill Fitzgerald on "A VFP programmer's approach to handling data in .NET."

Abstract: About 6 years ago I started learning .NET and now more than 50% of my programming is done in .NET. I found some good books but most of them don't approach .NET from the point of view of a desktop database programmer and the few that do are seriously out of date.

Unlike VFP which has its own built in methods for handling data, .NET is data neutral, so countless ways of handling data have emerged and continue to emerge. It took about 4 years of trial and error before I settled on an approach to handling data within .NET desktop applications that resonated somewhat with the way I did things with VFP. The approach is also applicable to web applications though my focus has been on the desktop.

In this session, I’ll use a small database to demonstrate my approach to handling data in .NET/SQL Server.

Tuesday, February 12, 2013 Tamar Granor: "Try Thor's Terrific Tools"

Abstract: The VFPX project, Thor, includes dozens of tools to aid in development. In this session, we'll look at some of what Thor has to offer. The session will explore as many Thor tools as time allows, including Document View, Create Locals, Compare Objects, and much more. We'll also see how to make any Thor tool available with a keyboard shortcut. We’ll also look at how to add your own tools to Thor, how to set up preferences for Thor tools and the Thor Updater.

This session is a repeat of the June, 2012 session, but with additional material and updates.

Tuesday, January 8, 2013-- Menachem Bazian : PHP in the Real World

This session will discuss programming PHP in the real world. The session will follow the evolution of a simple application from original problem description through implementation. Attendees will be introduced to CodeIgniter, a low weight, high performance PHP framework which I use as the basis for my PHP applications. There will be a few other goodies thrown in for good measure too!

This month, we’ll be providing dinner; please send a message to [email protected] if you plan to join us, so we have enough food.

Tuesday, December 11, 2012-- Bob Pierce on synchronizing offline SqlServer/MySql data with live Fox data

Abstract: I have a couple of projects that I need to have VFP tables interact with SQLServer/MySQL to be consumed by a program that is disconnected/remote. I plan to be converting the my main application over to SQLServer but am not yet ready to make that jump, so I am using some small scale projects to become familiar with some of the issues and allow me to solve a couple problems in the short run. I will explore a couple of techniques I have tried and give a sense of some challenges I faced to get to a working solution.

Tuesday, November 13, 2012 Member Dan Baker will speak on “Using VFP as Your Content Management System for an Information-Rich Website.” This is part 1 of what Dan sees as several presentations on this subject.

Dan Baker is a market research analyst in the telecom market who lives in the Poconos and has used his VFP skills to develop what he calls a “information rich” website for his business. The website is an on-line magazine, Black Swan Telecom Journal bswan.org. Here’s a short list of the topics Dan plans on discussing in his first talk on the subject.

1. Why website development is a VFP business opportunity of its own, regardless of whether VFP web applications are used or not.
2. What is an “information-rich” website actually? Why is the VFP desktop with FTP uploads an excellent choice for managing a website of this type.
3. The kind of websites where a VFP solution does not make sense as a business opportunity.
4. Why a VFP developer should not be intimidated by rich websites or by competition from Dreamweaver and traditional web designers.
5. How to create a professional site by “standing on the shoulders of giants”, borrowing great design concepts all over the web.
6. Why VFP is often a better choice than web-based content frameworks.
7. How I organize images, CSS, articles, “include” files and other content in folders for easy management.
8. How you can retrieve server-side files and webpage components without using any on-line database.
9. How an information rich website’s pages are organized.
10. Naming conventions in organizing your webpage.
11. Bringing out the artist inside. A quick discussion on the value of images and how to manage them.
12. Helpful training websites and places to find great stuff to enhance your knowledge and make life easier as a website developer.

Dan also plans to distribute sample web files including simple server-side code written ASP so that you can play with the concepts and see how the website is organized on your own.

In addition, we’ll have a Southwest Fox 2012 review.

Tuesday, October 9, 2012--TamarGranor: "VFP: Ideal for Tools"

Abstract: We've had developer tools written in the FoxPro language since the days of FoxPro 2.0. Quite a few come with VFP, and the community has built lots more. In this session, we'll explore the Visual FoxPro language features that make building developer tools possible. We'll look at how the VFP language allows you to dig into projects, classes, data and code. Examples will be drawn from a variety of VFP tools, including those in VFPX.

Tuesday, September 11, 2012--Menachem Bazian on SQL Server 2012. If time permits, he'll also revisit from of the Php material from his August session.

Tuesday, August 14, 2012--MenachemBazian--Southwest Fox preview: "PHP for VFP developers"

Abstract: Often a Visual FoxPro application will have to share data with a web application. You may be asked to write web reports or simple routines to interact with your data.

When it comes to web technologies, Linux is far more prevalent than Windows. In fact, 66.1% of all internet web servers are running Apache whereas only 18.4% are using IIS. When it comes to server side languages, PHP commands 77.3% of the market.

PHP and Apache also have the benefit of being cross platform. Apache runs on Linux and Windows, PHP runs on Apache or IIS.
Although PHP can look very strange at first, there are strong correlations between Visual FoxPro and PHP. Learning to work with PHP is not that difficult, even if you have never seen it before.

This session will give a primer on PHP and discuss how you can work with your client-server data in both Visual FoxPro and on your web application.

Tuesday, July 10, 2012--NO MEETING

Tuesday, June 12, 2012 Tamar Granor: "Try Thor's Terrific Tools"

Abstract: The VFPX project, Thor, includes dozens of tools to aid in development. In this session, we'll look at some of what Thor has to offer. The session will explore as many Thor tools as time allows, including Document View, Create Locals, Compare Objects, and much more. We'll also see how to make any Thor tool available with a keyboard shortcut. We’ll also look at how to add your own tools to Thor.

Tuesday, May 8, 2012--This month, we’ll have a short presentation by member Dan Baker, followed by open mike night. Please bring any questions or tips.

Dan says he’s been “using the Web Browser to create controls for my VFP applications. It's a work in progress but I have a calendar date picker and a two-level hierarchy table with various HTML input controls inside to show.”

Tuesday, April 10, 2012--Jim Connolly and Steven McCann on Using West Wind Web Connect to put a legacy application online.

Jim Connolly and Steven McCann will present the work they’re doing with West Wind Web Connect. They'll show the web site for Volpe Express Trucking. They created a customer interface for rating, tracking and access to accounts receivable. They also created access for the employees to allow access of the tracking of the deliveries and the drivers. They interface with Google APIs to allow tracking and to calculate distances between stops. They use XFRX to present reports on the Web site.

They’ll explain how West Wind gives them the ability to interface with their legacy FoxPro system and can show examples of easy web pages to interface with FoxPro.

Jim has been working since 1985 with FoxPro. He created the Volpe Express legacy system since 2003. Steven has been working with FoxPro since 2008 and has been working for Jim since the fall of 2011.

Tuesday, March 13, 2012--Tripleheader

Part 1—Bill Fitzgerald: A tool for keeping SQL Server Tables in synch with VFP tables

Abstract:
Some richly-featured VFP applications might co-exist with SQL Server/.NET applications indefinitely, with the need for current reference data on both platforms.

This tool is aimed at synchronizing reference tables that are used and updated in a VFP application, but are needed for read only reference in SQL Server/.NET applications.

Part 2—Tamar Granor: The Method Tracker

Abstract:
The Method Tracker is a new developer tool that fills the niche between the Debugger’s Event Tracker and Coverage Profiler. It allows you to track the start and end of each method in form or class without adding any code to the tracked object. You can control what methods are tracked, and even track changes to properties.

Part 3—Open discussion on multi-user applications

Tuesday, February 14, 2012--Menachem Bazian on "Class Design Strategies"

Abstract: When is a class needed and when isn't it? How can you design classes that add power and flexibility not only to your current application but to all your projects? How can you simplify the development and maintenance by using classes?

The "textbook" answer is to do a full blown object orientation analysis and design. But what do you do if you don't have the time for that formal process?

This session, which is both theoretical and practical (code based), will discuss how to think in "OO" mode and how the traditional Cowboy Programmer approach of Visual FoxPro and the formal world of Object Orientation can come together and live in harmony.
The session will also discuss how to modify classes safely.

Bio: Menachem Bazian, CPA, CITP is President and founder of BC Consulting Services, Inc, a Business Management and Technology Consulting Firm based in Northern NJ. Menachem has been a database developer for over 20 years, having starting out with Dbase II and moved on to Dbase III, Clipper, Foxbase and all the versions of Visual FoxPro to date. He returned to the Fox speaking circuit several years ago and has presented at Southwest Fox for several years. He has published numerous articles and books over the years.

Tuesday, January 10, 2012--BobPierce will demonstrate building a small VFP project that can be used to display status info and data that is simple to build yet has a modern App/Gadget feel using just basic VFP controls and classes. If there is time he will discuss his recent adventures in bar-coding and lot control and some of the issues he ran into as well as the advantages it has delivered already and future planned enhancements.

Tuesday, December 13, 2011--TamarGranor on "Bind events for better applications"

At first glance, the BINDEVENT() function may seem unnecessary. After all, why bind to an event when you can just write code in the event's method?

In this session, we'll look at why BINDEVENT() and its cousins, the Access and Assign methods, are so valuable. Using examples drawn from real applications, we'll see how event binding lets you do things you couldn't otherwise do, and simplifies code for other tasks. We'll also talk about the difficulties involved in debugging code that uses event binding.

Tuesday, November 8, 2011--This month, we'll review Southwest Fox and the DevConnections conference being held this week in Las Vegas. Then, we'll
continue our ongoing conversation about tools we use. Plan to share information about one tool you love.

Tuesday, October 11, 2011-- Menachem Bazian presents "Boosting Your Client Server Application Using Stored Procedures."

Because this session will be 3-hour precon at Southwest Fox, we will begin very close to 6:30 PM.

We will provide dinner again this month (we'll eat while Menachem speaks), so if you plan to come and eat, please email [email protected] to ensure we have enough food.

Bio: Menachem Bazian, CPA, CITP is President and founder of BC Consulting Services, Inc, a Business Management and Technology Consulting Firm based in Northern NJ. Menachem has been a database developer for over 20 years, having starting out with Dbase II and moved on to Dbase III, Clipper, Foxbase and all the versions of Visual FoxPro to date. He returned to the Fox speaking circuit several years ago and has presented at Southwest Fox for several years. He has published numerous articles and books over the years.

Abstract: Stored procedures can be essential to an efficient client server application. Stored procedures provide a great many potential benefits including more efficient processing of certain operations, front-end-independent operation (which can be especially useful if your database is being accessed by both a desktop and a web based application) and more.

But stored procedures come at a cost too. Stored procedures are back end specific and they also require a little different way of thinking about your code and application.

This session will introduce you to stored procedures using two of the most popular SQL back ends: MySQL and SQL Server.

Tuesday, September 13, 2011-- SteveEllenoff on "Working with Remote Data the 'VFP Way': Upsizing to SQL Server Without Redesigning Your Application."

We'll be providing dinner this month, so come as early as 6:30 to join us. Please email [email protected] if you plan to share our dinner, so we'll make sure to have enough.

Abstract: Ask any developer who has migrated a FoxPro application to SQL Server and almost every one of them will tell you that you need to rethink the way your application works: No more Browse windows, no more record navigation buttons, no more XBASE style mentality. In other words, not only do you need to re-code your application for the actual data handling, you also need to re-design the way it works! That's funny?! I don't remember my customers asking me to redesign screens and functionality just because they wanted to take advantage of the many benefits of using a robust remote database such as SQL Server!

So are we stuck to take this advice without negative consequences? The answer is a resounding NO! While it's true that "redesigning" our XBASE styled FoxPro applications while upsizing to SQL Server is a recommended best practice, there are several ways we can minimize the need to change the way our Fox applications look and behave. Furthermore, we can do so with minimal negative side effects. This session will cover a variety of strategies and tips which will allow you to upsize your applications to any remote data back-end, such as MS SQL Server, MySQL, and many others, with minimal impact on the look and feel of your applications. We'll also cover a number of "how to do that" tips for upsizing the application when migrating from FoxPro local data that I have not seen discussed elsewhere.

Bio: Steve Ellenoff is the president of SJE Consulting / Custom Technology Solutions sjects.co founded in 1999. With over 20 years of programming experience, he and his company continue to use Visual FoxPro and other technologies to deliver cost effective, feature rich, database intensive desktop and web solutions for companies small and large. Steve has been working with FoxPro since version 2.6 for Windows, although he considers his many years using Dbase and Clipper to be his unofficial start with FoxPro.

Steve has presented topics on FoxPro at several conferences and user groups, and had numerous tips published by FoxPro Advisor magazine. Steve is the author of the Win7TLib VFPX project (vfpx.codeplex.com), which allows VFP developers to tap into the new functionality of the Windows 7 Taskbar.

Steve also has a background in C and C++ development and headed the popular open source pinball project PinMAME (pinmame.com) for many years. Additionally he made many contributions to the even more popular open source video game project, MAME (mamedev.org). Both projects rely heavily on virtualization and emulation which have long been one of Steve's favorite areas of technology.

In 2008 Steve became one of the founding members of Big Guys Pinball, LLC (bigguyspinball.com). The company has used his software emulation and reverse engineering skill set to create a product that allows pinball owners to replace their "proprietary / no longer available" pinball hardware systems with common, off the shelf PC components.

Steve fulfilled a childhood dream in 2009 when he was hired to do contract work to help develop the video game: Williams Pinball Hall of Fame for XBOX360 and Sony Playstation 3 (xbox360.ign.com/objects/143/14307127.html). As a kid growing up in the 80's video game craze, Steve taught himself how to program computers at a young age for the sole purpose of creating a video game some day. Along the way, the dream got put on hold as the more practical business side of software development took center stage. When video gaming console developer Farsight Studios contacted Steve in 2008, the long forgotten dream suddenly became a reality. The game was released in September 2009 and was met with rave reviews from critics and players alike.

Steve’s latest hobby involves fulfilling another childhood dream, learning to play the drums. Although already a decent guitar player, bass player, and singer from his teen years, Steve always dreamed of making tons of noise on the drums. Prompted by the fun he had playing the “toy” drums for the Xbox360 game Guitar Hero: World Tour, Steve decided to purchase a real set of drums in July 2009, a vintage red Tama “Rock Star” kit. Armed with some great instructional drumming videos, Steve’s been banging away ever since and loving every minute of it!

Tuesday, August 9, 2011--"Tools and more tools."

Please come prepared to discuss or demonstrate a tool you use that makes software development easier. It can be a VFP tool or a more general computing tool. It can be a one-trick pony or a great big game-changer. (While we won't force anyone to speak, the meeting will be more valuable, the more people share.)

Tuesday, July 12, 2011--Tamar Granor will be rehearsing her Southwest Fox 2011 session "Joins and Subqueries: Using SQL Commands for the Hard Stuff."

Abstract: Writing simple SQL queries isn't hard to learn. But as soon as you need something a little more complex, you get tangled up in inner joins vs. outer joins and where to use a subquery and so forth.

This session will bridge the gap between simple and complex queries with a deep dive into the JOIN clause and the use of subqueries. We'll also talk about how to optimize queries and the tools VFP provides to help you.

While this session will focus on VFP's SQL commands, much of the information will be applicable to other SQL dialects.
Tuesday, June 14, 2011--This meeting will begin at 6:30 PM

Jim Nelson will remotely preview his Southwest Fox 2011 session "To boldly go where no VFP'er has gone before -- the Tools of Thor."

Jim Nelson is a relative newcomer to the FoxPro world. He spent the first thirty years of his professional life programming in APL, a long-since extinct programming language. For the last twenty of those years, he worked for a company that sold Workers' Compensation Self-Insurance. During those years, he had a reputation throughout the APL community as a tool builder for utilities not available within the APL language.

His VFP career began in 2003, working for the Kong Company in Golden, Colorado. He now works full-time for them, acting as their software development department.

His involvement in VFPx projects (such as Thor, PEM Editor, and FoxCharts) mirrors his earlier interest in developing programmers' tools. He has been a presenter at SWFox once before, in 2009.

Jim lives in Newbury Park, California, with his wife of 38 years.

Abstract: There are a number of valuable tools that are available in other development environments, but are sadly lacking in FoxPro's own IDE. For some time, there has been a considerable effort afoot to expand the list of IDE tools by reproducing (where possible) the tools from other IDEs (such as Visual Studio), by building on and enhancing existing tools, and by creating brand new tools appropriate to FoxPro.

The most visible of these new tools is named Thor. Thor is a tool for managing add-on tools in the IDE. It provides a unified method for registering other tools, simplifying the task of disseminating them, and a user interface to control the assignment of hot keys and developer-defined menus. The UI provides four different methods for accessing these tools:
Unlike the normal limited set of hot keys available from ON KEY LABEL, Thor provides for the full range of multiple-keystroke combinations (Ctrl + Alt + A, for instance).

This session will start by showing how to install and start using Thor, how to use its UI to assign hot keys and create menus and submenus, and how to use Thor to simplify access to your own private tools. We'll also delve into some of the more interesting details on how Thor works.

Using Thor as the backbone for the remainder of the session, we will explore published tools that can be made accessible in Thor, with particular emphasis on the tools mentioned in the first paragraph. The result of the work mentioned here is a suite of tools that provides a large number of features never before available in VFP. You will find that these tools will rapidly become indispensable in your day-to-day programming life.

There is a lengthy list of tools that will be covered, including the following:
Tuesday, May 10, 2011Double-header: JimWalsh on COM Server and RaymondKnight on Sortable Grids

The next meeting of the Philadelphia VFP will be on Tuesday, May 10 at 7:00 PM at Valley Forge Pension Management. (Check vfpphilly.blogspot.com/ for the address and a map.) As usual, feel free to come any time after 6:30 and bring something to eat.

We again have a double-header scheduled for this month. Jim Walsh will present “An example of developing a COM server in VFP," which was carried over from our last meeting. Raymond Knight will present "Grid Column Header Sorting Made Easy."

Jim Walsh has a Ph D in Physiology and Biophysics, and an MS in Physics. He is an independent consultant specializing in biomedical, scientific and engineering applications, primarily in VFP and C++.

Jim's talk is entitled “An example of developing a COM server in VFP”. COM servers represent a good strategy for providing functionality that is needed by several programs written in different languages. Jim will describe the development of a COM server that provides access to the data in a Firebird database for VFP and C++ clients. Visual FoxPro makes developing COM servers relatively easy. It hides many of the underlying details. But, can the things hidden by the Fox come back to bite you?


Raymond has 30 years development experience since 1981 with heavy user contact and 4 years of call center (1991-1995) experience at the Naval Air Warfare Center (NAWC) in Warminster. Heavy C#/Visual Studio 2005 and ADO.NET along with heavy VISUAL FOXPRO design and programming through version 9. Very strong relational database background including heavy hands on SQL Server 2000/2005. For example, designed SQL tables for conversion of CCALC system from DBF’s to SQL tables. Previously converted a Salesman Commission System (CCALC) from VISUAL FOXPRO 8 to C#/ADO.NET and SQL Server 2000/2005. Previously worked in VISUAL BASIC 6.0. Presently doing work in VISUAL FOXPRO including DBF to SQL conversions.

The description of his session is:

Through the use of this grid column sorting class one can avoid the drawn out process of enabling each column in each grid for ascending and descending sorts. One need only throw this class onto a form and it will automatically find all the grids on a form and it will automatically enable column sorting for each column in each grid. You can also disable any columns within a grid that you don't want to be sorted as well as disabling whole grids through the properties settings. As an added feature, if a column is defined as character the actual sorting method within the grid sorting class will try determine the actual type (date, numeric, etc.) if the type is not really a character type. As a final feature, if the proper property is set the up and down arrow keys will go from top to bottom and bottom to top which a normal foxpro grid does not do when it comes to up and down arrow keys.

Tuesday, April 12, 2011

The next meeting of the Philadelphia VFP will be on Tuesday, April 12 at 7:00 PM at Valley Forge Pension Management. (Check vfpphilly.blogspot.com/ for the address and a map.) As usual, feel free to come any time after 6:30 and bring something to eat.

We have a double-header this month. Garth Groft will a look at his adventures in moving an application to the Web. Jim Walsh will present “An example of developing a COM server in VFP”.

Here are the bios and abstracts:

Garth Groft is currently the lead developer and owner of MicroComputer Task Group (MCTG) located in York Pa. With 22 years of custom Fox and Visual Fox programming experience, he has been a consultant, a contract programmer, and leader of a nine man development team. Clients include Fortune 500 companies. The company has an International applications user base numbering well over a1000 users in most every county worldwide. In addition to IT consulting and applications development, MCTG has a strong knowledge base of HVAC (Heating, Ventilating, and Air-Conditioning), heat transfer, numerical analysis, statistical analysis and CAD (Computer Aided Design). The company is currently focused on developing cost-effective strategies and solutions for porting VFP applications to the web. This strategy addresses growing interest by clients in "cloud" applications accessible via mobile devices while maintaining VFP as an integral part of the solution. Protecting my clients’ investments in VFP applications is also key to this strategy. The RAD advantages of VFP are ported to the web.

Garth's presentation centers on an invoice payment application developed in two distinct VFP-based web servers, VFP2IIS and Fox In Cloud. Fox In Cloud utilizes West Wind Web Connect, Active Widgets and Fox In Cloud's own unique Application Adapter Assistant.

Jim Walsh has a Ph D in Physiology and Biophysics, and an MS in Physics. He is an independent consultant specializing in biomedical, scientific and engineering applications, primarily in VFP and C++.

Jim's talk is entitled “An example of developing a COM server in VFP”. COM servers represent a good strategy for providing functionality that is needed by several programs written in different languages. Jim will describe the development of a COM server that provides access to the data in a Firebird database for VFP and C++ clients. Visual FoxPro makes developing COM servers relatively easy. It hides many of the underlying details. But, can the things hidden by the Fox come back to bite you?

Tuesday, March 8, 2011--Open Mike Night

This month, we're having an open mike night, so please think of something to share with the group. It doesn't have to be much--a productivity tip, a book you think everyone should read, something cool you've done, or a question you need answered. (If you can't think of anything, please come anyway.)

Tuesday, February 8, 2011--Bob Pierce will present "Sidebars, add customizable convenience for your users."

A customizable sidebar is a great way to give your users quick access to information and functionality to increase productivity. I will show some of the benefits of a sidebar as well as the technique I used to create a production sidebar using VFP. I will then discuss some of the things I learned and would do different if I were to build a sidebar from scratch today.

Then, Tamar Granor will give a presentation on preparing and giving presentations.

Tuesday, January 11, 2011CANCELLED DUE TO SNOW

Tuesday, December 14, 2010--This month, we'll have a few short presentations. Bill Fitzgerald will talk about SQL Stored procedures with .NET. Bob Pierce will present "Sidebars, add customizable convenience for your users."

Here's Bob's abstract: A customizable sidebar is a great way to give your users quick access to information and functionality to increase productivity. I will show some of the benefits of a sidebar as well as the technique I used to create a production sidebar using VFP. I will then discuss some of the things I learned and would do different if I were to build a sidebar from scratch today.

Depending on time, we may have one more short take.

We will be raffling off a one-year Visual Studio 2010 Ultimate with MSDN subscription, with a retail value of nearly $12,000. (Note: it must be activated by the end of the year.) All those present will be eligible to win. We have some nice giveaway items from Microsoft as well.

We're looking for presenters for 2011. Please get in touch with Bob Pierce ([email protected]) if you have something to share with the group.

Tuesday, November 9, 2010--Tamar Granor on "Office Automation Tips, Tricks and Traps"

Monday, October 11, 2010--Christof Wollenhaupt on "How the Fox is Different."

Tuesday, September 14, 2010--Bo Durban on "Extending VFP using the Web Browser Control"

Tuesday, July 13, 2010-- Tamar Granor on Collections

Southwest Fox preview

Abstract: When the collection base class was added to VFP 8, it gave us the opportunity to make our applications look more like those in other object-oriented languages. Collections let us manage groups of related objects through a straightforward interface, and avoid the peculiarities of working with arrays in VFP.

In this session, we'll cover the basics of using collections, the reasons why they're better than arrays, and show how they improve object models. We'll also consider the weaknesses of collections in VFP and talk about workarounds.

Tamar E. Granor, Ph.D., is the owner of Tomorrow's Solutions, LLC. She has developed and enhanced numerous Visual FoxPro applications for businesses and other organizations. She currently focuses on working with other developers through consulting and subcontracting.

Tamar served as Editor of FoxPro Advisor magazine from 1994 to 2000 and was Technical Editor from 2000 to 2008. She served as co-author of the popular Advisor Answers column from 1993 to 2008. She has also written for Fox Talk and CoDe; she currently writes for Fox RockX.

Tamar is author or co-author of ten books including the award winning Hacker's Guide to Visual FoxPro and Microsoft Office Automation with Visual FoxPro. Her most recent books are Making Sense of Sedna and SP2 and Taming Visual FoxPro's SQL. Her books are available from Hentzenwerke Publishing (hentzenwerke.com).

In 2007, Tamar received the Visual FoxPro Community Lifetime Achievement Award. She has received Microsoft Support's Most Valuable Professional award annually since the program's inception in 1993. Tamar speaks frequently about Visual FoxPro at conferences and user groups in North America and Europe. You can reach her at [email protected] or through tomorrowssolutionsllc.com

Tuesday, June 8, 2010--Advantage Database Server

Speakers: Chris Franz and Jay Wendt of Sybase

Abstract: You already know that Visual FoxPro is one of the best tools available for application development, but did you know that Advantage Database Server has better support for Visual FoxPro than any other database engine? Join us as we take you on a tour through the product. We'll introduce you to Sybase and how Advantage fits into the big picture. Then, we'll move on to the technical aspect of the server and why it's different than any other database engine. You'll see getting started tips and demos to view first hand and just how easy it is for FoxPro developers to move to client/server with Advantage. We'll even provide development versions of the software for attendees.

Tuesday, May 11, 2010--Doug Hennig (via teleconference), Introduction to GDIPlusX

GDIPlusX is a VFPX project that exposes GDI+ to VFP applications as a set of VFP class libraries. GDIPlusX makes it easy to add new graphical abilities to your applications, allowing you to provide a fresher and more powerful user interface. This session provides an introduction to GDIPlusX, going through the basics of GDI+, looking at the classes in GDIPlusX, and going through various samples of how to use GDIPlusX in VFP applications.

Doug Hennig is a partner with Stonefield Systems Group Inc. and Stonefield Software Inc. He is the author of the award-winning Stonefield Database Toolkit (SDT); the award-winning Stonefield Query; the Member Data Editor, Anchor Editor, and Cursor Adapter and Data Environment builders that come with Microsoft Visual FoxPro; and the My namespace and updated Upsizing Wizard in Sedna.

Doug is co-author of Making Sense of Sedna and SP2, Visual FoxPro Best Practices For The Next Ten Years, the What's New in Visual FoxPro series (the latest being What's New in Nine), and The Hacker's Guide to Visual FoxPro 7.0. He was the technical editor of The Hacker's Guide to Visual FoxPro 6.0 and The Fundamentals. All of these books are from Hentzenwerke Publishing (hentzenwerke.com). Doug wrote over 100 articles in 10 years for Fox Talk and has written numerous articles in FoxPro Advisor, Advisor Guide to Visual FoxPro, and CoDe. He currently writes for Fox RockX (foxrockx.com).

He spoke at every Microsoft FoxPro Developers Conference (DevCon) starting in 1997 and at user groups and developer conferences all over the world. He is one of the organizers of the annual Southwest Fox conference. He is one of the administrators for the VFPX VFP community extensions Web site (vfpx.codeplex.com). He has been a Microsoft Most Valuable Professional (MVP) since 1996. Doug was awarded the 2006 FoxPro Community Lifetime Achievement Award (fox.wikis.com/wc.dll?Wiki~FoxProCommunityLifetimeAchievementAward~VFP).

Web: stonefield.com and stonefieldquery.com
Blog: doughennig.blogspot.com
Twitter: twitter.com/DougHennig

Tuesday, April 13, 2010--Chick Bornheim, President and Founder of Micromega Systems

Dinner will be provided for this meeting. Please RSVP to [email protected] if you plan to come for dinner.

Chick Bornheim has spent over 30 years in various app-dev roles including user liason, designer, developer, program manager, marketing, licensing, and executive management. He is a principal member of the Foxfire! design team and two other vertical products, founder of two successful businesses and has advised or assisted in the many other startups.

Foxfire! Report Writer v8+ comprises a family of data mining tools designed for regular business users. Developers can: Foxfire! is the only set of report writers for the vfp environment that can operate interchangeably on both platforms. Its interactive drag-'n-drop design tools has been praised by usability experts and end users alike for simplicity without sacrificing power.

Micromega Systems offers Foxfire! consulting, integration, and training services. Our growth strategy is partnering, and we are currently seeking other developers who want to partner to create custom or localized versions to address special market opportunities. Go to foxfirereporting.com to explore how we might work together.

Andrew MacNeill will join Chick by teleconference to demonstrate how east it is for developers adapt Foxfire! to simplify the user's experience of reporting with a custom database, and how simple it is to port the Windows version to the Foxfire! Web Report Writer.

Tuesday, March 9, 2010--Open Mike Night!

We'll pick up last month's cancelled "Open Mike Night." Bring one command or function that you find really useful, but think is not widely used. It could even be a particular way of using a command or function. If you can demo whatever it is from the Command Window, you don't need to bring a laptop; we'll have one available.

Also, feel free to come with a short demo or a question for the group.

Note the change of location (above) for this meeting.

Tuesday, February 9, 2010--Canceled due to impending snowstorm.

Tuesday, January 12--TamarGranor will present "Getting Your Head Around Business Objects"


For many years, we've heard that business objects are important, but most of the examples are tied too tightly to the user interface to really make the point. In this session, we use a highly graphical example to show how business objects can really improve your applications. We see how a well-designed set of business objects makes changing an application's behavior easier and keeps your application's functionality separate from its user interface.

Tuesday, December 8--Member presentations

This month will feature a collection of short user presentations. We'll start off with Bill Fitzgerald, who'll present a standalone desktop organized based on the hotlinked editbox that Craig Benson showed a while back, plus a solution for appending Excel 2007 files into DBFs. If you have one or more short items to present, let Bob Pierce ([email protected]) know.

THURSDAY, November 12 (Special night)--Menachem Bazian on Open Source Tools

Abstract: Open Source is a phenomenal resource for high quality software that can easily be integrated into your work and make your life much easier. This session shows several tools you can use to make your business and software development life a pleasure.

The session also demonstrates how some of these tools can be set up and work withiin your organization. Tools discussed include, but are not limited to:

Subversion (and Tortoise SVN)
MantisBT
SugarCRM

Bio: Menachem Bazian, CPA, CITP is President and Founder of BC Consulting Services, Inc, a Business Management and Technology Consulting Firm based in northern NJ. Menachem has been a database developer for over 20 years, having starting out with Dbase II and moved on to Dbase III, Clipper, Foxbase and all the versions of Visual FoxPro to date. He returned to the Fox speaking circuit last year including Southwest Fox 2008. He has published numerous articles and books over the years.

Tuesday, September 8, 2009 Toni Feltman. Topic: Introduction to Subversion and Tortoise SVN

Note: special time--this meeting will begin at 6:30 PM. We will be providing a pizza dinner at this meeting; we'll eat while Toni talks. The doors will open at 6:15; we'll try to have the pizza ready then. If you plan to attend and eat, please send an email to [email protected], so we get enough.

Abstract: Version control is a must for any application development platform yet many development shops still do not use a version control system. There are all sorts of excuses such as time, money or lack of team support. Once you adopt a version control system, your team will wonder how you ever lived without one. In this session, we take an in-depth, action packed look at using Subversion and Tortoise as a version control repository for FoxPro applications. Most FoxPro developers are cost conscious so how much better can you get than a FREE version control system. Subversion and Tortoise are both free tools that despite the price, work great.

Bio: Toni Feltman, a Microsoft Certified Professional, is an experienced software developer, project manager, instructor and speaker. She is Vice President and a Partner at F1 Technologies and is still an integral part of the company. During her 16 years at F1 Technologies she has served as both a developer and project manager on numerous projects and as Product Manager for the highly successful FoxExpress product line.

Toni is a well known contributor to the Visual FoxPro development community. She has spoken at most major FoxPro conferences in North America and Europe. Although Toni has expertise in a number of areas, she generally focuses her presentations on Team Development, XML, n-Tier Development and new features in Visual FoxPro.

Toni has penned several articles for Advisor Guide to Microsoft Visual FoxPro and is co-author of Making Sense of Sedna and SP2 and What's New in Visual FoxPro 9.0 (Hentzenwerke Publishing). Toni also designed and developed Project HookX, a VFPX utility designed to allow developers to manage and use multiple project hooks on a single Visual FoxPro Project. Toni is one of several co-authors of DBCX, a public domain data dictionary tool used or supported by many notable Visual FoxPro products including the Stonefield Data Dictionary, Visual FoxExpress, Fox Fire! and Stonefield Query.

Toni taught for several years at the University of Toledo on a wide variety of technologies including Microsoft Office applications, XML, various Internet development technologies and database design and programming. Toni also enjoyed a stint as an instructor for AppDev.

Toni's introduction to the FoxPro community came while she worked in the technical support department at Fox Software. Toni was a senior level support technician and Sysop of the Fox Software Forum on CompuServe.

Toni graduated from Bowling Green State University in 1989 with a BA in Management Information Systems.

Tuesday, August 11, 2009 Tamar E. Granor. Topic: Top 10 (or more) Reasons to use the Toolbox

The VFP Toolbox is a terrific tool, but many VFP developers have never really used it. In this session, we'll look at why you should use this tool everyday. We will look at built-in capabilities like an easy way to drop controls into grid columns. We'll also see how to customize it for your development environment, including having each control you drop given an appropriate name. Finally, we'll explore some easy extensions that make the Toolbox even more useful, such as making it easy to store web links.

Tamar E. Granor, Ph.D., is the owner of Tomorrow's Solutions, LLC. She has developed and enhanced numerous Visual FoxPro applications for businesses and other organizations. She currently focuses on working with other developers through consulting and subcontracting.

Tamar served as Editor of FoxPro Advisor magazine from 1994 to 2000 and was Technical Editor from 2000 to 2008. She served as co-author of the popular Advisor Answers column from 1993 to 2008. She has also written for Fox Talk and CoDe; she currently writes for Fox RockX.

Tamar is author or co-author of ten books including the award winning Hacker's Guide to Visual FoxPro and Microsoft Office Automation with Visual FoxPro. Her most recent books are Making Sense of Sedna and SP2 and Taming Visual FoxPro's SQL. Her books are available from Hentzenwerke Publishing (hentzenwerke.com).

In 2007, Tamar received the Visual FoxPro Community Lifetime Achievement Award. She has received Microsoft Support's Most Valuable Professional award annually since the program's inception in 1993. Tamar speaks frequently about Visual FoxPro at conferences and user groups in North America and Europe.
You can reach her at [email protected] or through tomorrowssolutionsllc.com.

Tuesday, July 14, 2009Menachem Bazian: SQL in Many Forms

Menachem Bazian, CPA, CITP is President and Founder of BC Consulting Services, Inc, a Business Management and Technology Consulting Firm based in northern NJ. Menachem has been a database developer for over 20 years, having starting out with Dbase II and moved on to Dbase III, Clipper, Foxbase and all the versions of Visual FoxPro to date. He returned to the Fox speaking circuit last year including Southwest Fox 2008. He has published numerous articles and books over the years.

"SQL in Many Forms": SQL is the lingua franca of data. Introduced into FoxPro way back in 2.0, VFP developers have been using it in applications for years. With the growing popularity of using Client Server back ends, it is necessary to know the differences between the various favors of SQL you will encounter. The session concentrates on VFP, MySQL, and Microsoft SQL Server flavors of SQL.

We will be providing a kosher deli dinner beginning at 6:30 PM. If you plan to join us for dinner, please email [email protected], so we get enough food. There is a $5 fee for the meeting.

Tuesday, June 9, 2009 Bob Pierce on "Nothing but Net": Visual FoxPro can be a great tool for interacting with the Internet. This session will include many different ways to use VFP to send emails, download content, send files using FTP, publishing content, and run a VFP web server. All of the techniques use freely available tools that can easily be integrated into your applications with a minimum of effort.

Those present will be eligible to win a 1-year MSDN Premium subscription, including Visual Studio Team System 2008 Team Suite. (The subscription must be activated by 6/30/2009.)


Tuesday, May 12, 2009 Jerry Noble will demonstrate his search engine which sequentially searches for customers on 10 different criteria using class code which allows for the use of navigation keys and auto-capitalization. He will also show how he uses a Bar Code Scanner to search for and populate the application with the information found on the Vehicle Registration Card.

Tuesday, April 14, 2009 Our headliner this month is Craig Benson from TIW. He'll present two short topics.

Embedded Hyperlinks

Embedded File Hyperlinks provide a simple method from within a VFP application to access all types of files including Word documents, Excel spreadsheets and CAD drawings. An easy approach will be demonstrated for enabling the user to add these links to any existing application. This capability has been a real crowd pleaser with our customers.

Screen Modification Tool

The ALERE products include a screen modification tool that allows our users to change the layout and properties of objects on any form in real time. This feature provides form modification capabilities with a presentation consistent with the VFP Form Designer. This tool supports the dragging and dropping of objects and the changing of properties on a custom property sheet. The capabilities, design and underlying structure will be presented and examined.


In addition, Bill Fitzgerald will present a brief demo of the WAV player foundation class.

Tuesday, March 10, 2009

Several members will contribute to this month's meeting. Tim Saylor will present a calendar control and several other items. Tamar Granor will show the Control Renamer builder, which she recently contributed to VFPX. If time permits, Bob Pierce will follow up on the search utility he showed last month and show a GDI+ tool for rotating graphics.

Tuesday, February 10, 2009

Alen Kalati will show two things:

First, a customizable toolbar. Alen explains: My application starts with a number of empty toolbar buttons which the user can then choose what they would do. The selection is done simply by right clicking the toolbar button while a form is open, which then it assigns it its 'click' method.

Second, a simple way of associating photos with inventory items using a bar code scanner. Again, a simple but very effective trick of doing this, which since has really revolutionized the way photos are associated with rugs in the rug industry.

Bob Pierce will talk about searching within a grid, integrating with filtering and sorting options.

We anticipate some time for open mike or questions at the end of the meeting, so if you have a little something to share, come prepared to do so.

Tuesday, January 13, 2008 Bill Fitzgerald will introduce us to another VFPX tool, FoxCharts.

Then Craig Benson will talk about "Subclassing - a simple way to create a customizable and patchable application." Here's his abstract:

VFP allows applications to be created with layers of hierarchy. These layers can be used to turn product customization and code patching into managable tasks. This session will show how to use these layers to make custom versions of an application using the VFP screen designer, add features to an application and create patches for distribution without redistribution the entire application.

Tuesday, December 9, 2008 VFPX

This month, we'll begin an exploration of VFPX. BobPierce and Tamar Granor will show some of the VFPX projects, including the Property and Method dialog replacements, FoxCharts, GDIPlusX, and the Outlook Bar control.

VFPX is an Visual FoxPro community open source project dedicated to enhancing and extending Visual FoxPro. It includes developer tools, enhanced controls, the Sedna components, the various Xbase tools that come with VFP, and more. The items to be shown at this meeting range across the spectrum of VFPX projects. They include some items you can use immediately and others to keep in mind for the right project.

Tuesday, November 11, 2008 Bob Pierce leads a session on the Conference Experience.

For those of you who couldn't attend the SouthWest Fox conference this year, this is your chance to find out what's new with our favorite tool. We will start off with video of the keynote presentation and cover several topics discussed at the conference. This will include updates on Christof's Guineu project, the eTecnologia Extender/Compiler, and the VFPX project. In addition, Bob will introduce an exciting client/server platform, the Advantage Database Server, which promises to make it much easier for VFP developers to make the move to a server based SQL backend.

There will be some giveaway goodies from the conference, as well.

Tuesday, September 9, 2008 Tamar Granor: We Used to Do it That Way, But ...

Each new version of Visual FoxPro has brought new ways to do things, but breaking old habits is hard. Now that the VFP language has stabilized, it's time to hone our skills. This session examines some of the changes in the language over the years and demonstrates that learning to use the newer constructs can result in better, more maintainable, faster code.


Tuesday, August 12, 2008 Menachem Bazian on Setting Up a LAMP server

Menachem Bazian, CPA (NY), CITP is the President of BC Consulting Services, Inc., a business management and technology consulting firm specializing in enhancing client efficiency with intelligent application of technology. He has been a Fox developer for over 20 years and is the author of three books and numerous articles on the topic. He was a featured speaker at DevCons for over a decade.

This session will discuss how to set up a LAMP (Linux, Apache, MySQL, PHP) server. It's a continuation of his last session on MySQL, but those who missed that meeting can still benefit from this one.


Wednesday, July 16, 2008

Speaker: Cathy Pountney

Cathy Pountney is a five-time recipient of the Microsoft VFP MVP award and has been developing software for 26 years, many of which were as an independent consultant specializing in FoxPro. In 2001 she had the privilege of spending six months as a contractor onsite in Redmond with the Microsoft Fox Team. She now works for Memorial Business Systems writing software for the cemetery and funeral home industry. Cathy has spoken at many FoxPro conferences and user groups across the U.S. and Canada, written articles for various magazines, and her book, The Visual FoxPro Report Writer: Pushing it to the Limit and Beyond, is available from Hentzenwerke Publishing. You can contact Cathy at [email protected], view her website at frontier2000.com, and view MBS?s website at mbs-intl.com.

Topic: Customizing Your Vertical Market App:

Writing a vertical market application can be very rewarding. You write one application, sell it numerous times, and sit back while the money rolls in. Well, that?s the theory anyway. The reality is that often times, new clients want to buy your software, as long as you can change this one little thing. Managing custom code for various clients within your application can easily turn into a nightmare as your client base expands. This session shows you how to implement a customization methodology in your vertical market application that keeps your standard code independent from your custom code, yet have the two code bases play nice together.

Wednesday, June 18
Speaker: Marcia Akins

Marcia Akins is an independent Consultant and software developer who for the past few years has worked primarily with Visual FoxPro and SQL Server. She and her husband, Andy Kramek own and operate Tightline Computers, Inc. from their home in Akron, Ohio. She has been awarded the Microsoft Most Valuable Professional since 1999 and also has Microsoft Certified Professional qualifications for both Distributed and Desktop Applications in Visual FoxPro.

Marcia co-authored the Kitbox column in Fox Talk Magazine from November, 2001 through July of 2006. She and her husband, Andy, then wrote a regular column in The Advisor Guide to Microsoft Visual FoxPro database Development until the end of 2007. Their popular Kitbox column is now being published in Fox RockX magazine. Marcia's published work also includes several articles for both FoxPro Advisor and Fox Talk magazines as well as the very successful book "1001 Things You Wanted to Know About VFP" (Hentzenwerke publishing, 2000) and "Mega Fox: 1002 Things You Wanted to Know About Extending VFP"
(Hentzenwerke publishing, 2002).

Speaking engagements include Southwest Fox(Tempe, 2004, 2005, 2006, 2007), OzFox(Sydney, Australia, July 2003), Visual FoxPro Devcon (Prague, Czech Republic, June 2002, 2005, 2007), Essential Fox (Kansas City, 2002, 2003, 2004), Conference to the Max (Holland, May 2000 and May 2002), Great Lakes Great Database Workshop (Milwaukee, 2000, 2001, 2002, 2003, 2006), Advisor Devcon (San Diego, September 2001 and Fort Lauderdale, September 2002), German Devcon (Frankfurt, November 2001, 2002, 2003, 2005, 2006, 2007), as well as user group meetings in Europe and the U.S.

Web site: tightlinecomputers.com


Topic: Practical Uses for the Windows API

This session introduces Windows API programming for Visual FoxPro developers. Marcia begins by reviewing what the API is and how to translates the examples that are often in Visual Basic or Visual C++ into good old Visual FoxPro syntax. She will then present several practical examples using Windows API functions to do things that cannot be accomplished using native Visual FoxPro commands. These examples include code to read the Windows Registry and retrieve user settings from the Control Panel, code to ensure that the screen is really locked when we must manipulate the appearance of ActiveX controls in our VFP forms, and much more.

Wednesday, April 16
Informal Code Review--bring some code

Wednesday, March 19

Topic: Guineu Project

The Guineu project is one of the most promising solutions to the VFP developer to be able to extend the viability of the language we all love. Being run by Christof Wollenhaupt, one of the brightest minds in the Fox community, the Guineu project is a replacement set of runtime DLL's that run your compiled VFP code in a .NET environment.

So what does that mean for us, for starters your VFP application can now run on most platforms that support .NET. This includes future versions of Microsoft OS, Linux, PDA's, and web pages.

Currently the project is still very young and is far from being complete, but it already provides usable functionality and is being updated aggressively. I will show how to take a simple existing program, compile it with Guineu, and run it in Windows, Linux, PDA, and a web page.

More information can be found at foxpert.com and the beta is available free.

Speaker: Robert Pierce

Robert Pierce is currently the Manager of Information Services and senior developer at Smooth-On Inc., a rubber and plastics manufacturing company located in Easton, PA. With 23 years of custom Fox programming experience; he has been a consultant, a contract programmer, and part of the TIW development team.


Wednesday, February 20.

Speaker: Menachem Bazian

Menachem Bazian is a New York certified CPA and is a Certified Information Technology Professional (CITP). He is President and CEO of BC Consulting Services, Inc., a full services business management and technology consultancy specializing in optimizing business operations through intelligent integration of business processes and technology.

Menachem has been a VFP developer since the early days. He actually started out with Dbase II before moving on to Dbase III, Clipper, FoxBase, FoxPro and then to Visual FoxPro. He has authored three books on Fox, numerous articles in various publications, and spoke at 10 of the first 11 DevCons.

Lately he has been specializing in client-server development using SQL Server and, even more recently, with MySQL.

Topic: VFP and MySQL

Visual FoxPro is the premier tool for developing robust client-server applications using a wide range of database backends. The two most popular are, perhaps, SQL Server and MySQL.

This session will show a method for rapid development of Client Server applications using Visual FoxPro. The goals of this session are

1) To highlite the differences between developing applications based on native Visual FoxPro tables and a Client Server backend,

2) To illustrate the differences between back-end environments,

3) To illustrate that development of a client server application is actually very simple and requires little extra coding knowledge beyond standard Visual Foxpro syntax.

Wednesday, January 16.

Best laid plans department, part 2. Bob Pierce is sick and can't present. Tamar Granor will present "Using the VFP Debugger Effectively."

Visual FoxPro has a powerful debugger that provides many tools for finding problems with your code. This session will dig into the Debugger, showing how you can make the most of its tools in order to speed development, improve your code, and understand VFP better.

The Guineu session will be rescheduled.

Wednesday, November 28.
Open Forum on VFP and 3rd party tools.

Wednesday, October 24. Note 4th, rather than 3rd, Wednesday.

Topic: Review of Southwest Fox

Plus: Bill Fitzgerald: Keeping users informed of changes to business' status quo

Speaker: Bill Fitzgerald is founder and president of Woodbury Systems Group, a Long Island based consultancy specializing in using Visual Foxpro to develop and support Financial, Distribution and Manufacturing System for small to mid-sized businesses.

He founded Woodbury Systems Group in 1984 after a long career in corportate MIS and Financial management. Since he moved to Hamilton NJ in 2006, his daughter and long-time partner Deirdre Volpe has assumed the responsibilities of running the business in New York and Bill has concentrated on programming, golf, painting and his family.

Bill saw combat with the United States Air Force. He has a BS from Adelphi University and is a Visual FoxPro MCP.

Topic: the use of asynchronous queries and transactions to keep designated users informed of important changes in the status quo of a business.

The focus will be on a framework his company has developed and successfully deployed for several clients.

Wednesday, September 19
Tamar practices for Southwest Fox!

Speaker: Tamar E. Granor
Tamar E. Granor, Ph.D., is the owner of Tomorrow's Solutions, LLC. She has developed and enhanced numerous FoxPro and Visual FoxPro applications for businesses and other organizations. She currently focuses on working with other developers through consulting and subcontracting. Tamar served as Editor of FoxPro Advisor magazine from 1994 to 2000. She is currently the magazine's Technical Editor and co-author of the popular Advisor Answers column.

Tamar is author or co-author of nine books including the award winning Hacker's Guide to Visual FoxPro and Microsoft Office Automation with Visual FoxPro. Her most recent books are Taming Visual FoxPro?s SQL: Real-World Data Solutions for VFP and What?s New in 9: Visual FoxPro?s Latest Hits. Her books are available from Hentzenwerke Publishing (hentzenwerke.com).

Tamar is a Microsoft Certified Professional and a Microsoft Support Most Valuable Professional. Tamar speaks frequently about Visual FoxPro at conferences and user groups in North America and Europe, including every FoxPro DevCon since 1993. She served as Technical Content Manager for the 1997-1999 Visual FoxPro DevCons and was part of the coordination team for the Visual FoxPro Excellence Awards.


Topic: The How and Why of Test Data
A realistic test data set provides a variety of advantages to developers, testers and end users, yet most applications don?t include one. In this session, we?ll look at the reasons for supplying test data and examine ways to generate it

Wednesday, August 15, 2007

Speaker: Jim Walsh

I was born and raised in Philadelphia. I have a BS, Physics from St. Joseph's College (Phila), MS, Physics from Brown Univ (Providence, RI), and a Ph D in Physiology & Biophysics from Univ of Vermont (Burlington, VT). I did a post-doctoral fellowship in neuroscience at the Univ of Pennsylvania.

After my MS degree, I worked for a couple of years with IBM in semiconductor technology development in Vermont.

I was an Assistant Professor at Beaver College in Glenside, PA for several years teaching Anatomy & Physiology, and Computer Science.

While teaching, I was doing computer consulting on the side. I finally decided that computer consulting was more fun, and gave up teaching entirely.

The general theme of my career has been the use of computers in science, engineering, and medicine. I've had an opportunity to work in a lot of different fields (the advantages of being a Physics major). In college I worked for a year in a work-study program at NASA's Goddard Spaceflight Center. That is where I first learned to program. We were using computers to simulate proposed launches to determine the best parameters for getting successful orbits.

My master's thesis was a magnetic resonance study of the structure of glass. Part of that involved using computers to simulate the measured spectra.

At IBM, I was involved in characterizing semiconductor processing techniques that were coming out of the development labs. Part of that involved computer simulations of the experimental measurements.

At the Univ of Vermont, I did research that involved electrical recordings from single brain cells. I used a DEC PDP-8 computer to completely control the experiments, and also computer simulation to model the results.

My consulting work as been in the area of medical applications, mostly in the field of Biomechanics and Podiatry. I am also part-inventor of a system for measuring human gait: GaitMat II.


Topic: Medical Computer Consulting - Looking at the world of medicine from the computer consultants point of view. This includes analyzing and integrating data in a variety of forms and using automation to help provide a comprehensive patient information.

Wednesday, June 20, 2007

We'll meet at 7 PM at Valley Forge Pension Management, 715 Twining Road, Suite 202, Dresher, PA 19025. As always, feel free to bring something to eat and arrive as early at 6:30 for discussion and dinner.

Speaker: Kevin Goff
Kevin S. Goff is the founder and Principal Consultant: Common Ground Solutions. He has 18 years experience - NET/SQL Server/Crystal Reports/Visual FoxPro and is a 2005-2006 Microsoft .NET MVP for C#. Kevin is the author of "The Baker's Dozen" series in CoDe Magazine (Productivity Tips for .NET, Crystal Reports, and T-SQL) and one of the 2005 Personalities of the Year on the Universal Thread for .NET and SQL Server.

Kevin's current activities include multiple .NET project contracts, writing regularly for CoDe magazine, a book contract with Apress on Reporting Solutions in VS2005, a contract to write exam questions for VS2005 certification exams, speaking at 2005/2006 Dev TeachOffsite link to devteach.com, MSDN CodeCamp, and .NET User Groups, the Common Ground Framework for .NET (free framework). He has awards and citations from the Dept. of Agriculture and large corporations.

Reach him at commongroundsolutions.net, [email protected]
Read his blog at TheBakersDozen.net.


Topic: T-SQL 2005
This presentation demonstrates the new language capabilities in T-SQL 2005. Microsoft added many new language features to SQL 2005, either for compliance with the SQL-99 standard, and/or in response to customer requests. This session features a number of practical, ready-to-run code samples for such new features as PIVOT, APPLY, OUTPUT, Ranking functions, and Common Table Expressions/Recursive queries. It also demonstrates some of the new XML capabilities.

This session teaches you:

How to build reusable functions for data-handling The new language features in T-SQL 2005 How to do things more efficiently in T-SQL 2005 than in prior versions of T-SQL How to take advantage of the new XML capabilities to handle such tasks as querying a variable number of selections

Wednesday, May 16, 2007


Speaker: Craig Benson

Bio: Co-Founder and Director of Development of TIW Technology.
Established in 1983, TIW has developed the Work Shop manufacturing (1990) and ALERE accounting (2002) products. These mid-range VFP products are sold through a network of third party resellers. The TIW products feature a framework architected to provide a versatile feature set along with a extensible third party development environment.

Prior experience includes real-time process control and data acquisition software development for Quadrex/FLIC Computer Systems, Princeton, NJ.
Project work included Chemical, Petro- Chemical and Nuclear Utility applications.


Topic: TIW Report Object - Architecture and Versatility

TIW Technology is the author of three FoxPro based application (ALERE, ShopLink, and Work Shop). Each of these products use a common report object. The session will examine the architecture of this highly configurable shared object. This report model supports more than 200 varied reports across the three products. These reports range from simple single table lists to complex multi-table compilations.
Among these areas discussed will be the run-time generation of user specific report options, integration of custom code, generic report templates, and user hooks.


Speaker: Robert Pierce

Robert Pierce is currently the Manager of Information Services and senior developer at Smooth-On Inc., a rubber and plastics manufacturing company located in Easton, PA. With 23 years of custom Fox programming experience; he has been a consultant, a contract programmer, and part of the TIW development team.


Topic: VFP IN THE WAREHOUSE

Extending VFP to the warehouse using a WIFI XP Tablet PC We have recently integrated a pocketbook sized Tablet PC to allow access to live data using VFP. Although this project was easy to design there are some interesting considerations and tradeoff's. I believe this technique will be very practical on the next generation PDA's and other portable devices. East to follow 'minimalist' VFP OOP design will have interest to varying skill levels.

Wednesday, April 18, 2007
Topic: Best Practices for User Interfaces
The user interface is your application's appearance to the world. Throwing it together as an afterthought is like putting on the first clothes you grab from your closet. In both cases, the result may or may not look good and may or may not be appropriate to the occasion.

This session will start from the top and dig down into the mysteries of designing the interaction and interface of an application. After discussing why user interfaces matter, it will provide best practices for both the design and implementation stages.

Speaker: Tamar E. Granor
Tamar E. Granor, Ph.D., is the owner of Tomorrow's Solutions, LLC. She has developed and enhanced numerous FoxPro and Visual FoxPro applications for businesses and other organizations. She currently focuses on working with other developers through consulting and subcontracting. Tamar served as Editor of FoxPro Advisor magazine from 1994 to 2000. She is currently the magazine's Technical Editor and co-author of the popular Advisor Answers column.

Tamar is author or co-author of nine books including the award winning Hacker's Guide to Visual FoxPro and Microsoft Office Automation with Visual FoxPro. Her most recent books are Taming Visual FoxPro?s SQL: Real-World Data Solutions for VFP and What?s New in 9: Visual FoxPro?s Latest Hits. Her books are available from Hentzenwerke Publishing (hentzenwerke.com).

Tamar is a Microsoft Certified Professional and a Microsoft Support Most Valuable Professional. Tamar speaks frequently about Visual FoxPro at conferences and user groups in North America and Europe, including every FoxPro DevCon since 1993. She served as Technical Content Manager for the 1997-1999 Visual FoxPro DevCons and was part of the coordination team for the Visual FoxPro Excellence Awards.


Wednesday, March 21, 2007
Topic 1: The future of VFP
With the announcement from Microsoft of the end of development of VFP, and Sedna being released as open source, what does the future hold for VFP developers?

Topic 2: Print your forms
Speaker: Tamar E. Granor
Some applications call for printing exactly what the user sees on screen. Here's a technique for printing a form, even if it's scrollable.


Wednesday, February 21, 2007

Speaker: Tim Saylor
Tim has been programming since 1983 when he was Transportation Manager at Commodore Business Machines. He started on a Commodore 8032 with PET Basic using relative files. When presented with an IBM PC clone, he switched to dBase III+, then several versions of Clipper. In 1989 he began to use Fox Software and has used every version since. He is currently Director - MIS at Valley Forge Pension Management, inc.

Topic: Social Security Number validation with Visual FoxPro

We'll look at the components of a Social Security Number, view a bit of SSN history, then go into some FoxPro procedures. There's a program that parses the HighGroup.txt file (found on the SSA website) into a FoxPro table. Another program or function takes a Social Security Number and verifies that that number has been issued. This is useful as an initial check for a valid Social Security Number.

If time permits, we'll watch part of a webcast presentation by the late Drew Speedie on VFP 9 enhancements to the form & class designers.

Wednesday, January 10, 2007

Speaker: Tamar E. Granor
Tamar E. Granor, Ph.D. (Tamar Granor), is the owner of Tomorrow's Solutions, LLC. She has developed and enhanced numerous Visual FoxPro applications for businesses and other organizations. She currently focuses on working with other developers through consulting and subcontracting. Tamar served as Editor of FoxPro Advisor magazine from 1994 to 2000. She is the magazine's Technical Editor and co-author of the popular Advisor Answers column.

Tamar is author or co-author of nine books including the award winning Hacker's Guide to Visual FoxPro and Microsoft Office Automation with Visual FoxPro. Her most recent books are Taming Visual FoxPro's SQL and What's New in Nine: Visual FoxPro's Latest Hits. Her books are available from Hentzenwerke Publishing (hentzenwerke.com).

Tamar is a Microsoft Certified Professional and a Microsoft Support Most Valuable Professional. Tamar speaks frequently about Visual FoxPro at conferences and user groups in North America and Europe, including every FoxPro DevCon since 1993. She is a Lecturer in the School of Engineering and Applied Sciences at the University of Pennsylvania. She served as Technical Content Manager for the 1997-1999 Visual FoxPro DevCons and was part of the coordination team for the Visual FoxPro Excellence Awards.

Topic: Customizing the Property Sheet
Since its introduction in VFP 3, the Property Sheet has seen mostly minor changes. Each new version brought a few tweaks. VFP 9 brings significant changes to this tool, introducing a Favorites tab, and most importantly, a mechanism to let you customize behavior.

Wednesday, November 15, 2006 Note change of date

Topic: Open Mike Night plus Southwest Fox Review and code review
Bring a tip, a question, a demo, anything you want to share.


Wednesday, October 11, 2006

Speaker: Tamar E. Granor

Tamar E. Granor, Ph.D. (Tamar Granor), is the owner of Tomorrow's Solutions, LLC. She has developed and enhanced numerous Visual FoxPro applications for businesses and other organizations. She currently focuses on working with other developers through consulting and subcontracting. Tamar served as Editor of FoxPro Advisor magazine from 1994 to 2000. She is the magazine's Technical Editor and co-author of the popular Advisor Answers column.

Tamar is author or co-author of nine books including the award winning Hacker's Guide to Visual FoxPro and Microsoft Office Automation with Visual FoxPro. Her most recent books are Taming Visual FoxPro's SQL and What's New in Nine: Visual FoxPro's Latest Hits. Her books are available from Hentzenwerke Publishing (hentzenwerke.com).

Tamar is a Microsoft Certified Professional and a Microsoft Support Most Valuable Professional. Tamar speaks frequently about Visual FoxPro at conferences and user groups in North America and Europe, including every FoxPro DevCon since 1993. She is a Lecturer in the School of Engineering and Applied Sciences at the University of Pennsylvania. She served as Technical Content Manager for the 1997-1999 Visual FoxPro DevCons and was part of the coordination team for the Visual FoxPro Excellence Awards.


Topic: Making the Most of the VFP Toolbox

The Toolbox offers a marriage of the Form Controls Toolbar and the Component Gallery. In this session, we?ll dig into this tool and show how to use it effectively. You?ll learn how to organize your classes, how to specify what?s displayed at any time, and other tricks for customizing the Toolbox.

Wednesday, September 13, 2006, 7 PM

Speaker: Robert Pierce

Robert Pierce is currently the Manager of Information Services and senior developer at Smooth-On Inc., a rubber and plastics manufacturing company located in Easton, PA. With 21 years of custom Fox programming experience; he has been a consultant, a contract programmer, and part of the TIW development team.

Topic: Data Driven Interfaces

This powerful technique gives the developer and end users many advantages over the more traditional hard coded interfaces. By defining the characteristics of the user interface in data, it can be updated interactively without the need to recompile. I will demonstrate this by building a data driven base class grid from the ground up to show how easy this is to implement. I will also give some examples of other uses of this data driven technique as well as show how the Fox Team relies heavily on this to make VFP flexible.

Wednesday, August 9, 2006, 7PM

Speaker: Kevin S. Goff
Kevin S. Goff is the founder and Principal Consultant: Common Ground Solutions. He has 18 years experience - NET/SQL Server/Crystal Reports/Visual FoxPro and is a 2005-2006 Microsoft .NET MVP for C#. Kevin is the author of The Baker?s Dozen? series in CoDe Magazine (Productivity Tips for .NET, Crystal Reports, and T-SQL) and one of the 2005 Personalities of the Year on the Universal Thread for .NET and SQL Server.

Kevin's current activities include multiple .NET project contracts, writing regularly for CoDe magazine, a book contract with Apress on Reporting Solutions in VS2005, a contract to write exam questions for VS2005 certification exams, speaking at 2005/2006 Dev TeachOffsite link to http://devteach.com, MSDN CodeCamp, and .NET User Groups, the Common Ground Framework for .NET (free framework). He has awards and citations from the Dept. of Agriculture and large corporations.

Reach him at commongroundsolutions.net, [email protected] Read his blog at TheBakersDozen.net.

Topic: Introduction to .NET (from a VFP perspective)
This discussion will include: an overview of the VS2005 environment, and general project structure; C# or VB?; Windows Forms; Creating classes/subclassing Winform controls; Data binding and data binding interfaces; Building a data access layer; Typed datasets; Distributed architectures with web services and remoting; String and date operations; Reflection and type discovery and uses of interfaces; Delegates and events; Miscellaneous tips.


Wednesday, July 12, 2006, 7 PM
FREE PIZZA. Come at 6 PM for a pizza dinner

This month's door prizes include a one-year subscription to MSDN Visual Studio Team System Edition; retail value is over $10,000.

Speaker: Mike Feltman, F1 Technologies

Topic: How?d they do that? Inside F1 Technologies Visual FoxExpress
F1 Technologies has been actively developing Visual FoxExpress since Visual FoxPro 3.0 first went into Alpha testing. In that timeframe, F1 Technologies has pioneered many techniques that are now commonplace to Visual FoxPro development in general and others that were ?leveraged? into Visual FoxPro itself. Developing and maintaining a framework for as long as F1 has can often be extremely challenging. There are always tradeoffs to consider in terms of new features verses backward compatibility. In this session, Mike will reveal the code and the analysis behind various features of Visual FoxExpress. Among the highlights of these topics will be mixing and matching dynamically generated SQL with Visual FoxPro views, using BindEvents to invisibly insert objects into complex runtime hierarchies, implementing data driven object factories and other topics. For non-Visual FoxExpress developers, this session will provide you with insight on how to implement features such as these into your own applications. For Visual FoxExpress developers, this session will help answer the nagging questions of why did they do it that way?? and how do I use this??

Plus: Introducing F1 Technologies Visual FoxExpress

F1 Technologies continues to develop, support and promote its award winning Visual FoxExpress framework. In this session, using the latest and the greatest version of VFE, Mike will demonstrate building an enormously powerful and highly maintainable application in a ridiculously short amount of time. The latest incarnation of VFE features support for many new VFP 9 features, new team development features and even more support for SQL Server.

Whether or not you're interested in acquiring a new Visual FoxPro framework, this session will give you insight into how applications are crafted with what many consider to be the best of breed in Visual FoxPro frameworks and ideas that those not using Visual FoxExpress can apply to their own applications.

Bio: Mike Feltman has been president of F1 Technologies since founding the company in 1990 as Neon Software. With Mike at the helm, F1 Technologies has enjoyed years of success as a consulting firm, training firm, distributor and most notably the developers of the FoxExpress line of application development tools.

Since late 1991, Mike and his wife and partner Toni Feltman have focused on the development of the award winning FoxExpress product line. Since its initial release for FoxPro for DOS in 1992, F1 Technologies has sold over 10,000 copies of FoxExpress in over 100 countries. The latest edition, Visual FoxExpress, continues to be one of the most popular frameworks available for Visual FoxPro.

Prior to the release of FoxExpress, F1 Technologies focused primarily on FoxPro training and provided training to hundreds of developers throughout North America. Mike developed courseware for and taught several popular FoxPro for DOS and Windows courses.

In addition to his work on FoxExpress, Mike is a frequent conference speaker and has spoken at conferences throughout North America and Europe on a wide variety topics. Mike?s main focus is Visual FoxPro application development, but he also speaks on object orientation, Internet application development, client-server development, the software business and other subjects. Mike has also published articles in FoxPro Advisor, Fox Talk and the Virtual FoxPro User Group?s newsletter and served as technical editor of the book Building Visual FoxPro Applications with Visual FoxExpress? published by Hentzenwerke.

Mike is also actively involved in F1 Technologies consulting practice and has developed numerous applications for a wide variety of industries including Automotive, Healthcare, Construction and Manufacturing. Mike has been involved with a number of successful software projects for large companies such as General Motors, Mitsubishi, Libbey Owens Ford, Teledyne and others as well as many projects for small and medium sized business. Mike is heavily experienced in desktop, LAN, client-server and Internet development.

Prior to starting F1 Technologies, Mike worked at Fox Software - the original creators of FoxPro. At Fox Software Mike worked in technical support, training and marketing, developed in-house systems and performed product maintenance on the Fox Central module in FoxBase+

Mike got his start in computers at the age of 15 as an assistant instructor at the University of Toledo and became an instructor at the University of Toledo at the age of 17. At the University Mike taught a wide variety of courses on topics including operating systems, databases, word processing and robotics. Mike also developed the University?s robotics courseware and developed a registration system for the university in FoxBase+.

Wednesday, June 14, 2006, 7 PM
Speaker: Craig Benson
Craig Benson is co-Founder and Director of Development of TIW Technology. Established in 1983, TIW has developed the Work Shop manufacturing (1990) and ALERE accounting (2002) products. These mid-range VFP products are sold through a network of third party resellers. The TIW products feature a framework architected to provide a versatile feature set along with a extensible third party development environment.

Prior experience includes real-time process control and data acquisition software development for Quadrex/FLIC Computer Systems, Princeton, NJ. Project work included Chemical, Petro-Chemical and Nuclear Utility applications.

Topic: A Third Party Application Model

Many applications are designed to solve a specific problem. The design of a multi-purpose product must solve problems that have not yet been defined. In order to do this, a different application structure is required. This discussion will include: data driven product definition and behavior, multiple modification levels, and a unique approach to addressing Micorsoft SQL Server tables from within a FoxPro application.

Wednesday, May 10, 2006, 7PM
Open Discussion


Wednesday, April 5, 2006, 7PM (Note: special date!)
Speaker: Michael J. Babcock
Michael J. Babcock is an independent software developer, the President/CEO of MB Software Solutions, LLC (mbsoftwaresolutions.com). Michael holds 2 Microsoft Certified Professional certifications and is the founder and president of the Central PA VFP Users Group (cpvfug.org). Michael participates heavily on Ed Leafe's Pro Fox Tech Mailing list (leafe.com/mailman/listinfo/profoxtech) and in fact has been the top poster for a number of consecutive months, including all of 2005 (leafe.com/archives/showMsg/292927)--and those are ON TOPIC posts, not the off-topic stuff, so the "signal to noise" ratio is very good. Michael is the creator of a vertical market application called FabMate (fabmate.com) that has been in use since 2003. Michael enjoys working with other VFP developers and despite the rumors of VFP's future, Michael enjoys the productivity and flexibility developing in Visual FoxPro 8/9. Michael's client testimonials on the web (mbsoftwaresolutions.com/successes/) show that his clients are more than satisfied with their VFP applications or his contributions to their applications as well. Michael's resume is also available online at mbsoftwaresolutions.com/downloads/resume05.pdf in case you need help with your team!

Topic: (Logical) n-tier design in your VFP applications

For the past 4 years, I have been using a design methodology called "n-tier design." I will explain the concepts/ideas that go into n-tier designs, and share a real, live project designed in VFP9 that I intend to deliver to a client any day now. We'll go through each of the "tiers" of the application, showing the responsibilities of each and how they all interact. Along the way, I'll take questions as to the techniques I've used.



Wednesday, March 8, 2006, 7PM
Topic: Office Automation Beyond the Basics
Speaker: Tamar Granor



Wednesday, February 8, 2006, 7PM

Topic: Our Very First Open Mike Night
Come with a question, a tip, or a brief description or demo of an application you?re working on. Learn from and share with your colleagues.

This month?s drawings will again include a premier membership to the Universal Thread

Anyone interested is also invited to meet for dinner in the mall's food court at 6 PM.

Location: The Church on the Mall, Plymouth Meeting, PA
Directions: shopplymouthmeetingmall.com/pages/aboutus/directions/index.jsp

The Church on the Mall is located next to the food court on the lower level. Walk toward the windows at the end of the food court, and turn right.

Wednesday, January 11, 7PM

Speaker: Tamar E. Granor
Tamar E. Granor, Ph.D. (Tamar Granor), is the owner of Tomorrow's Solutions, LLC. She has developed and enhanced numerous Visual FoxPro applications for businesses and other organizations. She currently focuses on working with other developers through consulting and subcontracting. Tamar served as Editor of FoxPro Advisor magazine from 1994 to 2000. She is the magazine's Technical Editor and co-author of the popular Advisor Answers column.

Tamar is author or co-author of nine books including the award winning Hacker's Guide to Visual FoxPro and Microsoft Office Automation with Visual FoxPro. Her most recent books are Taming Visual FoxPro's SQL and What's New in Nine: Visual FoxPro's Latest Hits. Her books are available from Hentzenwerke Publishing (hentzenwerke.com).

Tamar is a Microsoft Certified Professional and a Microsoft Support Most Valuable Professional. Tamar speaks frequently about Visual FoxPro at conferences and user groups in North America and Europe, including every FoxPro DevCon since 1993. She is a Lecturer in the School of Engineering and Applied Sciences at the University of Pennsylvania. She served as Technical Content Manager for the 1997-1999 Visual FoxPro DevCons and was part of the coordination team for the Visual FoxPro Excellence Awards.


Topic: Solving Common Problems with VFP's SQL
VFP's SQL language offers solutions to a variety of problems faced in many applications. In this session, Tamar presents a selection of problems and examines ways to use VFP's SQL to solve them. The focus is on working with VFP data and the examples provide demonstrations of many of SQL features added in VFP 8 and 9.

Location: MicroEndeavors, Inc., 8001 Lansdowne Avenue, Upper Darby, PA 19082
Directions: microendeavors.com/directions.htm

This month's raffles include a one-year premier membership to the Universal Thread.

Wednesday, December 14, 2005, 7PM

Speaker: John McLaughlin
A developer since 1999 I am experienced in a number of programming languages, and hold and MCDBA certification in Microsoft SQL Server 2000. I have worked with Visual FoxPro and Microsoft SQL Server since my first developer job and have spent a good deal of time integrating the data from both sources. Since December 2004 I have been employed by Dow Jones & Company as an Application Development Consultant for the Indexes department. My primary responsibilities invlove SQL server design and development as well as Visual FoxPro,Visual Basic .Net, and ASP.Net application development, and as you might guess integrating Visual FoxPro and SQL Server data.

Topic: SQL Server and VFP Tips and Tricks on Importing/Exporting SQL and Visual FoxPro data.
Discussion on using Microsoft SQL Server's native functionality to import Visual FoxPro tables as well as using Visual FoxPro to import data from Microsoft SQL Server. Topics include SQL functionality such as OPENROWSET,OPENDATASOURCE,OPENQUERY and DTS as well as a look at executing queries/stored procedures against SQL Server from a VFP program both in Synchronous and Asynchronous modes.

Location: MicroEndeavors, Inc., 8001 Lansdowne Avenue, Upper Darby, PA 19082
Directions: microendeavors.com/directions.htm

This month's raffles include a one-year premier membership to the Universal Thread.


Wednesday, November 9, 2005, 7 PM

Speaker: Robert Pierce
Robert Pierce is currently the Manager of Information Services and senior developer at Smooth-On Inc., a rubber and plastics manufacturing company located in Easton, PA. With 21 years of custom Fox programming experience; he has been a consultant, a contract programmer, and part of the TIW development team.

Topic: Case Study - Smooth-On Inc. Easton, PA
Although being presented as a case study of a local manufacturer using Visual Foxpro, this presentation will showcase my own framework and include design philosophy and integrated technologies. Related technologies such as IP Phone, Fax, Email, and Digital Copiers will be discussed.



The first meeting was held Wednesday, September 14, 2005 and included a discussion about plans for the group.

Speaker: Tamar E. Granor (Tamar Granor)
Topic: Using the VFP Debugger Effectively
More information including driving directions at:
msevents.microsoft.com/CUI/EventDetail.aspx?culture=en-US&EventID=1032280764&EventCategory=1


Contact Tamar Granor ([email protected]) to be added to our email list. Contact Bob Pierce ([email protected]) if you're interested in speaking to the group.


Category User Groups
( Topic last updated: 2018.11.07 04:14:32 PM )