Visual FoxPro is still here, still very relevant

<h1>Visual FoxPro is still here, still very relevant</h1>Author: <a title="Sylvester Alelele" href="http://www.articlesbase.com/authors/sylvester-alelele/146892.htm">Sylvester Alelele</a> I am writing this article because I read a very interesting article about Visual FoxPro on SD Times web site! The title of the article is ‘Where have you gone, Visual FoxPro?’ Even though the Article did some justice to the FoxPro Product, and its great contributions and the many product milestones, I still thought that the basic question posed by the article had to be answered. This is important to many of us who still use Visual FoxPro to architect and deliver great MIS Products because as far as we are concerned, Visual FoxPro is still very much here! So what then can we say is Visual FoxPro’s place in an enterprise application architecture today? Is it relevant when compared to other alternative offerings from Microsoft – the company that makes Visual FoxPro! This article attempts to document our experiences as a company that sells many custom-developed application software products made with virtually all of Microsoft’s Database Offerings (Ms-SQL Server, Ms Access and Of course Ms Visual FoxPro)! I first started using FoxPro in 1992! Then it was version 1.01 running on a PCMOS 4.1 Network. I was fresh out of school with some little programming knowledge on GW-Basic, MF Cobol and dBASE III! The Mortgage Bank I joined and worked for ran its Banking Software (Swift Banking System) written with Clipper 5 on a FoxPro Database. At the time, most people wrote their programs on dBASE IV and then had those programs compiled with FoxPro or with Clipper! I fell in love with FoxPro immediately because it was so easy to use and had a much more polished interface than dBASE IV and what is more, I was also very impressed that a package as huge as Banking was running on a FoxPro box and was very stable in indeed! Then in 1993, I left the banking sector and did not again use FoxPro until 2001 when I taught ‘Building solutions with Visual FoxPro 6.0’ to Students at MicroLink College (then the school had the option to use either Microsoft Access or Visual FoxPro to demonstrate Database Concepts)! It was during this time that I started exploring the idea of developing a powerful, versatile, modern and affordable MIS Package for Colleges and Universities since the college at that time had no computerized data storage and retrieval system – that package would eventually today become CampusManager™ University Advantage – still in commercial distribution and in use among several University Colleges in Ethiopia today (and running as a pure Fox solution). The requirement was for a system that is feature –rich, user friendly, provided reasonable storage capacities for the sort of volumes of data that could be generated by a school or university college and was yet affordable by schools in the third-world. The combined features of an affordable and  feature-rich system was necessary because most of the clients that buy our system can be considered as small or medium-scale enterprises that will ‘balk’ at the cost involved in licensing Ms SQL Server or Oracle Databases. Also, the programs would be running in an environment where these organizations may not necessary afford thousands of dollars to retain trained SQL Server or Oracle DBA’s so the system had to be light, easy to run and still provide all the storage capacity and power of an enterprise solution built to run on SQL Server or Oracle! This reality for us was underscored by the fact that most of the Visual Basic programs we wrote that were designed to run with MS SQL Server; have always suffered from  customer (small to medium scale organizations) complaints - Managers do not simply find that purchasing expensive Ms SQL Server database  licenses is somewhat prohibitive! At the same time, Microsoft Access (Jet Database Engine)/MSDE did not present an attractive alternative because of the 2GB File Size limit that would sooner rather than later force a mid-sized company to look for alternative storage. Add to this the fact that in a typical school, we would have more than 10 users working at a time and Access’s well documented behavior when 10 (ten) or more users are accessing the database concurrently! To summarize, our ‘business parameters’ for selecting an application development tool for our CampusManager™ Offering was (and still is) as follows: <ul> <li>System must be feature rich</li> <li>System must provide reasonable storage capacity for at least 5 years for a school or college with about 2000 student population</li> <li>System must be capable of supporting at least 20 concurrent users without signs of stress (imagine that at least 15 homeroom teachers at a time have to record marks and enter grading information during peak period such as exam time concurrently along with other routine activities by staff and faculty). Our first site, a premium private school boasted 60 homeroom teachers (Grades 1 to 12 each with five sections A to E)</li> <li>System has to be capable of routine performance on just about any environment (the first school we sold to had a P3 Server with Two Processors) since in our market, most clients may just have a PCs and may never even have heard of Servers</li> <li>System must be light and fast and be able to be easily, deployed, configured and implemented in the end-users environment</li> <li>Total cost of ownership for the system must be kept to a minimum. For example, can users easily administer the database (most of our clients may have a teacher or two with a background in simple applications and so would not possess the type of skills required to manage a typical SQL Server Database). FoxPro in contrast is easy and fun to learn!</li> <li>System must be affordable. If our clients can pay not only for our system but also license the database engine for online database maintenance, it is great for them and for us!</li> </ul> So for us it is against this backdrop that we realized that we had a copy of Visual FoxPro bundled with our Visual Studio 6.0 suite of enterprise development tools. After carefully assessing our options, we came to the conclusion that Visual FoxPro 6.0 was the best tool in the Visual Studio suite (we had been concentrating on Visual Basic and Visual C++ against Jet/SQL Server for our other applications) to build a fast, data-centric MIS system for schools, colleges and universities because it just about offered the right combination of power, speed, storage capacity and licensing cost for the market we wanted to target with our system.  For us, this meant that we would not have to ‘fight’ with our clients about expensive database licensing nor would we have to explain why our clients need to move to a more expensive Database Server after just 2-3 years. At the same time, should the need arise, we can easily upgrade the system to run on a bigger database engine (such as SQL server or the Advantage Database Server that now provides full Visual FoxPro Compatibility) without expensive code rewrites! Since our software was released in June of 2006, we have upgraded to using Visual FoxPro 9.0 and have found that our product has elicited quite a lot of interest because of the attractive cost of the package and licensing terms for a VFP Database (optional). But whether our clients accept to buy VFP Database licenses or not (in which case they can use the VFP runtime), our product is still a money-spinner for Microsoft since our clients will still need to license Microsoft Windows to run the application; plus, they always license the application with a promise to upgrade to Ms SQL after a number of years. A couple of months after SD Times posed the question “Where have you gone Visual FoxPro?”; we want to supply an emphatic answer – “Visual FoxPro is still here today! Visual FoxPro is still very relevant in the enterprise!” Here in Africa, we are using Visual FoxPro to build modern, powerful, object-oriented and affordable applications for fast growing companies! And yes! Even though Microsoft says they shall make Visual FoxPro no longer, the product can only get better as many members in the community work to make great add-ons and improvements in the product, adding badly needed functionality. With some of the cool tools we have found on CodePlex such as VFPX and most especially ActiveVFP, we can say that we are in no great hurry to re-write our application on the .NET framework anytime soon! Yes! Visual FoxPro lives!About the Author: Sylvester Alelele is currently Group Head of Operations for Forest-Elephant Technology & Procurement Group Plc. He is a Senior Systems Analyst/Programmer with over sixteen (16) years of progressive,practical industry experience developing and delivering MIS Projects of all sizes. His specialities include Visual Basic/Visual Basic .NET, Microsoft Visual FoxPro, MS SQL Server, Microsoft Jet Databases and Oracle. Mr. Alelele lives and works in Addis Ababa, EthiopiaArticle Source: <a href="http://www.articlesbase.com/">ArticlesBase.com</a> - <a href="http://www.articlesbase.com/databases-articles/visual-foxpro-is-still-here-still-very-relevant-880385.html" title="Visual FoxPro is still here, still very relevant">Visual FoxPro is still here, still very relevant</a>

