NEWSLETTERS
 

CIO.com updates, insights and advice on technology, management and your career.

 CIO BlackBerry News and Tips
 CIO Research and Analysis
 CIO Microsoft
 CIO Insider
 
 
 
SUBSCRIBE TO CIO
 
Are you involved in setting the direction for your company's IT budget or strategy?

Apply today for a FREE subscription to CIO Magazine!

 


Mon, Apr 2, 2007 14:00 EDT

The Future of FoxPro

Topic: Development

Blog: Weigh In

Current Rating: 5 Comments: 5

In mid-March, Microsoft announced the official end of the line for FoxPro. I'm not a FoxPro developer, but in my career, I've been in the exact same position that FoxPro developers now are in, with other products and other vendors. I vividly remember what it was like to be in that position and I understand many FoxPro devotees are understandably upset. But logically, not only did the end of life for FoxPro make sense, but everyone, including the FoxPro followers knew that this was coming, regardless of what Microsoft did or did not say.

When I mentioned this fact to some colleagues, the near-universal response was "What?! You mean FoxPro was still around?" Searching for more news recently, I found a popular article written in late 2004 which stated exactly the same sentiments, and that was two-and-a-half years ago! In addition, many FoxPro to .NET conversion consultancies have been around for several years. Quite bluntly, the FoxPro developers who were surprised by this announcement have had their heads in the sand.

Microsoft has not only been moving away from native development (C++ aside) and focusing on managed code, but centralizing all development tools around Visual Studio. Gone are the days of maintaining and supporting dozens of separate specialized development environments.

To bring FoxPro into this fold would require FoxPro to be brought to .NET properly and for it to become part of Visual Studio. Either step would have drastically changed FoxPro in ways that would make the VB to VB.NET change look small in comparison. The end result may have shared a name with FoxPro, but it certainly would not be a FoxPro the FoxPro developers would recognize, and it certainly would not run existing FoxPro applications without massive changes.

While FoxPro certainly has some unique features, most of them are now or soon available in .NET. Projects like LINQ continue to reduce the unique advantages of FoxPro, and taken in conjunction with the advantages of .NET, a move to .NET is the natural evolution.

Since Microsoft has updated FoxPro to interoperate with .NET using Sedna, FoxPro developers do not need to port their applications cold turkey, but can begin to mix their FoxPro code with .NET code and slowly move over existing systems. Microsoft has also announced extended support through 2015 and even a coming service pack for FoxPro. This gives

You do not have flash or javascript support.
Average (8 votes)
5
 
 
Sat, Sep 1, 2007 2:34 EDT
Anonymous user
Posted by: Hermann Strijewski
Rating: 90

This is how I see it: I have been developing web databases with Visual FoxPro for over 10 years, and when PHP or .NET programmers occasionally want to show me how much better their stuff is, they are always SHOCKED when they realize how much WORSE it is.

They typically need 3 to 10 times the code, sometimes over 20 times the code, to get business applications done. By the time they have instantiated their objects, I am finished with the business logic and application.

Furthermore, FoxPRO's built-in database is highly optimized and runs typically 5-10 times faster than SQLServer or MySQL in Web applications, no result sets need to be communicated, no SQL strings need to be parsed.

This is the ONLY problem I see: Although Visual FoxPRO is the most bugfree programming language around, it does not make Microsoft much money. It does NOT require SQL Server License fees, third-party components, additional language components, and typically much smaller developer teams.

FoxPRO was always the renegade product in the company, it's almost as if Microsoft was ALSO giving away MySQL to any potential SQLServer customer. "OBVIOUSLY that had to end".

BUT the XBASE community will not die because of the End-Of-Life notice, quite to the contrary. In the past FOXPRO was always the most powerful and best product in the XBASE community, and it was not profitable for anyone's XBASE to compete against Microsoft's product. With Microsoft leaving the competition, the XBASE competition will THRIVE, and companies like dBASE Inc, Recital, FlagShip, Harbor Project etc. will see a whole new reason for existence: hundreds of thousands of programmers coming.

