Home » Uncategorized » VFP 9 SP2 Hotfix Released!

VFP 9 SP2 Hotfix Released!

10, 9, 8, 7, 6 (main engine start), 5, 4, 3, 2, 1…. Liftoff!

I bet you think I am talking about a launch of NASA’s Space Shuttle. If you know me this is a good guess, but this time you are wrong. I have better news!

Microsoft has released a hotfix to the most serious Report Designer bug in VFP 9 SP2. This is the Data Group bug Cathy Pountney first blogged about here: Gotcha: Serious report bug with Data Groups introduced in VFP 9 SP2.

You can read about the fix in the Microsoft KnowledgeBase article #968409, titled “FIX: The group header of a data grouping is not printed at the top of each page as expected after you install Microsoft Visual FoxPro 9.0 Service Pack 2

This fix is considered by many to be the most serious bug introduced in VFP 9 SP2, and has often been referred to as the main stumbling block to the adoption of VFP 9 SP2. I am hopeful with this news that you will consider downloading the new hotfix and giving it a try to see if it works well for your apps. Only you can make the determination on what is best for your customers. Yes, there are more bugs to squash, but a high percentage of them have decent workarounds where this particular bug did not.

Additionally, there is some terrific news on how you can get the hotfix. Previous to this release Microsoft only made Visual FoxPro hotfixes available by calling Microsoft Product Support Services (PSS), report the bug in the hotfix, and then Microsoft would make it available to you. Hotfixes are easier for the team to release because there is less overhead, but getting it to the Fox Community is a pain in the neck because of the PSS bottleneck. So the “Fox Team” came up with releasing this important hotfix through MSDN Code Gallery so any Visual FoxPro developer can download and apply the patch without calling PSS. I think this is a real positive move for the Fox Community.

The hotfix can be downloaded on the download page of Code Gallery for the KB article.

Both the other hotfixes released for VFP 9 SP2 are rolled up into this release so if you have patched SP2 for the following fixes they are included in the new build:

  1. FIX: The toolbar on an SDI form is disabled in Visual FoxPro 9.0 Service Pack 2 (build 6303, 12-Apr-2008, KB 948528)
  2. FIX: Records from another user session that violate the criteria for a parent table are displayed in the browse window for a child table in a Visual FoxPro 9.0 Service Pack 2 multiuser environment (build 6602, 03-Jun-2008, KB 952548)

Update: Milind Lele tells me the previous hotfixes for VFP 9 SP2 are also available on MSDN Code Gallery (just in case you are not interested in the Group Header fix. {g})


Just in case you have not heard, in addition to the core EXE and runtime hotfixes we have a new VFP 9 SP2 Help file available on VFPX.

I am very excited about this news. I want to thank the “Fox Team” for their hard work and personal efforts to make the hotfix happen. I also want to thank those in the Fox Community who have reported VFP 9 SP2 bugs, those who have documented the workarounds, those who researched when some of the alleged SP2 bugs really surfaced, and those who tested out the hotfix to ensure it is the best possible fix for the reports at this time.

Hopefully this is just the third in a string of hotfixes we will see from Microsoft as they support the product we all love. Today is a very good day. This is one small step for VFP, one giant leap for VFP developers. Please spread the word!

Update: Read more about this release on Cathy Pountney’s blog!


7 Responses to “VFP 9 SP2 Hotfix Released!”

  1. April 2nd, 2009 at 17:22 | #1

    Good news, but it doesn’t make-up for the unpardonable way SP 2 was railroaded through without a public testing-round by MS’ absolute (and so-acknowledged) second-to-none testing community — the VFP community.

    THAT was just insulting…

    So while *some* flower-throwing is probably appropriate, let’s not go overboard, and let’s lose track of how and why we got to this point.

    There, I said it :) Cheers!

    **–** Steve

  2. April 2nd, 2009 at 17:34 | #2

    That’s ok Steven, I understand your frustration, but I like to take the road of forgiveness today. Especially knowing what it took risk wise for the team to get this to the community and all those who took part in bringing it to market.

    So don’t mind me as I uncork some bubbly and celebrate a BIG win for the community this time around.

  3. April 3rd, 2009 at 07:24 | #3

    Hi Rick,

    The latest hotfix is not cumulative. It’s missing VFP9t.dll from previous hotfixes.

    Also zip file for http://code.msdn.microsoft.com/KB952548 is password protected.

  4. Anonymous
    April 3rd, 2009 at 09:24 | #4

    Hi Rick!
    If this HotFix is cumulative why it doesn’t contains vfp9t.dll changed in KB952548?


    Emerson Santon Reed

  5. April 3rd, 2009 at 09:47 | #5

    Sergey and Emerson,

    Both good points. I have an email into the responsible people at Microsoft. The tested release did not have the password and I am not sure what happened to the missing runtime.

    Thanks for pointing this out.


  6. Ed
    June 16th, 2009 at 16:57 | #6

    Did they resolve the issue with providing a hotfix that installed all of the vfp patches to date?

  7. June 16th, 2009 at 17:32 | #7

    Hi Ed,

    Yes, the latest VFP 9 SP2 hotfix downloads do have all the VFP 9 SP2 changes included. This was fixed back in April.


Add reply