I am writing this article because I read a very interesting article about Visual FoxPro on SD Times web site! The title of the article is ‘Where have you gone, Visual FoxPro?’ Even though the Article did some justice to the FoxPro Product, and its great contributions and the many product milestones, I still thought that the basic question posed by the article had to be answered. This is important to many of us who still use Visual FoxPro to architect and deliver great MIS Products because as far as we are concerned, Visual FoxPro is still very much here!

So what then can we say is Visual FoxPro’s place in an enterprise application architecture today? Is it relevant when compared to other alternative offerings from Microsoft – the company that makes Visual FoxPro! This article attempts to document our experiences as a company that sells many custom-developed application software products made with virtually all of Microsoft’s Database Offerings (Ms-SQL Server, Ms Access and Of course Ms Visual FoxPro)!

I first started using FoxPro in 1992! Then it was version 1.01 running on a PCMOS 4.1 Network. I was fresh out of school with some little programming knowledge on GW-Basic, MF Cobol and dBASE III! The Mortgage Bank I joined and worked for ran its Banking Software (Swift Banking System) written with Clipper 5 on a FoxPro Database. At the time, most people wrote their programs on dBASE IV and then had those programs compiled with FoxPro or with Clipper! I fell in love with FoxPro immediately because it was so easy to use and had a much more polished interface than dBASE IV and what is more, I was also very impressed that a package as huge as Banking was running on a FoxPro box and was very stable in indeed!