The 25-year old dBASEII advertising "Boy Is This Costing You!" (referring to inefficient BASIC programming) is more true than ever before: XBASE code is perfect for web databases, because it deals directly with data instead of all these .NET and PHP memory variables, objects, procedure calls, etc. etc.

FoxPRO may see the End Of Life in another 10 years or so, but XBASE will continue to grow. I should probably do some actual code demonstrations that show how much better it works and plan to do so.

 
Tue, Apr 22, 2008 10:53 EDT
Anonymous user
Posted by: G.BADARIVISHAL
Rating: 90

Dear Sir,

I fully agree with your opinion.

xBase need have to die just because Microsoft has plans to drive the last nail to the coffin of FOXPRO.

Because, foxpro is one of the xBase languages and not the only xBase language.

I have been and is a Xbase programmer - dbase III plus - for the past 10 years. You may wonder what this almost 20 years old programming environment is doing in 2008.

Really we can write very useful, user friendly, economical and fast applications in xBase.

Leaving the big leagues, I mean to say, MNCs and would be MNCs we have a very large section of common populace which want a custom built application to cater to their needs. What they really want is trustworthy, costwise down to earth applications. The refuge is xBase which does not exploit the situation but gaurantees perfect solution.

If we, xBase programmers, really work to popularise xBase by taking it to grassroot level effectively xBase can definitely survive the onslaught from whatever non-xBase platform and can continue to make the lives of users as well as xBase programmers purposeful for a long to come.

G.BADARIVISHAL
MYSORE
SOUTH INDIA
22-04-2008

 
Sat, Oct 18, 2008 5:13 EDT
Anonymous user
Posted by: JC
Rating:

"I just found this article looking for answers"
What more can be said than your reply. I totally agree.
Microsoft IS NOT XBASE and the issues are not desktop application anyways. I have been in the same situation with PHP and so on and I always went back to VFP code and database because SQL, . NET ... doesn't create any added value to my work besides showing off at the cafe using great expression.
I don't think anyone talks about small/medium business needs for there Intranet or simply allowing online orders, VFP is more than enough and the use of DATA exchange with this or that is simply a big joke, 99% is by extracting an excel file ! (NAVISION is doing exactly that Whooaoo big deal)
Xbase will move on, that is why I am not worried at all, and also knowing the product is supported until 2015 allows us to tell customers that there is no problems.
2015 !! What will happen until that date, will google by Microsoft, is LINUX going to get market shares, will ".net" still the right solution, in our field nobody has any clue on what's next.
Microsoft business model is dead, office is dying, Explorer is less used, Sqlserver is FREE in lite version, so they should be worried to loose the foxpro community, they completely forget that we are Windows based consumers, if anymone goes PHP why would you keep Microsoft as a workstation or server anyways ??!!

Jean-charles CLERC (France)
IT consultant for small/medium business since 1990.
Developper of online application using VFP only since 2000.
www.opuss.net
www.voicenter.eu

 
Sat, Oct 18, 2008 5:17 EDT
Anonymous user
Posted by: JC
Rating:

"I just found this article looking for answers"
What more can be said than your reply. I totally agree.
Microsoft IS NOT XBASE and the issues are not desktop application anyways. I have been in the same situation with PHP and so on and I always went back to VFP code and database because SQL, . NET ... doesn't create any added value to my work besides showing off at the cafe using great expression.
I don't think anyone talks about small/medium business needs for there Intranet or simply allowing online orders, VFP is more than enough and the use of DATA exchange with this or that is simply a big joke, 99% is by extracting an excel file ! (NAVISION is doing exactly that Whooaoo big deal)
Xbase will move on, that is why I am not worried at all, and also knowing the product is supported until 2015 allows us to tell customers that there is no problems.
2015 !! What will happen until that date, will google by Microsoft, is LINUX going to get market shares, will ".net" still the right solution, in our field nobody has any clue on what's next.
Microsoft business model is dead, office is dying, Explorer is less used, Sqlserver is FREE in lite version, so they should be worried to loose the foxpro community, they completely forget that we are Windows based consumers, if anymone goes PHP why would you keep Microsoft as a workstation or server anyways ??!!

