2014 ScheduleSchedule

We're always looking for speakers to present topics at our meetings. If you'd like to present a topic, please send us an email describing the topic you'd like to present and whether you have a specific date in mind. We appreciate all presenters -- professional and amateur. Who knows, this could be the beginning of a new career path for you!

Like to submit a topic? Click...Submit Topic

Comments or suggestions are welcome.

--- Past 2014 Meetings Thanks to
01/11/14  P O S T P O N E D  ~ Due to weather  

Annual Elections

  • Currently held positions (2013):
    • President: Jody Meyer
    • Secretary: Mike Lyzun
    • Treasurer: Mike Potjer
    • Webmaster: Jody Meyer

Unit Testing 201: Testing Our SQL Server Backends by Eric J. Selje

  • Nobody wants to find out the "one little change" they made to their database resulted in a data breach or massive billing error, so how can we proactively minimize that risk?

    Applying the concept of Unit Tests to your database allows you to quickly ascertain whether the the changes you make to functions, stored procedures, and even other objects in your database have a negative unforeseen impact. In this session, we'll walk through the basics of what unit testing is, how to set up a simple Unit Testing project in SSMS, how we can tell whether something has negatively changed in our functions or procedures. We'll also enumerate any third party tools available to help us with Unit Testing our databases.

  • You will learn:
  • What Unit Testing is (in a quick review)
  • How to use the tSQLt framework in SSMS to create Unit Test classes for your databases
  • What to test to minimize your risk
  • How to use FoxUnit to do something similar in Visual Foxpro (time permitting)
  • Prerequisites: Desire to learn about how to improve your code


Eric J. Selje


Bring Your Own ...

Questions, ponderings, struggles, triumphs, webpage sites, cool tool, book ... anything you would like to share.


Bring Your Own Topic: SQL Server ...

Questions, ponderings, struggles, triumphs, webpage sites, cool tool, book ... anything SQL Servery you would like to share.


My Experiences with SSIS by Rich Addison

I've worked on two projects in SSIS, one a big success, one a complete failure. I'll show you some of what I did in each, naturally focusing on what succeeded, and best practices I was being taught by an expert mentor. (I wish I could say I've approached his level of expertise!)

The successful one you might consider two projects, the first stage was reporting on duplication, and other garbage data, to be cleansed during the migration. The second stage (or 2nd project) was the actual migration from a SQL "warehouse" (really a periodic pull of franchises' Access databases into one SQL database with almost the same table structures) into the new Enterprise SQL database.

The more recent attempt was to use SSIS to read from FoxPro DOS tables into a newly designed SQL replacement. I designed this beautifully efficient project, of which each component previewed just fine, but no matter what I tried I couldn't make it read the DOS data in debug mode or running as a package. After Googling the issue (SSIS error can't read 32-bit data with 64-bit SQL and SSIS) and trying every supposed solution, none of which worked, I gave up and wrote a VFP form to read the DOS files, and write to the SQL with SQL Pass-through.

Rich Addison

Everything you DIDN'T know about IntellisenseX by Jim Nelson

IntellisenseX is a direct descendant of ISX.PRG, written by Christof Wollenhaupt (with help from many others), who started on it fifteen years ago.

IntellisenseX provides drop-down lists for PEMS from objects and field names from tables for a wide range of objects, tables, and data objects not addressed by FoxPro's native Intellisense. The drop-down lists show additional information in extra column(s),and can be filtered using "match-anywhere" (just a $) to reduce the number of items in the list.

We'll start by showing how IntellisenseX is installed, show how it works duplicating native Intellisense for PEMs of objects in the code window and command window, and then into the murky area where it does so for those cases where native Intellisense might be expected to work, but does nothing. Then we will move onto new ground -- uses in WITH/ENDWITH blocks, references to variables not yet defined with LOCAL ... AS ..., uses in PRG-based classes, and objects from an object factory.

Our attention will then turn to how it handles fields from tables (something ignored by native Intellisense outside of the command window). We will show how tables can be referenced in code windows, including tables that are not yet open; how tables can be accessed by their aliases when referenced in code (USE .... ALIAS ...,); how to see the fields for aliases used in SELECT statements; and how to see fields from a SQL Server database for use in SELECT statements.

Finally, we will delve into the use of the Alias Dictionary, which allows you to create application-wide aliases for both objects and tables. This simple table provides some remarkable and unexpected capabilities.

IntellisenseX is highly customizable and descriptions of the various options and plug-ins used by IntellisenseX will be interwoven into the session.

IntellisenseX is delivered by and integrated with Thor. While installation of Thor will not be addressed during the session, there will be help available outside the session for anybody who needs help installing or using it.

Jim Nelson
07/12/14  S U M M E R     B R E A K  
08/09/14  S U M M E R     B R E A K  

 SWFox 2014 Practice Session: Inspiring Everyday Practical IntelliSense by Rick Schummer

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, IntellisenseX, ISX, and FoxCodePlus.

You will learn:

  • About IntelliSense scripts you can use everyday
  • How to build time-saving Command/Keyword expansion and syntax completion techniques
  • How to make coding easier using Quick Info, Member Lists, and Types
  • How to leverage and manage Most Recently Used (MRU) lists
  • How to avoid the duplicate typing that comes naturally with SET commands
  • How to reap the benefits of the C operators
  • How Property Editors play in the IntelliSense sandbox
  • Ideas to improve the IntelliSense Manager
  • About Runtime IntelliSense, and how to take advantage of it in your custom apps

Prerequisites: Desire to be more productive in the VFP IDE, and basic understanding of IntelliSense inside VFP.

Rick Schummer

 SWFox 2014 Practice Session: VFPX.Edition("2014") by Rick Schummer

VFPX, one of many active open source projects hosted on CodePlex, has some terrific tools to enhance the Visual FoxPro Interactive Development Environment (IDE) and components to impress your customers in the applications you write for them. This session covers some of the recent updates and additions to VFPX in 2014

We are going to cover as many of these tools as time allows. We'll:

  • Explore the Data Explorer enhancements
  • Determine how FoxBin2PRG fits in the binary source code flattening space
  • Generate Excel files without Microsoft Office or OpenOffice using ExcelXML
  • Get a quick overview of changes to the mighty Thor!
  • See the value of Finder and how it has become a legitimate project manager replacement
  • Peek at the FoxCharts enhancements that make charting in your applications easy
  • ...and more as the year progresses

The session will vary between deeper dives and overviews depending on conference attendee needs and the work by the VFPX project managers as the year progresses.

Note, this list is subject to changes based on the releases by VFPX project managers and what other presenters want to talk about at the conference.

You will learn:

  • What is new in VFPX in 2014
  • How VFPX is going to make a developer's life easier
  • Where to get all the new goodness
  • Why it is more important than ever to get involved in VFPX

Prerequisites: None

Rick Schummer

2014 SWFox in Review

12/13/14 W I N T E R     B R E A K - Happy Holidays  

Return to Schedule

Valid XHTML 1.0 Transitional