SQL Server Reporting Productivity Tips - Tuesday, September 13th, 2016 at 19h00
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
General information
| Web site: | http://vfpphilly.blogspot.com/ |
| Location: | Devry University
1140 Virginia Drive
Fort Washington, PA.
Check website for each month's meeting room number |
| Address: | 1140 Virginia Drive |
| City: | Philadelphia, Pennsylvania |
| Country: | United States |
User group history/membership rate/objectives
Formed in Fall, 2005, we serve Visual FoxPro developers in the greater Philadelphia area, including the Lehigh Valley and Central and South Jersey. Starting with the April, 2006 meeting, there is a $5 charge per meeting.
Starting in August, 2008, we meet the second Tuesday of each month, with occasional adjustments for holidays.
Feel free to bring dinner and arrive as early as 6:30 PM.
Speaker
Directions
Created by
Tamar Granor, Tomorrow's Solutions, Llc
Tamar E. Granor, Ph.D., is the owner of Tomorrow's Solutions, LLC. Tamar is a consultant and application developer specializing in database applications. Since 1988, Tamar has been working primarily with Visual FoxPro and its predecessors, FoxPro and FoxBase+. She has worked with both large and small businesses as well as non-profit organizations. Tamar has written several books about Visual FoxPro and spoken at numerous conferences and user groups. She is a Microsoft Support Most Valuable Profe...
Contact
Tamar Granor, Tomorrow's Solutions, Llc
Tamar E. Granor, Ph.D., is the owner of Tomorrow's Solutions, LLC. Tamar is a consultant and application developer specializing in database applications. Since 1988, Tamar has been working primarily with Visual FoxPro and its predecessors, FoxPro and FoxBase+. She has worked with both large and small businesses as well as non-profit organizations. Tamar has written several books about Visual FoxPro and spoken at numerous conferences and user groups. She is a Microsoft Support Most Valuable Profe...
Archive of meetings
Tour of Smooth-On, a chemical manufacturing facility automated with VFP - Tuesday, March 14th, 2017 at 19h00
CANCELLED DUE TO WEATHER FORECAST
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 ...
Where do we go from here? plus Amazon EC2 - Tuesday, December 13th, 2016 at 19h00
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
tamar@tamargranor.com, 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 we...
SQL Server Reporting Productivity Tips - Tuesday, September 13th, 2016 at 19h00
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
- Aggregation...
Map it with Google! - Wednesday, August 3rd, 2016 at 19h00
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 meet in room 128. Bring dinner starting at 6:30; we'll eat in the far hallway.
A VFP programmer looks at .NET – again - Tuesday, June 14th, 2016 at 19h00
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.
Crosstabs and Pivots: Turning Data on its Side - Tuesday, May 10th, 2016 at 19h00
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.
Managing mission critical, high availability VFP applications in real time - Tuesday, April 12th, 2016 at 19h00
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.
Going OVER and above with SQL - Tuesday, March 8th, 2016 at 19h00
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 differen...
Map it with Google! - Tuesday, February 9th, 2016 at 19h00
The next meeting of the Philadelphia Visual FoxPro User Group will be next Tuesday, December 9 at 7 PM in room 125, Devry University, 1140 Virginia Drive, Fort Washington, PA. Feel free to come as early as 6:30 and bring some dinner.
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.
West Wind Web Connection 6.0 - Tuesday, January 12th, 2016 at 19h00
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 We...
An introduction to SQL Server Reporting Services (Part 2) - Tuesday, December 8th, 2015 at 19h00
The next meeting of the Philadelphia VFP User Group will be next Tuesday, December 8 at 7:00 PM in room 125, Devry University, 1140 Virginia Drive, Fort Washington, PA. Feel free to come as early as 6:30 and bring some dinner.
Abstract: 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" repo...
An introduction to SQL Server Reporting Services (Part 1) - Tuesday, November 10th, 2015 at 19h00
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 benefi...
Computer Sensors in Business Applications - Tuesday, October 13th, 2015 at 19h00
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 acceleromete...
An Introduction to SQL Server Reporting Services - Tuesday, September 8th, 2015 at 17h00
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 benefi...
Can't this application go any faster? - Tuesday, July 14th, 2015 at 19h00
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.
Manufacturing Automation powered by VFP, Part 1 - Tuesday, June 9th, 2015 at 18h00
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...
Inspiring Everyday Practical IntelliSense - Tuesday, May 12th, 2015 at 19h00
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 ...
Document Management within Visual FoxPro - Tuesday, April 14th, 2015 at 19h00
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.
SSRS 101: SQL Server Reporting System for beginners - Tuesday, March 10th, 2015 at 19h00
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...
Open Mike Night--VFP Tips and Tricks - Tuesday, February 10th, 2015 at 19h00
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.)
VFP Tips and Tricks - Tuesday, January 13th, 2015 at 19h00
For the next two months, we’ll cover Tips and Tricks. This month, Tamar E. Granor will present her Southwest Fox 2014 session “VFP Tips and Tricks.” On February 10, we’ll open the floor for all attendees to share their favorite tips, tricks and traps.
Here’s the abstract for Tamar’s talk:
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, an...
Jazz your Web Applications with JQuery! - Tuesday, December 9th, 2014 at 19h00
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 ...
Loosely coupled VFP data, plus Working with VFP and SQL together and providing easier migration pat - Tuesday, November 11th, 2014 at 19h00
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 networ...
I Need a Rest! and Should I be Concerned? - Tuesday, October 14th, 2014 at 19h00
We continue our Southwest Fox previews this month. Toni Feltman will (remotely) present both of her Southwest Fox 2014 sessions.
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 wi...
Go Beyond VFP's SQL with SQL Server - Tuesday, September 9th, 2014 at 19h00
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 or...
PowerShell: Batch File on Steroids - Tuesday, August 12th, 2014 at 19h00
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.
A Double Dose of XML - Tuesday, June 10th, 2014 at 19h00
This month, we’ll have a double dose of XML.
First, 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 applica...
T-SQL for Application Developers: attendees choose. - Tuesday, May 13th, 2014 at 17h00
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 s...
Office 365: An IT Department for small businesses - Tuesday, March 11th, 2014 at 19h00
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...
Web Services in PHP -- How to share data between your web and VFP applications - Tuesday, February 11th, 2014 at 19h00
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...”
VFPX Book and More - Tuesday, January 14th, 2014 at 19h00
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 avai...
Web Services: How to create them and use them to share data between your web applications and Visual - Tuesday, December 10th, 2013 at 19h00
Menachem Bazian returns.
Abstract: 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.
Foxpro and the Internet - The West Wind Connection - Tuesday, November 12th, 2013 at 19h00
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.
Excel Automation--New techniques - Tuesday, October 8th, 2013 at 19h00
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 att...
Make Thor Your Own - Tuesday, September 10th, 2013 at 19h00
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...
Migrating Applications to Lianja - Tuesday, August 13th, 2013 at 19h00
Hank Fay will present 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.
Dinner will be provided at this meeting (at 6:30 PM). Email
tamar@tamargranor.com if you’re coming for dinner, so we have enough.
Credit Cards and EFT/ACH in VFP - Tuesday, July 9th, 2013 at 19h00
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 cre...
Robust Web Application Development with PHP, CodeIgniter and MySQL - Tuesday, June 11th, 2013 at 19h00
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.
http://vfpphilly.blogspot.com/Welcome to HTML5 - Tuesday, May 14th, 2013 at 19h00
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
tamar@tamargranor.com, so we buy enough food.
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 oth...
Introducing SalesForce - Tuesday, April 9th, 2013 at 19h00
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...
A VFP programmer's approach to handling data in .NET - Tuesday, March 12th, 2013 at 19h00
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 t...
Try Thor's Terrific Tools - Tuesday, February 12th, 2013 at 19h00
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.
PHP in the Real World - Tuesday, January 8th, 2013 at 07h00
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!
We’ll be providing dinner (at 6:30); please send a message to
tamar@tamargranor.com if you plan to join us, so...
Synchronizing offline SqlServer/MySql data with live Fox data - Tuesday, December 11th, 2012 at 20h00
This month, Bob Pierce will speak on synchronizing offline SqlServer/MySql data with live Fox data: 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 wil...
Using VFP as Your Content Management System for an Information-Rich Website - Tuesday, November 13th, 2012 at 19h00
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
http://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. Wh...
VFP: Ideal for Tools - Tuesday, October 9th, 2012 at 19h00
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.
http://vfpphilly.blogspot.com/SQL Server 2012 - Tuesday, September 11th, 2012 at 19h00
In this Southwest Fox 2012 preview, you can learn what's new in SQL Server 2012 and what features it brings to your Visual FoxPro applications.
If time permits, we'll also revisit some of the Php material from last month's session.
Feel free to come from 6:30 on and bring some dinner.
PHP for VFP developers - Tuesday, August 14th, 2012 at 18h30
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 Lin...
Try Thor's Terrific Tools - Wednesday, June 6th, 2012 at 20h00
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.
Using the Web Browser to create controls, plus Open Mike Night - Tuesday, May 8th, 2012 at 17h00
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.”
Using West Wind Web Connect to put a legacy system online - Tuesday, April 10th, 2012 at 19h00
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’...
March Tripleheader - Tuesday, March 13th, 2012 at 19h00
This month, we’ll have a 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 Gra...
Class Design Strategies - Tuesday, February 14th, 2012 at 19h00
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" mo...
Bob Pierce on displaying status info - Tuesday, January 10th, 2012 at 19h00
Bob Pierce 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.
Bind events for better applications - Tuesday, December 13th, 2011 at 19h00
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...
Conference Review, plus Tools We Love - Tuesday, November 8th, 2011 at 19h00
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.
Southwest Fox Preview: Boosting Your Client Server Application Using Stored Procedures - Tuesday, October 11th, 2011 at 18h30
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 y...
Working with Remote Data the 'VFP Way': Upsizing to SQL Server Without Redesigning Your Application - Tuesday, September 13th, 2011 at 19h00
We're providing dinner before this meeting (6:30 PM). If you plan to come for dinner, please email tamar@tamargranor.com.
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-...
Tools and more tools - Tuesday, August 9th, 2011 at 19h00
Our topic this month is "Tools and more tools" and we're all the speakers. 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.)
Joins and Subqueries: Using SQL Commands for the Hard Stuff - Tuesday, July 12th, 2011 at 19h00
This month, the Philadelphia VFP User Group moves to our new meeting location in Room 158 of DeVry University, 1140 Virginia Drive, Fort Washington, PA. The folks at DeVry are letting us use the room for free; the only cost is that, at this first meeting, we'll hear briefly from a DeVry representative.
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 ...
To boldly go where no VFP'er has gone before -- the Tools of Thor - Tuesday, June 7th, 2011 at 18h30
This month, we will be joining with the Chicago FoxPro Users and Developers Group for a remote presentation by Jim Nelson titled "To boldly go where no VFP'er has gone before -- the Tools of Thor." Note the 6:30 PM start time.
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...
May Double-header: COM Servers and Sortable Grids - Tuesday, May 10th, 2011 at 20h00
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'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 fo...
April Double-header: Web applications and COM servers - Tuesday, April 12th, 2011 at 19h00
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”.
Garth's presentation centers on an invoice payment application developed in two distinct VFP-based web servers, VFP2IIS and FoxInCloud. FoxInCloud utilizes West Wind Web Connect, Active Widgets and FoxInCloud's own unique Application Adapter Assistant.
Jim's talk is entitled “An example of developing a COM server in VFP”. COM servers re...
Open Mike Night - Tuesday, March 8th, 2011 at 19h00
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.)
As always, we're looking for speakers for future meetings. If you have something to share, please let Bob Pierce (
rpierce@smooth-on.com) know. It can take the whole meeting or be a shorter presen...
Sidebars--add customizable convenience for your users. - Tuesday, February 8th, 2011 at 19h00
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.
In addition, Tamar Granor will give a presentation on preparing and giving presentations.
In case of bad weather, we will po...
Two-parter: Sidebars and Giving Presentations - Tuesday, January 11th, 2011 at 19h00
"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.
Tamar Granor will give a presentation on preparing and giving prese...
Office Automation Tips, Tricks and Traps - Tuesday, November 9th, 2010 at 19h00
Once you get started automating Microsoft Office, you're likely to find more and more uses for Automation. But you also start running into peculiarities of the individual servers, file format issues, and other complications. In this session, we'll look at a number of issues related to automating the Office servers, including exploring why recording a macro can lead you astray. Most of the topics will apply to multiple Office servers, but we'll also look at the so-called Outlook "hell patch" and ...
How the Fox is Different - Monday, October 11th, 2010 at 19h00
You always knew that FoxPro is different from every other programming language! You had a pretty clear idea that the development environment of Visual FoxPro is far superior to the one found in .NET, Java, and PHP. How else is it possible that those languages exists for years or even more than a decade and still lack features that FoxPro sported for eons? Even the simplest task in any of these languages requires an incredible amount of time. It's certainly not surprising that every single .NET p...
Collections--Managing Data the Object-Oriented Way - Tuesday, July 13th, 2010 at 19h00
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 coll...
Introduction to GDIPlusX - Tuesday, May 11th, 2010 at 19h00
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 will present via remote teleconference.
Feel fre...
Cancelled Due to Snow - Tuesday, February 9th, 2010 at 19h00
With another storm on the horizon, the February meeting is cancelled.
This month, we'll have an open mike night. To kick things off, we ask everyone who's coming to "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...
Getting Your Head Around Business Objects - Tuesday, January 12th, 2010 at 19h00
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.
Member presentations - Tuesday, December 8th, 2009 at 19h00
This month will feature a collection of short member 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 (
rpierce@smooth-on.com) know.
Open Source Tools - Thursday, November 12th, 2009 at 19h00
Note special night--THURSDAY, November 12
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 TortoiseSVN)
MantisBT
SugarC...
Introduction to Subversion and Tortoise SVN - Tuesday, September 8th, 2009 at 18h30
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 ...
Top Ten (or more) Reasons to Use the Toolbox - Tuesday, August 11th, 2009 at 19h00
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 w...
SQL in Many Forms - Tuesday, July 14th, 2009 at 19h00
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.
The group is providing a kosher deli dinner (beginning at 6:30 PM). Please email
tamar@thegranors.com if you want to be inclu...
Nothing but 'Net - Tuesday, June 9th, 2009 at 19h00
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 subscri...
Member presentations - Tuesday, March 10th, 2009 at 19h00
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.
Introduction to VFPX - Tuesday, December 9th, 2008 at 19h00
This month, we'll begin an exploration of VFPX. Bob Pierce 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 acr...
The Conference Experience - Tuesday, November 11th, 2008 at 19h00
The next meeting of the Philadelphia VFP User Group will take place next Tuesday, November 11. Bob Pierce will lead 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/C...
We Used to Do it That Way, But ... - Tuesday, September 9th, 2008 at 19h00
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.
Setting up a LAMP server - Tuesday, August 12th, 2008 at 19h00
Menachem Bazian returns to the Philadelphia VFP User Group next week to continue his discussion about combining VFP with MySQL.
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.
Cathy Pountney on "Customizing Your Vertical Market Apps" - Wednesday, July 16th, 2008 at 19h00
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 ...
Marcia Akins on "Practical Uses for the Windows API" - Wednesday, June 18th, 2008 at 19h00
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, ...
Scoresheet, a VFP 9 report generator plus code review - Wednesday, April 16th, 2008 at 19h00
The Philadelphia VFP User Group will meet Wednesday, April 16, 2008 at 7 PM at Valley Forge Pension Management, 715 Twining Road, Suite 202, Dresher, PA 19025. (The Oreland offramp from PA 309 Southbound has been permanently closed. The easiest way to reach the meeting location from the PA Turnpike or 309 Southbound is to come through the Fort Washington Industrial Park.)
As always, you can bring dinner and arrive as early as 6:30 for some time to mingle.
We have a double-header this month...
Bob Pierce on the Guineu Project - Wednesday, March 19th, 2008 at 19h00
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 ...
Menachem Bazian on VFP and MySQL - Wednesday, February 20th, 2008 at 19h00
The group will provide dinner this month, so if you plan to come in time to eat, email
tamar@thegranors.com. Dinner begins at 6:30.
Location: Valley Forge Pension Management, 715 Twining Road, Suite 202, Dresher, PA 19025
Note: The Oreland offramp from PA 309 Southbound has been permanently closed. The easiest way to reach the meeting location from the PA Turnpike or 309 Southbound is to come through the Fort Washington Industrial Park.
Visual FoxPro is the premier tool for developing r...
The Guineu Project - Wednesday, January 16th, 2008 at 19h00
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 O...
Guineu Project - Wednesday, November 28th, 2007 at 19h00
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...
Southwest Fox Review plus Keeping Users Informed - Wednesday, October 24th, 2007 at 19h00
We'll have a review of Southwest Fox 2007. Plus Bill Fitzgerald will talk about 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.
The Why and How of Test Data - Wednesday, September 19th, 2007 at 19h00
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.
Medical Computer Consulting - Wednesday, August 15th, 2007 at 19h00
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.
T-SQL 2005 - Wednesday, June 20th, 2007 at 19h00
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...
TIW Report Object - Architecture and Versatility/VFP IN THE WAREHOUSE - Wednesday, May 16th, 2007 at 19h00
TIW Report Object - Architecture and Versatility
TIW Technology is the author of three FoxPro based application (ALERE, ShopLink, and WorkShop). 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-...
Best Practices for User Interfaces - Wednesday, April 18th, 2007 at 19h00
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 desi...
The future of VFP/Print your forms - Wednesday, March 21st, 2007 at 19h00
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.
Social Security Number validation with Visual FoxPro - Wednesday, February 21st, 2007 at 19h00
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 e...
Customizing the Property Sheet - Wednesday, January 10th, 2007 at 19h00
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.
Open Mike Night Plus - Wednesday, November 15th, 2006 at 19h00
This month, we feature the return of Open Mike Night. Bring a tip, a question, a demo, anything you want to share. In addition, we'll have a review of the Southwest Fox conference and a code review.
Door prizes include a copy of DBi's Studio Controls R3, which includes pretty much all of DBi's controls.
Making the Most of the VFP Toolbox - Wednesday, October 11th, 2006 at 19h00
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.
We're trying something different for dinner this month. Feel free to bring your own and arrive as early as 6:30. If you need somewhere to pick something up, there's a sub shop, a Chinese place, and a...
Data Driven Interfaces - Wednesday, September 13th, 2006 at 19h00
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 ...
Introduction to .NET (from a VFP perspective) - Wednesday, August 9th, 2006 at 19h00
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 Note: Special date for this meeting
Mike Feltman - Wednesday, July 12th, 2006 at 19h00
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.
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 a...
A Third Party Application Model - Wednesday, June 14th, 2006 at 19h00
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.
Data Driven Interfaces--Robert Pierce - Wednesday, May 10th, 2006 at 19h00
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 t...
Introduction to .NET (from a VFP perspective)--Kevin S. Goff - Wednesday, April 5th, 2006 at 19h00
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
Note: Special date for this meeting
If interested,...
N-tier design - Wednesday, March 8th, 2006 at 19h00
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.
This month's giveaways include a premier membership in the U...
Our very first open mike night! - Wednesday, February 8th, 2006 at 19h00
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.
Solving Common Problems with VFP's SQL - Wednesday, January 11th, 2006 at 19h00
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.
This meeting will be held at the offices of MicroEndeavors, Inc., 8001 Lansdowne Avenue, Upper Darby, PA 19082. Directions at
http://www.microendeavors.com/directions.htm.
SQL Server and VFP Tips and Tricks on Importing/Exporting SQL and Visual FoxPro data - Wednesday, December 14th, 2005 at 19h00
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.
Case Study - Smooth-On Inc. Easton, PA - Wednesday, November 9th, 2005 at 19h00
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.
Organizational Meeting/Using the Debugger Effectively (Tamar E. Granor) - Wednesday, September 14th, 2005 at 19h00
First meeting for a newly-forming user group for Visual FoxPro developers in the greater Philadelphia area. For the time being, meetings will be held at the Microsoft offices in Malvern.
The meeting will include a discussion about plans for the group.
Speaker: Tamar E. Granor (TamarGranor)
Topic: Using the VFP Debugger Effectively
More information including driving directions at:
http://msevents.microsoft.com/CUI/EventDetail.aspx?culture=en-US&EventID=1032280764&EventCategory=1
Conta...
Pictures
 Scoping out a new location for our meetings
March 2006 | |  Philly FUG meeting at a new location
February 2006 | |  Tamar demonstrates some interesting SQL joins she uses to solve tough problems
January 2006 |
| |
 John McLaughlin demonstrates importing/exporting of VFP data for use with SQL Server
December 2005 | |  John McLaughlin fielding user questions.
December 2005 | |  Tamar explains the UT Subscription giveaway
December 2005 |
