Question

Is foxpro a dead language???

Asked by: Malibucompany

In working with all of you here I have discovered that Fox Pro can acomodate-one way or another-anything that one can think of.  It is time tested and very powerful. Why has it fallen into disfavor? Or is it in disfavor? Seems that most people I talk too have not heard of it and quickly start talking about Access.  

Does anyone know what Microsofts Future plans are for FOX?  Is 9 the last release? I hope that it is supported over the years since you can do most anything with it and I am learning it.

D

This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.

Subscribe now for full access to Experts Exchange and get

Instant Access to this Solution

  • Plus...
  • 30 Day FREE access, no risk, no obligation
  • Collaborate with the world's top tech experts
  • Unlimited access to our exclusive solution database
  • Never be left without tech help again

Subscribe Now

Asked On
2009-10-31 at 16:10:37ID24861269
Tags

Fox Pro 9

Topic

FoxPro Database

Participating Experts
8
Points
250
Comments
12

Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.

  • "The time we save is the biggest benefit of Experts Exchange to Warner Bros. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange." Mike Kapnisakis, Warner Bros.
  • "Our team likes having a resource that is more secure than just using Google and most experts using this service really know their stuff. It's nice to look here first versus using Google." Dayna Sellner, Lockheed Martin
  • "Anytime that I've been stumped with a problem, 9 out of 10 times Experts Exchange has either the accepted solution or an open discussion of the potential solution to the problem." Kenny Red, eBay Inc.

See what Experts Exchange can do for you.

Got a question?

We've got the answer.

Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.

Screenshot of Experts Exchange Knowledgebase

Need individual assistance?

Our experts are ready to help.

If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.

Screenshot of Experts Exchange Knowledgebase

Want to learn from the best?

Read articles from industry experts.

Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.

Screenshot of an Article

Working on a long term project?

Store your work and research.

Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.

Screenshot of Experts Exchange Knowledgebase

Access the answers to your technology questions today.

Subscribe Now

30-day free trial. Register in 60 seconds.

What Makes Experts Exchange Unique?

Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Trusted by the world's most respected brands.

image of each brand's logo

Faithfully serving IT professionals since 1996.

Experts Exchange Logo

Try it out and discover for yourself.

Subscribe Now

30-day free trial. Register in 60 seconds.

Related Solutions

  1. Dead AMD K6-2-500
    Someone brought me a dead PC. He tells me that he has loaded win98 service pack 1 2 days prior to misshap. He had left the PC on and when he returned the screen was frozen. He reset it to have it shutdown and would not restart. When it is powered on the monitor goes into ...
  2. FoxPro for DOS to FoxPro for Windows
    Hi. Does anybody know if there exists a software or something that would convert my application written in FoxPro For Dos to FoxPro for Windows or Visual Fox Pro?? Thanks,
  3. MySQL Interface to FOXPRO
    I work in a complet fox pro environment. WE have 4 different computer systems here that are all foxpro based. 3 foxpro, and 1 Visual foxpro. I know php, apache and more importantly MySQL (and other flavors of SQL such as oracle). I have read about MySQL using different data...
  4. The pictute of Fox in Visual Foxpro
    Dear advisor ! I am amatue using VF for 8 years . I want to get the picture of FOX. The picture is bmp or jpg. I want to have a picture of FOX at my working place. The more better the mre bigger of picture Thank for all consider
  5. Returning Foxpro cursors to .Net from a Fox XML web ser…
    I need a little help. I'm developing a enhancement to our current foxpro system where a person using a Pocket PC connected wirelessly will need access to our Fox data. I'm building a Fox XML web service that will perform alot of complex tasks. The reason that I am using Foxp...

