Shedding Some Light

This week I will be in Seattle to attend the MVP Summit. It is one of my favorite weeks because I normally just show up and soak in the new technology Microsoft has to show us under the standard Non-Disclosure Agreement. I don’t have to prepare for the MVP Summit like I do for the conferences where I present.

It is always a fun time seeing MVP friends again, meeting with the folks formerly known as the Fox Team, and geeking out with Visual FoxPro. I come home exhausted and energized at the same time. I am looking forward to returning to the Seattle area again, staying downtown, and soaking in the city atmosphere and mountains off in the distance.

Yesterday I presented a smattering of topics to the Grand Rapids Area Fox User Group. It does not matter if I am presenting to customers, at a conference, or in front of a user group, I like to prepare. But this week was nuts and I had only a couple of hours Friday night to put together all the new material I wanted to present. It is definitely not my style to slap together something at the last minute, but it was unavoidable.

I discussed three things:

1. Installing VFP 9 SP2 and the importance of doing it.
2. Showed how I am using VFPX components in my applications
3. The Advantage Database Server

The key thing I want to discuss in this blog post is how easy Emerson Santon Reed made the second part of the presentation go with his new Themed Controls. I wanted to show something new and the Themed Controls were only released last week. If you are not familiar with the Themed Controls, take a look on VFPX. The Themed Controls absolutely rock! The project currently includes the OutlookNavBar (formerly known as Outlook2003NavBar), the ZoomNavBar, and the ToolBox.

When Emerson first released the Outlook2003NavBar I wanted to use it as a toolbar along the left side of my applications, but unfortunately it was only designed to work on forms. I made the enhancement request to have it work on toolbars and I am pleased to say the newest version does. It works great and was very easy to implement. I literally downloaded the file, reviewed the samples, and implemented it into the Southwest Fox Event Management app I have written. All this in less than two hours. Wow!

Mike Potjer brought up the new FoxCharts during the discussion so I showed what Cesar has put together by demonstrating the sample included in the project.

It is important to note that both the Themed Controls and FoxChart both leverage GDIPlusX. This demonstrates the synergy we already see from the VFPX projects. Very, very exciting things are happening in the Fox Community these days and I was glad to have the opportunity to share this with the folks in Grand Rapids who are always gracious hosts. Even when I am unable to prepare properly.

Last Thursday Mike Feltman of F1 Technologies presented his new session on Collections to the Detroit Area Fox User Group. Mike is putting this session together for the 2008 conference season and wanted to rehearse it to get some feedback before presenting it at conferences this year.

This session was excellent! Mike talked about collections, some advantages and disadvantages, how they work, how they compare to arrays, and then went in and demonstrated some code. Mike has put together a really cool set of utilities using collections based on his work with JavaScript over the last year. These utilities show the power of collections and are worth the price of admission to his session alone.

I rarely use the Collection class in Visual FoxPro, primarily because they are more difficult to debug than arrays. I use arrays for the same thing I can use a Collection. After seeing Mike’s session I likely will use the Collection class more. Another thing Mike showed is how you can return an array property from a method in class code. This is something I either knew and forgot, or learned last Thursday.

Great session Mike! I know Mike is showing this session in Grand Rapids on May 10th, and anticipate this session will be selected by conference organizers too.

I received a bug report this week for ViewEditor Professional that took a little time to track down. I don’t have time to immediately fix it so I want to pass this along to the developers with two simple workarounds to use until I can figure out the best solution.

The bug is only revealed under a specific circumstance and has likely been a bug since ViewEditor Professional was originally written back in 2002. The bug shows itself when you save the view you are working on. The save process verifies the view’s SQL code is valid and reports any problems with the SQL code. During this process all view parameters are substituted using the VFP STRTRAN() function. Depending the substitution sequence of the view parameters and the names of the view parameters, an incorrect substitution occurs. The problem only happens when you have two view parameters starting with the same characters.

?vp_lActive = .F.?vp_lActiveArchive = .T.

SELECT cCustomerID, cCustomerName ; FROM Customer ; WHERE ?vp_lActive = .T. ;    AND ?vp_lActiveArchive = .T.