Then in 1993, I left the banking sector and did not again use FoxPro until 2001 when I taught ‘Building solutions with Visual FoxPro 6.0’ to Students at MicroLink College (then the school had the option to use either Microsoft Access or Visual FoxPro to demonstrate Database Concepts)! It was during this time that I started exploring the idea of developing a powerful, versatile, modern and affordable MIS Package for Colleges and Universities since the college at that time had no computerized data storage and retrieval system – that package would eventually today become CampusManager™ University Advantage – still in commercial distribution and in use among several University Colleges in Ethiopia today (and running as a pure Fox solution).

The requirement was for a system that is feature –rich, user friendly, provided reasonable storage capacities for the sort of volumes of data that could be generated by a school or university college and was yet affordable by schools in the third-world. The combined features of an affordable and feature-rich system was necessary because most of the clients that buy our system can be considered as small or medium-scale enterprises that will ‘balk’ at the cost involved in licensing Ms SQL Server or Oracle Databases. Also, the programs would be running in an environment where these organizations may not necessary afford thousands of dollars to retain trained SQL Server or Oracle DBA’s so the system had to be light, easy to run and still provide all the storage capacity and power of an enterprise solution built to run on SQL Server or Oracle!

This reality for us was underscored by the fact that most of the Visual Basic programs we wrote that were designed to run with MS SQL Server; have always suffered from customer (small to medium scale organizations) complaints - Managers do not simply find that purchasing expensive Ms SQL Server database licenses is somewhat prohibitive! At the same time, Microsoft Access (Jet Database Engine)/MSDE did not present an attractive alternative because of the 2GB File Size limit that would sooner rather than later force a mid-sized company to look for alternative storage. Add to this the fact that in a typical school, we would have more than 10 users working at a time and Access’s well documented behavior when 10 (ten) or more users are accessing the database concurrently! To summarize, our ‘business parameters’ for selecting an application development tool for our CampusManager™ Offering was (and still is) as follows:

System must be feature rich
System must provide reasonable storage capacity for at least 5 years for a school or college with about 2000 student population
System must be capable of supporting at least 20 concurrent users without signs of stress (imagine that at least 15 homeroom teachers at a time have to record marks and enter grading information during peak period such as exam time concurrently along with other routine activities by staff and faculty). Our first site, a premium private school boasted 60 homeroom teachers (Grades 1 to 12 each with five sections A to E)
System has to be capable of routine performance on just about any environment (the first school we sold to had a P3 Server with Two Processors) since in our market, most clients may just have a PCs and may never even have heard of Servers
System must be light and fast and be able to be easily, deployed, configured and implemented in the end-users environment
Total cost of ownership for the system must be kept to a minimum. For example, can users easily administer the database (most of our clients may have a teacher or two with a background in simple applications and so would not possess the type of skills required to manage a typical SQL Server Database). FoxPro in contrast is easy and fun to learn!
System must be affordable. If our clients can pay not only for our system but also license the database engine for online database maintenance, it is great for them and for us!