Free Tech Articles

  1. WARNING: 5 Reasons why you should NEVER fix a computer for free.
    It is in our nature to love the puzzle. We are obsessed. The lot of us. We love puzzles. We love the challenge. We thrive on finding the answer. We hate disarray. It bothers us deep in our soul. W...
  2. SCCM OSD Basic troubleshooting
    SCCM 2007 OSD is a fantastic way to deploy operating systems, however, like most things SCCM issues can sometimes be difficult to resolve due to the sheer volume of logs to sift through and the dispe...
  3. Migrate Small Business Server 2003 to Exchange 2010 and Windows 2008 R2
    This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Windows 2008 R2 with Exchange 2010. For this migration to work you will need the fo...
  4. Create a Win7 Gadget
    This article shows you how to create a simple "Gadget" -- a sort of mini-application supported by Windows 7 and Vista. Gadgets can be dropped anywhere on the desktop to provide instant information, ...
  5. Outlook continually prompting for username and password
    There have been a lot of questions recently regarding Outlook prompting for a username and password whilst using Exchange 2007. There are a few reasons why this would happen and I will try to cover t...
  6. Backup Exchange 2010 Information Store using Windows Backup
    There seems to be quite a lot of confusion around the ability to backup Exchange 2010 using the built in Windows Backup feature. This stems from the omission of this feature prior to Exchange 2007 s...

Cloud Class Webinars

  1. Avoiding Bugs in Microsoft Access
    Alison Balter takes and in-depth look at avoiding bugs in Access. In this webinar you will learn about using the immediate window to debug your applications, invoking the debugger, using breakpoints to troubleshoot, stepping through code, setting the next statement to execute, ...
  2. Top 10 Best New Features in Visio 2010
    Scott Helmers gives live demonstrations of the top 10 new features in Visio 2010. This webinar will teach you how to create compelling diagrams by adding shapes to the page with a single click, linking the shapes in a diagram to data in Excel (or SQL Server, or SharePoint), ...
  3. IT Consultant Business Secrets Revealed
    Michael Munger, Experts Exchange tech pro and IT consultant, pulls back the curtain on his very successful businesses and answers question on every IT consultant and business owner should know about. He shares secrets on what he did to solve the 5 most common problems in IT, ...
  4. Disaster Recovery and Business Continuity
    Quest CTO, Mike Billon, gives an overview of the steps involved in building a dunamic disaster recovery plan. Through case studies and an examination of software/hardware tooles for monitoring and testing, you'll gain a better understandin of where you are, where you want ...
  5. Organize Your Visio Diagrams with Containers and Lists
    Scott Helmers uses cross functional flowcharts, wireframe diagrams, data graphic legends and seating charts to teach you: how to ustilize all three new structured diagram components in Visio 2010, the best practices for organizeing shapes in previous version of Visio, how to organize ...
  6. How to Us Objects, Properties, Events and Methods in Microsoft Access
    Alison Dalter gives an in-depbth look at objects, properties, events and methods in Microsoft Access. In this webinar you will learn about using the object browser, referring to objects, working with properties and methods, working with object variables, understanding the ...

Join the Community

Give a Little. Get a Lot.

Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.

Join the Community

Answers

 

by: Miss_SellaneusPosted on 2009-10-31 at 16:48:54ID: 25712080

As a former Foxpro consultant, I can tell you it is DEAD.

 

by: DaveG1960Posted on 2009-10-31 at 16:54:33ID: 25712093

According to the article at http://www.eweek.com/c/a/Application-Development/Microsoft-Puts-FoxPro-Out-to-Pasture/ , Microsoft has opted to phase out Foxpro for several reasons. Primarily, it feels that SQL Server, .Net, (and MS Access) are sufficient for the database community, and that less and less of the newer developers have an interest in FoxPro.

The good news is that FoxPro will be supported by MS until 2015, and that portions of the code from the improvements in 9.0 will used for other projects. Finally, as stated in that article, your FoxPro database can be converted to.Net at www.VFPConversion.com.

I realize this isn't the news you were hoping for, but at least this provides you with some information regarding the fate of the good 'ol Fox.

Dave

 

by: andrewbarnettPosted on 2009-10-31 at 16:57:20ID: 25712097

Pegasus accounts don't seem to think Foxpro is Dead.  Over 30,000 uk businesses use it, not quite world domination.  As a current systems developer for the aerospace industry I am still creating cutting edge systems with it.

 

by: MalibucompanyPosted on 2009-10-31 at 17:13:17ID: 25712139

If you were to all be starting out today, what database language would you learn and hope to continue to use over the next 10 years??

 

by: DaveG1960Posted on 2009-10-31 at 17:18:26ID: 25712157