Jean-charles CLERC (France)
IT consultant for small/medium business since 1990.
Developper of online application using VFP only since 2000.
www.opuss.net
www.voicenter.eu

 
Mon, Oct 20, 2008 7:41 EDT
Anonymous user
Posted by: Quentin
Rating:

Once again, another article by someone who believes the Microsoft marketing machine. The only reason why VFP "needs" to die is because Microsoft refuses to incorporate it into their long-term future developments program in favour of their .NET debacle. VFP was purchased by Microsoft for a number of reasons: (1). to backward engineer the cursor technology to make ADO recordsets a reality; (2). incorporate Rushmore optimisation, which fell on stony ground when the Microsoft developers realised it wasn't a "plug-in", but inextricably entwined in VFP's internal code; (3). the data-environment, which Microsoft implemented poorly in VB, necessating the "creation" of .NET; (4). the central DB-engine for SQL-Server.

As a result of Microsoft's cack-handed handling of VFP, jobs and roles in this programming skill literally dried up, and I ended up bankrupt, so please don't lecture me on the virtues of Microsoft and their heavy-brows in making the decision to ditch VFP. .NET mania swept Europe like the newest craze and VFP developers weren't the only to suffer as a result.

I've moved over to PHP, Linux, OpenOffice, HTML, PostgreSQL, and I'm a SQL expert thanks to VFP's mature SQL engine, and many application development languages wish they could boast that. The only Microsoft product I'll ever use from now on is WindowsXP. Open-source all the way, and I feel that the 1 Billion Euros levied by the EC and the Indian government's refusal to move away from Open Office XML architecture are well-deserved punitive measures against Microsoft.

Post new comment

* Subject:
* Username:
* E-mail:
The content of this field is kept private and will not be shown publicly.
Homepage:
* Body:
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <img> <blockquote> <strike> <p> <br>
  • Lines and paragraphs break automatically.
More information about formatting options

* Denotes required field.

About this Blog

Information technology insights and opinions from academia and industry.

Hot Conversations

Ex-Microsofties Look Back in Anger

Posted by Shane ONeill in News | 4 comments

The Price of IT Outsourcing

Posted by Beth Bacheldor in Best Practices | 2 comments

Start a Conversation
Click to post

Got something to say? We want to hear it! Click the Post button to get started. GO»

EXPERT ADVICE
See our roster of experts.

Advice & Opinion from more than 115 of IT's most insightful thinkers.

  PARTNERS       WEBCASTS    
 

Windows 7 Webcast Series

There's a lot of buzz about Windows 7 out there. Each month in our webcast series, listen to analysts and customers discuss how Windows 7 and the Windows Optimized Desktop is impacting large companies around the world. Learn how they evaluated Windows 7, including the cost of deployment, deployment strategies, and tangible benefits.

Sponsored by Microsoft  Listen to on-demand Recordings »

 

A Framework for Better Application Delivery

The complexity of application delivery is driven in part by the evolving applications environment. Instead of approaching application delivery from a siloed fashion, this handbook looks at end-to-end guidance and discusses the impact of ignoring the WAN, Web apps that are chatty, data center consolidation, SaaS, Web 2.0 and virtualization.

Sponsored by Riverbed  Read this White Paper »

 

Microsoft® Exchange 2010 includes archiving - but is it enough?

Microsoft® Exchange 2010 includes basic email archiving. But many organizations will find that it does not meet their requirements. This paper describes why organizations need to archive, what capabilities Exchange 2010 includes and why 3rd party archiving solutions will be necessary for most organizations.

Sponsored by Google, Inc.   Read this White Paper »

Resource Alerts

Get instant email notifications by topic when white papers, webcasts, and case studies are added to our library.