If vp_lActive is STRTRAN’ed first you see the validation code after the substitution to be:

SELECT cCustomerID, cCustomerName ; FROM Customer ; WHERE .F. = .T. ;    AND .F.Archive = .T.

The two workarounds (use one or the other):

1. Do not name your view parameters starting with the same characters.
2. Shut off the validation process when saving views by unchecking the Validate SQL checkbox on the SQL page.

If your views give you an error when you are saving them you can click on the Show SQL Validation Code button to see what the ViewEditor uses as the validation code. This is how I revealed what happened with my customer’s view. She knows the view is valid and has decided to shut off the validation until I can the validation substitution of view parameters.

Contact Information:
Rick Schummer
White Light Computing, Inc.
42759 Flis Dr.
Sterling Heights, MI 48314

STERLING HEIGHTS, MICHIGAN, April 2, 2008 — It is a great pleasure to announce Frank Perez has accepted an offer to work at White Light Computing as a Software Developer. Frank has a proven track record of success in the software development industry and brings more than 13 years of experience supporting and developing custom and vertical market solutions. He is experienced in all phases of software development with strengths in Visual FoxPro reporting, Stonefield Query, and has a passion for developer tools. Frank also has extensive experience with hardware and networking support.

In his role at White Light Computing, Frank will be working directly with our growing list of clients to collect business requirements, write specifications, architect and design, develop, test, deploy, and support our software solutions. He also will help release a couple more developer tools nearing completion.

His first day at White Light Computing is May 1, 2008.

I returned to Michigan today from a 10-day break in the Orlando area. Yesterday I was in the 70s (F) with sunshine and a slight breeze in Florida. Today it is below freezing and we are getting 2-4 inches of snow this evening. Fabulous. At least our flight was not delayed like the many people flying on Delta today.

I accomplished a couple of firsts on my vacation. The first was attending a Detroit Tigers spring training game. My dad took me to the game for my birthday and it was a real treat, although it felt more like a typical opening day game in Detroit weather-wise (game time temps in the low 60s with wind-chills in the 50s without jackets {g}). The Tigers won it in the ninth inning 10-9. Great game as the Tigers fell behind 6-0, rallied to an 9-6 lead, Astros tied it in the top of the 9th, and Tigers pulled it out in the bottom of the inning. It has been a long time since my dad and I went to a Tigers game and the first game I attended with my nephew and brother-in-law.

The next thing I accomplished was attending the live landing of the space shuttle. I have seen the orbiter return once before to Kennedy Space Center, but on the back of a 747 as it flew back from California. I can’t say I actually saw Endeavour return because it was dark. We heard the twin sonic booms and heard the jets that escorted the orbiter to the landing. We also saw the lights from the escort jet as it descended to the well-lit landing strip on the horizon. Our view was fantastic and it would have been even more spectacular if Endeavour would have landed during the first pass at 7:05pm. Still, it was a great evening filled with fun and terrific meal with my parents as we wrapped up our spring break.

Back to work and catching up on a couple of projects, plus I have a huge announcement coming early next week. It will be good to get back to full-time work, and some positives vibes.

Today I was setting up with a developer to do some mentoring for the first time. He was looking for ideas on how I can connect to his computer so I offered several options including Co-Pilot from Fog Creek, GotoMeeting.com, VNC, Remote Desktop, and the old stand-by PcAnywhere. To do the last three we need some port forwarding set up and the developer had not previously set any of this up.

I have used PortForwarding.com for years to get the port information. It is a clear and easy to use site for the various ports used by different software. A terrific knowledgebase. Today I also found on the site a great resource I did not know existed before: step-by-step instructions on how to set up the port forwarding on different routers. I have always used LinkSys routers so even someone with my love of hardware can simply set it up. When my new client asked me how to do this on his 2Wire router I had no clue. I Googled the router and found a link to this site.

Very nice!

I returned to my office late this afternoon and in my email is the first issue of FoxRockX – all shiny and new! Open for business as the saying goes.

http://www.FoxRockX.com for all the details (make sure to include the “www” until they get this fixed).

Go get subscribed today before you forget and miss the inaugural issue. Consider it a gift to yourself, and an investment in your career. You should not be disappointed.