Visual FoxPro Success Stories

 

 


Microsoft Visual FoxPro is a superb application development environment for most custom software applications. The Visual FoxPro programming language is comprised of 100's of table functions that you'd have to write for yourself, if you coded in VB or VC++ so you end up writing half the code or less than you would in VB.

Visual FoxPro's native tables and database container are the key to building single workstation and small Local Area Network applications without using SQL server that adds administrative complexity to your application. Given the speed Visual FoxPro accesses information, approximately 90% of database applications can probably run with local FoxPro tables on single workstation or small LAN. If you have a demanding application which requires SQL Server, Visual FoxPro is an ideal front-end for Microsoft SQL Server since it connects seamlessly with no additional programming.

Still not sure if Visual FoxPro is robust enough for your custom software application ? Visual FoxPro was used by the U.S. Military during Operation Desert Shield to analyze the airlift and sealift transportation requirements for deploying U.S. Forces to the Middle East and to predict their arrival dates in-theater

The mission critical application success stories, listed below,  handles thousands of transactions a day.

 

 
Euro Tunnel FoxPro Application
The decision to use a FoxPro-based solution for the Euro Tunnel was made because the overall system requirements could be met, an application could be developed at a reasonable cost, and the application could be delivered on time (there were very large financial penalties involved for late delivery). In fact, the time element was critical, since the decision to implement this system was made late in the game, and there wasn't a great of deal of time for development, interfacing, testing, implementation, and training.

Requirements of the Euro Tunnel application included the ability to interface with several systems, log information collected by those systems, and then permit retrieval of that data. Some of the information was entered by operators, but the bulk of it was collected via automated equipment.

The software was required to operate seven days a week, 24 hours a day, 365 days per year. The system also had to be secure and maintainable by an on-site administrator. Only half an hour per day was permitted for system maintenance, including backup.

All the data collected had to be retrievable online in a real-time manner, and historical information had to be available from archive. The system had to be fault tolerant. If one component failed on either a workstation or the server, mechanisms had to exist to get the system quickly operational.

The delivered system allows queries to 128GB of data in real time, performs backup and restore of all tables in real time, permits real-time hardware maintenance to individual tables, hard drives, computers or file servers, catalogs, stores, and retrieves information for more than 20 years worth of data, logs all data related errors, and permits real time data repair.

 

The Joint Flow and Analysis System for Transportation

The Joint Flow and Analysis System for Transportation (JFAST) is a multi-modal transportation analysis model designed for the U.S. Transportation Command and the Joint Planning Community. JFAST is used to determine transportation requirements, perform course of action analysis, and project delivery profiles of troops and equipment by air, land, and sea. JFAST was first used in Desert Shield to analyze the airlift and sealift transportation requirements for deploying U.S. Forces to the Middle East and predict their arrival dates in-theater. These deployment estimates provided input for establishing concepts of operations and timing for military operations. During Desert Storm, JFAST was also used to track ships, provide delivery forecasts, and analyze what-if scenarios such as canal closings and maintenance delays. In addition to analyzing support for humanitarian efforts such as those in Rwanda and Somalia, and NATO operations such as those in Bosnia USTRANSCOM and the Joint Planning Community use JFAST to determine the transportation feasibility of U.S. National Defense Plans. JFAST is a part of USTRANSCOM's Global Transportation Network

JFAST is a client-server application designed to run on one or more WindowsNT workstations--a JFAST simulation can run on a single workstation or be distributed over several peer workstations, and was developed using Microsoft's Visual FoxPro for application development; Visual C++ for ActiveX controls; and Microsoft C for performance-critical Dynamic Link Libraries (.DLLs). JFAST is the result of reengineering three independent models that previously existed for airlift, sealift, and land transportation into a common architecture. The graphical user interface makes significant use of maps, animations, and other graphic displays to aid the planner in understanding the output from the scheduling models. To assist in preparing briefings, JFAST makes extensive use of OLE automation and Microsoft Office. During the OLE session JFAST instructs the different tools in Office (Word, Excel, and PowerPoint) to collect and prepare output data from the scheduling models into graphs, documents, and briefing slides--one mouse click produces a twenty slide briefing in approximately thirty seconds.
 


Surplus Direct
 

Surplus Software, established in 1992, sells refurbished computer hardware and previous-version software. Located in Oregon's beautiful Columbia Gorge, in the town of Hood River, Surplus Software isn't your average mail order business. Because of its remote location, the company relies on telecommunications and its print catalog as links to its customers. While Surplus Software does very well as a conventional mail order business, the recent move to the World Wide Web delivered a whole new customer opportunity.

This was one of the first sites to use Visual FoxPro as a truly industrial strength Internet database Server. This site is written using Visual FoxPro and West Winds Web Connect product. Visual FoxPro is handling around 300,000 database hits/day! These are requests that are processed by Visual FoxPro, not just downloading of images. It uses Visual FoxPro running as an OLE Server.

Advantage Systems © 2007 • Privacy Policy