Skip to main content

FoxPro is outdated - compared to what? (an example of what FoxPro developers are up against)

I recently heard of an interesting story - you can read about it here - related to how the FBI recently canceled a project for a management system. No big whoop there except that the vendor in question was selling a FoxPro application. The full PDF report (from the Auditor General) is available here .

Just so you don't need to read it - here are the parts that were interesting:

The customization was a slow process because the JusticeTrax LIMS relies on an aging code format, Visual FoxPro.While Visual FoxPro is outdated, it is still compatible with today’s technology. However, according to FBI personnel, Visual FoxPro is difficult and slow to customize compared to newer programming languages. While the extent of customization was the main obstacle, having to use the old code increased the delays.

Note: JusticeTrax's LIMS application uses VFP 9 and a SQL Server back-end. It is also used by a variety of law enforcement agencies and forensic labs across North America.

What was the FBI currently using?
The FBI currently uses Microsoft’s Access 2002 as the ECS database software.

More:
The IMPRB expressed additional concerns about project risks, including the fact that the Visual FoxPro code used for JusticeTrax’s LIMS is old technology

Now there are a number of other reasons for the cancellation of contract (they wanted a web-based app - LIMS is a desktop app, poor project management, no champion, etc) but so many times, we hear that Microsoft wants examples of why we feel FoxPro has been badly treated and how they can help and here is a classic one. (I'm sure many VFP shops have similar stories)

Now, the report does not note who the FBI personnel were who said that "VFP is difficult" - but look at the words being used : "old", "difficult","slow to customize","aging code format". Let's deal with these separately:

Old. OK. Java is "newer" compared to VFP but C++ isn't. Uh - and unless I'm mistaken, there are still some mainframes in use in the US government.

Difficult. What programming language isn't slightly "difficult"? (is VFP any more difficult than, say , VB?).

Slow to Customize? That's more an attribute of the application itself. I'm sure that Windows is slow to customize as evidenced by the fact that you have to regression test it for millions of users, compared to a Linux or other O/S. One FoxPro application may be incredibly easy to customize whereas another is incredibly difficult - that doesn't mean FoxPro is slow to customize.

Aging code format - I wonder how many lines of code in VFP are STILL the same as they were back in 1990. Calvin? Any ideas?

Now I'm not intentionally trying to spin this (see the various discussions on WinFS, for examples of Spin) but I am holding this up as an example of the challenges that FoxPro developers face regularly. None of the comments are true of the language or tool itself - yet inexperienced IT program managers or knowledge workers might read this and think otherwise. Is this Microsoft's or the Fox Team's fault?

No - but clearly this is where better responses are needed. Maybe, someone should flash up the TIOBE index. Sending over case studies would be one option but once again, IT's PRODUCT SPECIFIC - so it doesn't answer the question.

Maybe we should show the life cycle for extended product support.
VFP 9 - 13/01/2015
Access 2000 - 14/07/2009
Access 2003 - 14/01/2014
Visual Interdev (how many web apps were deployed) -30/09/2004
Visual Studio 2003 - 08/10/2013

How do you combat this type of ignorance? Can you?

I don't have the answers here - do you? How would you respond?

Comments

Michael Hogan said…
Andrew - this is a serious problem for our community. I've been toying with the idea of creating a 'foxpro successes' web site for posting success stories that don't otherwise get acknowledged. I'm willing to develop the site but I don't have the desire to hunt for the stories or write the articles on a continuing basis. If you know of a few people who would be interested in doing that work, I'm ready to start the site now!
Anonymous said…
Michael,
This is a great idea!
I would like to share my success (VFP) stories in a site like this.

See also here
http://weblogs.foxite.com/vassilisaggelakos/archive/2006/05/18/1551.aspx

and here
http://weblogs.foxite.com/vassilisaggelakos/archive/2006/05/22/1565.aspx
Bill said…
This was a great post, and, in my opinion, exactly the kind of 'misinformation' we, as a community, are up against.

The current gig I'm on, when I arrived, the entire shop was under the impression that FoxPro was no longer being sold by Microsoft!!

They have several VFP 6.0 apps that they finally gave the go ahead to upgrade to vfp 9.0, once I showed them that there was, in fact, a new release by MS...

I'm currently revamping one of my sites and intend to add in some RSS feed lnks for exactly this kind of story.

Found your blog, because someone searched mine and I was checking the results of the search.

Popular posts from this blog

Merry Christmas

Whether you celebrate now, have already celebrated your past holiday, are planning to, or not, I hope you find yourself surrounded by family and those you love during this holiday season and are able to remember fondly those who are not with you. We often find ourselves buried in work, or too distracted by other problems, to share and remember a few moments with those closest to us. So many of us are separated by huge distances, we often find it easier to focus on those who are out of arm's reach yet so easy to connect with online, instead of those who are right beside us. So do yourself a favour, put down the keyboard (stylus, mouse, etc) and spend that time. I know I will. Merry Christmas. Powered by ScribeFire .

From Writing to AI: the pattern repeats itself

When I was ten years old, my dad bought a computer and, thanks to an advertising supplement in a Superman comic I read, it was a TRS-80. A month later, he dragged the entire family (my mom and brother were not the most enthusiastic) to a class at Radio Shack teaching how to use microcomputers. At the time, I understood why my mom wasn’t that excited: the computer was yet another gadget in the house. But today I find it fascinating. My mother went to Vassar in the 50s. She learned how to type — not a common skill at the time — but it opened doors. Her ability to communicate effectively led her to a career in adult education and later communications work with the CBC (Canadian Broadcasting Corporation). This isn’t a nostalgia post. Today, the ability to use artificial intelligence, be it through Copilot or simply writing the right prompt, is becoming a critical skill. But is it really that novel? In the 1500s and 1600s, the printing press gradually made reading accessible beyond cler...

Programmers vs. Developers vs. Architects

I received an email this morning from Brandon Savage 's newsletter. Brandon's a PHP guru (works at Mozilla) but his newsletter and books have some great overall perspectives for developers of all languages. However, this last one (What's the difference between developers and architects?) kind of rubs me the wrong way. Either that, or I've just missed the natural inflation of job descriptions. (maybe, it's like the change in terminology between Garbage man and Waste Engineer or Secretary and Office Administrator) So maybe it's just me - but I think there's still a big difference between Programmer, Developer and then of course, architect. The key thing here is that every role has a different perspective and every one of those perspectives has value. The original MSF create roles like Product Manager, Program Manager, Developer, Tester, etc - so every concept may pigeon hole people into different roles. But the statements Brandon makes are often distinction...