SQL appears to be rather universal. Although there are several different flavors (MySQL, Oracle, MS SQL being primary examples), it is relatively straightforward to learn. It has a huge installed base, and MS continues to come out with updates with the latest as of 2008.

Dave

 

by: jrbbldrPosted on 2009-10-31 at 17:25:14ID: 25712178

All you would have to do would be to Google for Foxpro to get LOTS of opinions on this topic.

Foxpro/Visual Foxpro has always been a 'red-headed stepchild' from the Marketing perspective.   And with limited marketing effort it was not as well 'recognized' for its advanced attributes by the general programmer audience.  The significantly better marketed VB, VC, VC++, etc were considered to be a more 'mainstream' programming approach despite historically fewer capabilities.   Therefore a much larger developer audience was created around these so-called 'mainstream' application languages and that larger pool of developers has led some to think of VFP as a 'lesser' or even 'unknown' language.  
That misguided perception has lead to many non-technical people having a less-than accurate opinion of the capabilities of FP/VFP.

Regardless of history, Microsoft has indeed decided to not go forward with Visual Foxpro beyond Version 9.   They are focusing their foreseeable future on .NET languages.  

Support for FP/VFP has always been limited and/or hard to get directly from Microsoft.   Instead it has come largely from forums like this one and I believe that this support approach will be an on-going resource for a good while to come.

That having been said, the 'future' of Visual Foxpro is a matter of opinion.  

If an application developed in Pascal or COBOL is still working well after 25 years or more, should the language be considered 'dead'?

There are many, many applications that are still working well after 25+ years that were developed in FP/VFP.    And there are many, many applications being developed today with VFP.

If you are attempting to make a 'sales' job to your management (a group not always tuned into the technical advantages of languages) about which language to develop a new application in, then you might face a challenge convincing them that VFP is a GOOD and VIABLE language to use as opposed to VB.NET or C++, etc.

If you are considering what development path you might want to take for your own career, then going with some .NET language would put you into a more 'mainstream' marketable position.

However if you are considering converting an old FP application then there is no doubt that the effort to bring it into the 21st Century would be significantly easier if you were to go with VFP9.   And, if the application were well written before, it might continue working for many, many years.

In summary the answer to most all of your questions is - "It Depends..."

Good Luck

 

by: pcelbaPosted on 2009-10-31 at 18:25:36ID: 25712289

Why has it fallen into disfavor?

Two reasons:
1) It competes to Access
2) It competes to SQL Server

Future plans? Force us to forget.

 

by: CaptainCyrilPosted on 2009-10-31 at 23:20:57ID: 25712798

Microsoft did a great job in marketing VB, C# and .Net stuff and it did a great job in Visual FoxPro. FoxPro was great (the best) even before Microsoft bought it. FoxPro is the most versatile, stable and has everything in one. Visual Studio's stuff is based on millions of components and thus is not very stable.

I personally program in Visual FoxPro only. My team develops in .Net. They suffer from instability in development and deployment on Microsoft platforms. When I compiled my applications for Windows, DOS, Mac using FoxPro, I never had any problems with compatibility.

FoxPro was discontinued for:
1) Non direct Unicode Supper
2) No Security in the DBF structure database
3) Most importantly, Microsoft was losing money not selling enough Access, .Net and SQL.

Access is very easy to learn. Most people can use it.
FoxPro is easy or hard depending on what level you are or what you are trying to achieve. But it is the best. It does everything.
.Net has a high curve to learn. It will get there in another 5 years that we can totally shift from FoxPro.

My 16-bit and 32-bit applications in FoxPro are running perfectly well. Specially the ones I build in DOS. They are running on Vista perfectly fine.

There is an application which I built in one day in FoxPro. It took my .Net certified developer 10 days to build it in .Net.

 

by: CaptainCyrilPosted on 2009-10-31 at 23:27:55ID: 25712802

Two of my multinational clients have asked me personally to develop market research software for them in FoxPro. Both have a Visual Studio team.

If I want to build a small utility that runs on all Microsoft Platforms without any library, I use Real Basic on Mac and Compile for PC. FoxPro has one library file. I am still counting the ones for Visual Studio. :-)

 