So for us it is against this backdrop that we realized that we had a copy of Visual FoxPro bundled with our Visual Studio 6.0 suite of enterprise development tools. After carefully assessing our options, we came to the conclusion that Visual FoxPro 6.0 was the best tool in the Visual Studio suite (we had been concentrating on Visual Basic and Visual C++ against Jet/SQL Server for our other applications) to build a fast, data-centric MIS system for schools, colleges and universities because it just about offered the right combination of power, speed, storage capacity and licensing cost for the market we wanted to target with our system. For us, this meant that we would not have to ‘fight’ with our clients about expensive database licensing nor would we have to explain why our clients need to move to a more expensive Database Server after just 2-3 years. At the same time, should the need arise, we can easily upgrade the system to run on a bigger database engine (such as SQL server or the Advantage Database Server that now provides full Visual FoxPro Compatibility) without expensive code rewrites!

Since our software was released in June of 2006, we have upgraded to using Visual FoxPro 9.0 and have found that our product has elicited quite a lot of interest because of the attractive cost of the package and licensing terms for a VFP Database (optional). But whether our clients accept to buy VFP Database licenses or not (in which case they can use the VFP runtime), our product is still a money-spinner for Microsoft since our clients will still need to license Microsoft Windows to run the application; plus, they always license the application with a promise to upgrade to Ms SQL after a number of years.

A couple of months after SD Times posed the question “Where have you gone Visual FoxPro?”; we want to supply an emphatic answer – “Visual FoxPro is still here today! Visual FoxPro is still very relevant in the enterprise!” Here in Africa, we are using Visual FoxPro to build modern, powerful, object-oriented and affordable applications for fast growing companies!

And yes! Even though Microsoft says they shall make Visual FoxPro no longer, the product can only get better as many members in the community work to make great add-ons and improvements in the product, adding badly needed functionality. With some of the cool tools we have found on CodePlex such as VFPX and most especially ActiveVFP, we can say that we are in no great hurry to re-write our application on the .NET framework anytime soon!

Yes! Visual FoxPro lives!

Sylvester Alelele is currently Group Head of Operations for Forest-Elephant Technology & Procurement Group Plc. He is a Senior Systems Analyst/Programmer with over sixteen (16) years of progressive,practical industry experience developing and delivering MIS Projects of all sizes. His specialities include Visual Basic/Visual Basic .NET, Microsoft Visual FoxPro, MS SQL Server, Microsoft Jet Databases and Oracle. Mr. Alelele lives and works in Addis Ababa, Ethiopia

Rate this Article:

1.7 / 5 stars - 3 vote(s)

Re-Publish

Related Articles
Related Q&A

Latest Databases Articles
More from Sylvester Alelele

Where to Download PSP Go Games, Movies & Music Revealed!

By: Sarah Brown | 27/12/2009
The new PSP Go hand held gaming system from Sony has hit the market and people have picked it up like it's candy. Now, the problem many are facing is figuring out where to download PSP Go games, movies & music. Sure, you can get downloads from the official Playstation store which you can access directly from the system, but it can be quite expensive. Games can run up to $40 and the music and video selection isn't that great.

PSP Go Download Center Reviw - Is PSP Go Download Center a Scam?

By: Sarah Brown | 27/12/2009
PSP has around the gaming market for a few years back, the Sony PSP has gained the popularity in hand-held gaming console. It has surpassed the Nintendo DS handheld, which no doubt can’t match with what PSP has to offer. Since the PSP is under the trademark of Sony Playstation, the handheld has earned its popularities and made the UMD games, movies and music became quite expensive.

Support Information About AA Online

By: Ed Philips | 26/12/2009
Discover how to quit drinking as revealed in Ed Philips "Alcoholics Anonymous Online" support guide, which offers tried and tested alcoholic addiction methods to quit drinking within 21 days.

DSi Download Center - Get Nintendo DS And DSi Games For Free and Legally!

