Database Development Tool of Choice

 

 

Microsoft Visual FoxPro  is a great tool for building database solutions of all sizes.  Developers will have the necessary tools to manage data—from organizing tables of information, running queries, and creating an integrated relational database management system (DBMS) to programming a fully-developed data management application for end users. Its data-centric, object-oriented language offers developers a robust set of tools for building database applications for the desktop, client-server environments, or the Web.

Visual FoxPro is the finest client-server rapid application development tool available today.  And considering that Visual Basic isn’t object-oriented, anyone using VFP for client-server development has an automatic advantage over most developers. 

It is cheap to deploy.  No need to buy Microsoft Office or Access for each workstation and no need to purchase a Windows 2000 Server with SQL Server client licenses.  Since data access is built-in you only need to distribute the VFP runtime.  VFP databases can happily live on any file server.  Using VFP can delay or remove the need to move to SQL server, which will require fulltime administration.

At its core, VFP is a mighty data access tool with a fast data engine than anything in its class.  Results can be retrieved from a table with millions of records in sub second time.  Equivalent queries would take seconds in Access.  Access drops off after a few thousand records while VFP generally out performs SQL Server and Oracle up to a few million records.

So depending on the size of your database, you may have little reason to pay for the licensing and administration of backend databases such as SQL Server and Oracle. verses

Microsoft Access verses Visual FoxPro

 Features

  • classes.

  • reusable components

  • business rules

  • stored procedures

  • COM objects

  • MDI and SDI apps

  • ActiveX Controls

  • Web Services

  • MAPI controls

  • OLE software

  • Remote date

  • SQL Pass Through (SPT).

  • Offline data

  • ActiveX Data Objects (ADO)

  • ODBC data source

  • Windows APIs

  • DLLs written in C++.

  • HTML pages

  • Active Server Pages (ASP)

  • XML Web Services

  • Simple Object Access Protocol (SOAP)


Resources

Visual FoxPro