by: dportasPosted on 2009-11-01 at 08:48:01ID: 25714299

One reason Microsoft killed FoxPro was that its greatest strength was also its guarantee of obsolescence: the FoxPro database engine. The desktop / file-sharing database architecture became a redundant technology as client-server DBMS became far cheaper and easier as well as more powerful, scalable and secure. File based database applications were a technology of the 1980s but are no match for the priorities of most corporate IT departments and network environments of today. Yes Access has survived but only because it appeals to power users and information workers rather than just developors. As a development language Access is certainly eclipsed by .NET, Java, et al.

>> what database language would you learn and hope to
>> continue to use over the next 10 years?

None. I wouldn't bet one cent on any technology lasting 10 years. For sure some technologies will be around that long but why assume you need to limit your options? Most business quite rightly expect a return on IT investments within 3 years anyway. My advice would be to be prudent, keep in touch with what's happening in the market place, keep your skills sharp and up-to-date and don't bet your career or your business on any one technology.

 

by: CaptainCyrilPosted on 2009-11-02 at 01:22:45ID: 25717989

I develop my apps in FoxPro and they will server me well till 2015. I have written them in such a way that I can translate them programatically to another language. I have done that for FoxPro to Java because they were required to run on the web.

 

by: Olaf_DoschkePosted on 2009-11-02 at 08:47:52ID: 25721021

Hi Malibucompany,

It's rather surprising, that it's still a surprise to some people after the announcement to discontinue VFP is already over two years old. Take a look here: http://msdn.microsoft.com/en-us/vfoxpro/bb308952.aspx

Looking back we can see the shadows of this were already casted rather early, as VFP was seperated from the Visual Studio Suites with VFP7 in 1999, because mainly it's concept of macro substitution weren't in line with the .NET concept of JIT compilation, neither as managed nor as unmanaged code. I think the dynamic nature of VFP wouldn'T even fit into the new DLR of .NET for dynamic languages like IronPython or IronRuby.  On the other side, you might get comfortable with one of these two .NET languages, if not with C# or VB.NET

You might rather migrate to Access with it's similar structure of an incorporated database and it's relatively similar VBA language.

From my personal professional perspective: In the last two years I migrated an enterprise application from VFP9 to VFP9 in the past two years, the migration was not a migration away from VFP, but the backend changed from VFP DBC to SQL Server 2005.

For the hobbyist or freelancer it might be more important to migrate to a newer technology than for programmers working in or for larger companies with less dynamic and flexible IT landscape of applications interacting with each other and each other's data.

In general I see new jobs rather being migration jobs, nevertheless VFP doesn't loses it's advantages of a royalty free database, it's performance on single desktop applications and some more. As long as some of the lacks which were already mentioned with missing Unicode support and it's size limitations are of no interest, VFP is still a good choice for developers very familliar with VFP of course. You can't buy knowlegde in another language with money only, this also is a time investment, which can be a limiting factor even for new projects.

The future surely isn't VFP, but the community is still thriving, see VFPX and VFPY on codeplex.

Bye, Olaf.

20120131-EE-VQP-002

3 Ways to Join

30-Day Free Trial

The Experts

98% positive feedback on 31,087 answers since March 2000. angeliii is a Microsoft Most Valuable Professional for his work with MS SQL Server & Develoment.

He has also proven his knowledge of Visual Basic Programming, PHP Scripting and Oracle Databases.

The Experts

97% positive feedback on 10,752 answers since July 2000. lrmoore has more than 18 years experience in the networking industry.

The six-time Mircosoft MVPs specialties include firewalls, virtual private networking, and network management.

Testimonials

"...and excellent source for support... Kind of like having your very own IT dept." Electriciansnet

Testimonials

"I was apprehensive at signing up at first. However... it has already made my life as an IT administrator much easier." JaCrews

Testimonials

"WOW! You guys have great, active, and knowledgeable people on here." moore50

Business Clients

Business Clients

In the Press

"If you’ve got a question... Experts Exchange can supply an answer.”

In the Press

"...an invaluable aid for both IT professionals and those who require tech support."

In the Press

"where IT professionals provide quick answers on just about any topic"

Business Account Plans

Loading Advertisement...