By: Sarah Brown | 24/12/2009
Many people are sick of buying expensive Nintendo DS and DSi games cartridge and they want to paly games while saving their money, so I will show you where you can download Nintendo DS and Dsi games for free and legally. Not many people are aware that copyrighted Nintendo DS and DSi games can be downloaded on the internet legally. DSi Download Center is a membership based program that has more than 250,000 Downloads making it the Biggest Database for the DSI!

Know the information USB sticks

By: John Milton | 24/12/2009
Now in the market there is high demand of usb sticks among its users. Seeing this the producers of usb sticks now focussing more on its reliability.

Download Jak and Daxter The Lost Frontier PSP Game

By: Sarah Brown | 23/12/2009
PSP UMD discs are becoming quite expensive these days, many gamers are seeking for new alternatives to get the newest and their favorite PSP games for cheap. This article will expose on how and where you can download Jak and Daxter The Lost Frontier for less than $0.01. Jak and Daxter The Lost Frontier is already released on PSP handheld, so you can proceed to download the game instantly.

A Photography Course For All The Family

By: Dan Feildman | 23/12/2009
Excellent Digital Photography Courses Introducing Free Digital Photography Guide called "How To Take Beautiful Digital Pics Made Simple". The latest tips on how to use a digital camera like a pro.

Reinforce Database Management with Remote DBA

By: Kashif Mukhtar | 23/12/2009
Databases are the foundation of the digital economy. They store the information that run businesses and organize the vast amount of data that is created on a regular basis. Even though e-business infrastructures are requiring stronger database support to sustain their 24x7 operations, shrinking IT budgets are forcing companies to reduce the size of their DBA staff. With databases growing in size and complexity, the role of the already overburdened DBA is becoming increasingly difficult.

Populating Visual FoxPro Reports with data on the Fly

By: Sylvester Alelele | 27/08/2009 | Programming
If you are using Visual FoxPro's Report Writer as your reporting environment, how can you generate report data and populate your report at run time? This article explains how to generate or compile data at report run time to be used by your report. This data may not exist or may exist in a form that cannot be readily used in the report!

When it is crunch time: Migrating from Visual Basic 6 to Visual Basic .Net/2005

By: Sylvester Alelele | 27/08/2009 | Programming
As a Visual Basic 6.0 programmer, what is the roadmap forward for your applications? As Visual Basic 6.0 becomes ‘deprecated technology’ what will you do with your enterprise class applications written in Visual Basic 6.0. This article is the musings of a developer that has been looking at migrating existing enterprise-class Visual Basic 6.0 applications to Visual Basic 2005.

Building Data Aware Classes in Visual FoxPro Part 2: Using Data Transports and Temporary Storage

By: Sylvester Alelele | 16/07/2009 | Programming
In the last article (Part 1), we discussed how to encapsulate data access code and business rules in Visual FoxPro by using classes contained in Visual Class Libraries (.vcx) files. If Data Access and Validate code is encapsulated in classes, how can data be returned to a form and how can data-bound forms be built? This artcliel seeks to demonstrate that you can build effective database applications even though your data access code is encapsulated in Data-Aware Classes

Building and Using Data Aware Classes in Visual FoxPro Applications Part 1: Utilizing Visual Class Libraries for Data Access and Business Rules

By: Sylvester Alelele | 23/06/2009 | Programming
Visual Class Libraries allow you to build powerful Visual FoxPro applications and to implement powerful Object Oriented features. Because you can create your own class libraries, you will have an additional place to put code that accesses your application database by building data aware classes (classes that can ‘talk’ to your database and either return queried information, save new information or perform updates and deletes as necessary). This article explores use of Data Aware Classes.

Giving Visual FoxPro a new lease life

By: Sylvester Alelele | 21/05/2009 | Databases
I read an article on the Internet about what can be done by both Microsoft Corporation and Visual FoxPro programmers to give Visual FoxPro a new lease of life! For example, that article suggested doing away with the Fox icon at the top of the Visual FoxPro application window, reengineering parts of the FoxPro application including doing away with the Windows 95 dialog boxes and so on. This article seeks to contribute to that debate, suggesting additional ideas making VFP product more markatable!