Microsoft Visual FoxPro 7.0 Professional Upgrade

Other products by Microsoft

Product Details

• Shipping Weight: 1 pounds
• Shipping: Currently, item can be shipped only within the U.S.
• ASIN: B00005J3A5
• Item model number: 340-01074
• Date first available at Amazon.com: April 23, 2001
• Average Customer Review: 4.7 out of 5 stars  See all reviews (11 customer reviews)
• Amazon.com Sales Rank: #18,346 in Software (See Bestsellers in Software)

  Popular in this category: (What's this?)

  #82 in

  Software > Programming > Database

• Discontinued by manufacturer: Yes

Product Description

Amazon.com Review

Probably the best midrange database development system on the market, Microsoft Visual FoxPro 7.0 Professional Edition takes the ease-of-use and gentle learning curve that are characteristic of Microsoft Access and combines them with the scalability and feature-richness of Microsoft SQL Server 2000. The result is an eminently refined database development system, ideal for projects that aren't performance intensive.

FoxPro disproves the notion that database development and administration are black sciences, comprehensible only to specialists. This database suite demonstrates that you can do meaningful database work in an environment that can be figured out intuitively. The operative word is meaningful. FoxPro is not a friendly-but-feeble database management system you can use only to manage your recipes. Despite its friendly interface, it's a serious database tool.

The traditional way to use FoxPro is to develop a database on a server machine, then compile client applications--which rely on the freely distributable FoxPro runtime environment--to make queries against that server. That's still a good solution, but version 7.0 includes an object linking and embedding (OLE) database provider, with which you can expose FoxPro databases to non-FoxPro client applications. You can also increase your range of client compatibility by choosing to serve your data from Microsoft SQL Server 2000 Desktop Edition (MSDE), which ships with this product. Taking the MSDE path also makes future upgrades to the full version of SQL Server easier. It's straightforward to connect FoxPro databases with Internet Information Services (IIS) sites, which means FoxPro can serve as your Web site's back end. So, even though FoxPro isn't technically part of Microsoft's .NET architectural initiative, this new version is a lot more network-centric than any of its ancestors.

A lot of thought--and many years of customer feedback--have clearly gone into the design of this product. It's hard to imagine how the process of setting up a database could be made easier, since all you need to do is use simple menu commands to create a new project and populate it with databases, tables, queries, and the other elements of a useful application. To create a table, for example, you can choose to use a wizard that presents you with some typical tables--contacts, invoices, products, and so on--and the fields each kind of table typically contains. You can then choose to include in your table all or some of an example table's fields, supplement those fields with fields of your own making, and start collecting data.

The most immediately obvious new user-interface feature is IntelliSense, a longtime feature of other Microsoft products. IntelliSense will automatically complete function names and do syntactical grunt work for you as you type code. You can turn off IntelliSense, or modify its behavior, if you find it intrusive. Other interface changes include dockable windows and toolbars, and a couple of new ways to navigate around large code passages. There's also a new Object Browser tool you can use to examine and refer to the COM objects in your application's environment.

If you prefer to work with code and a command line, FoxPro has your number, as well. You can type commands and arguments that create databases, tables, relationships, views, reports, and queries, to say nothing of full-fledged business applications. The FoxPro language, like its graphical user interface, has been expanded and refined over the years. Microsoft has added more than 50 new commands, functions, and system variables to the language since its last release. Many of the more interesting ones--like XMLUPDATEGRAM() for sending database change notifications--have to do with importing and exporting data in Extensible Markup Language (XML). It's also now possible to monitor and react to events thrown by non-FoxPro COM objects.

Further improvements in FoxPro 7.0 include support for Web services (with which you can advertise your application's capabilities on a network) and Active Accessibility, which is Microsoft's set of hooks for devices and software that help handicapped people. There's also a copy of InstallShield Express included here, which enables you to create deployment packages that install the required files and make the needed settings on computers that will run your applications.

You wouldn't use FoxPro to store values for a performance-intensive software application, and it's a bit too costly to replace quick-and-dirty Access for simple database work. But for medium-size organizations that need to make it easier for people to share data, FoxPro's power and elegance promises to enable insiders to solve database problems with a minimum of outside consulting expense. --David Wall

Amazon.com Product Description

Microsoft Visual FoxPro 7.0 enables you to build high-performance desktop, client-server, and Web database applications with its database development system. Employ its powerful data engine to manage large volumes of data, its object-oriented programming to reuse components across applications, and its built-in XML support to quickly manipulate data. Visual FoxPro 7.0 provides the tools and powerful data engine developers need to manage large volumes of data, whether they are organizing tables of information, running queries, or building full-featured database applications for end users. It helps developers achieve maximum productivity through a powerful development environment and easy-to-use visual design tools, and provides the flexibility to build all types of database applications, and to build and consume COM+ components and Web Services.

Make applications accessible to third-party tools, such as screen readers, voice-recognition devices, and automated test harnesses. You can also make Visual FoxPro data easily accessible to non-Visual FoxPro-based clients. Build interoperable applications and components through the ability to represent Visual FoxPro data as XML and to import XML data into Visual FoxPro tables. Control user actions with code that executes when databases are opened, closed, or modified. You will reduce coding time by obtaining powerful, extensible language assistance as you type. View and quickly navigate to procedures, functions, and methods in source code, dock common tools such as command, data session, and debug windows. You can create setups for your custom applications using a special version of the popular InstallShield Express developed exclusively for Visual FoxPro. The enhanced code editor reduces coding time with support for bookmarks and shortcuts, find capabilities, and case conversion.

Customer Reviews

Most Helpful Customer Reviews

15 of 16 people found the following review helpful:

5.0 out of 5 stars Not revolutionary, but solid advancements make it Necessary!, August 22, 2001

By	P. James "tech consultant" (USA) - See all my reviews (REAL NAME)

A lot of the enhancements to VFP7 are not necessarily noticed by those who don't lift the hood. Yes, the Intellisense is great and the ability to do XML transactions over the web is great, but don't forget about the ability to write/use web services (part of .Net), the fact you can create/run VFP6 apps without recompiling (try that with .Net). You can now do Event Binding to COM/ActiveX objects (3rd party controls), it has strong data typing (oh yes), it can "implement interfaces" like java, it has "database container events", it is OLE DB accessible by other apps (not just ODBC), it uses Installshield for installations, etc.

Visual Foxpro extends the VFP legacy of not leaving current developers behind while embracing the best of the newest technologies and wrapping them in the fastest database engine on Earth.

I use Visual Basic, C, Java, and Visual Foxpro - VFP allows me to build the most feature-rich, fast applications in the least amount of time which is crucial for any consultant!

5 of 5 people found the following review helpful:

5.0 out of 5 stars The Only Database You'll Ever Need, October 30, 2001

By	Don S. (Cleveland, OH USA) - See all my reviews

With Foxpro, you don't need ADO, recordsets, complicated SQL syntactical nightmares. It scales to incredible sizes, provides multi-user DB access right out of the box, has no overbearing customer facing run time licenses, and saves you big bucks. It connects smoothly to SQL server and Oracle. It exports data to Excel Spreadsheets with a single line of code. It's string handling is fast and efficient, and the environment focuses developers on data first. Version 7 has a few good enhancements like CursorToXML and .dll creation that make it worthwhile. The Intellisense is great if you don't already know the language.
I get more done with Foxpro in twenty minutes than most VB programmers do in a week!

5 of 6 people found the following review helpful:

5.0 out of 5 stars VFP 7 - Best Version of FoxPro Yet, June 22, 2001

By	David Lauben (Albuquerque) - See all my reviews

I've been developing in the beta version of VFP 7 for the past 6 months, and so far I've had a great experience with it. Even in beta I've found the product to be robust and reliable. In VFP 7 it even easier to develop applications due to it many new features such as intellisense (you start a command, and the program provides the possible options to finish it). I'm to the point where I feel a bit too contrained when I have to go back and use VFP 6.0 for code maintenance purposes. I know I can't wait for the final release of version 7 -- I'll be first in line to purchase.