Resource Alerts

Get instant email notification when white papers, webcasts, and case studies are added to our library. Don't just be up-to-date—be up to the minute with our new Resource Alerts.

Enterprise Capture: Your Onramp to Business Process Automation

Today more than ever companies are seeking to reduce costs and...  View Now »

 

The True Cost of Legacy Systems

How well are you maximizing existing software assets? This webcast reveals the results of a commissioned study on top migration and modernization priorities for IT leaders.   View Now »

 

How To Maximize Your Virtualization Strategy and Deployment

Join award-winning technology journalist Stan Gibson in this webcast as he discusses how to enhance your virtualization strategy with the ROI, planning, implementation and platform advice. Exploit the business benefits of virtualization and successfully expand your current deployment.   View Now »

Resource Alerts

Get instant email notification when white papers, webcasts, and case studies are added to our library. Don't just be up-to-date—be up to the minute with our new Resource Alerts.

 
NEWSLETTER

Sign-up for the Blogs & Discussion Newsletter




*Required fields

By clicking the sign-up button, you agree to the Privacy Policy.

View all newsletters »

 
FEATURED SPONSORS
 
 
 
SPONSORED LINKS
 

Manage limitless content todayread EMCs 15-minute guide to ECM.

HP Exstream. Get a Free Document Assessment for Financial Services.

Take the Netezza TwinFin TestDrive!

Webinar: Jump-start your in-house e-discovery with Ringtail QuickCull from FTI Technology

Let Progress Software help your business make progress.

Best Practices to Reduce IT Operational Costs

Real-world testing ranks Trend Micro #1 against malware. See results.

Forrester: The real-world financial impact of Windows 7

Turn your desk phone and mobile phone into one with Sprint Mobile Integration.

Maximizing efficiencies with unified communications.

Stay informed with custom newsletters from Tech Dispenser

Selecting the Right Reporting Technology

An IT Leadership Action Plan for the Economic Recovery

Consolidate data centers and lower IT service costs. Learn How.

WAN optimization techniques significantly improve application performance. Read More.

The Revolution and Evolution of Private Cloud Computing

ROI of Application Delivery Controllers

Cut Costs & Green Your IT Operations with PC Power Management

Enterprise Capture: Your Onramp to Business Process Automation

Adobe® LiveCycle®solutions for intuitive user experience

Unlocking the Mainframe: Modernizing Legacy System to SOA

State of the Data Integration Market

Enhance Customer Loyalty through Higher Responsiveness

Achieving Business Agility with Application Grid

Seven Ways ITIL Can Help You in an Economic Downturn

Does your IDS really work? Find out with a free Endace Audit

Verint Systems. Discover the Power of Intelligence in Action"

CA ARCserve r12.5 is More Than Backup! Download Trial Version Today

Enterprise search helps employees get more done. Get the facts from Google.

See why ShoreTel is named best overall VoIP provider by Nemertes Research

Trend Micro ranked #1 against real-world malware. Read more.

AT&T Application Management & Hosting. Let us help you STRETCH

Microsofts new client operating system helped Pella reduce power consumption.

Efficiency goes up. Costs come down.

Dark Fiber from Sunesys Save on Unlimited Bandwidth with Fixed Costs.

Trend Micro ranked #1 against real-world malware. Read more.

Webcast: Solve Your Data Visualization Needs with Open Source BI

Webcast: Delivering the Enterprise-Ready Cloud

Ensure cost effective application delivery. Learn More.

Cloud Computing: The Impact CIOs See

What's Next for Enterprise Resource Planning?

Gartner Magic Quadrant, Application Delivery Controllers 2009

Global Research: CIOs Weigh In On Virtualization

Adobe® LiveCycle® solutions for business process automation

What's New in SOA Suite 11g?

Unleash the Power of Java with Oracle JRockit Real Time

SOA Best Practices and Design Patterns

Application Grid: Ideal Platform for IT Consolidation

Taking the Service Desk to the Next Level