- Platform: Windows NT / 98 / 2000 / Me / 95
- Media: CD-ROM
- Item Quantity: 1
Product Details
Would you like to update product info or give feedback on images?
|
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
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.
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items. |
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
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!,
By
This review is from: Microsoft Visual FoxPro 7.0 Professional Upgrade [Old Version] (CD-ROM)
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!
8 of 9 people found the following review helpful:
5.0 out of 5 stars
Most powerfull mid-sized database language available,
By Bill Mittenzwey (St. Louis, MO) - See all my reviews
This review is from: Microsoft Visual FoxPro 7.0 Professional Upgrade [Old Version] (CD-ROM)
VFP has always been a very good choice to handle data in a fast development cycle business world, but VFP7 brings many UI improvements that make it even easier to get things done fast and get new developers up to speed. The addition of VB-like intellisense reduces the F1 trips to check for syntax. The new strong typing will help reduce run-time errors as they should be caught by the compiler. VFP handles up to 2G of data per table, and can have as many tables in a database as you like. It also handles multiple user connections very well. You don't have the restrictions of some databases like ACCESS. When your data get too big, you can easily move to any ODBC SQL server (MSSQL, Oricle,...). VFP scales and integrates with SQL very easily. VFP7 adds on to its ability to be a fast processor of data for asp pages, the ability to integrate with SOAP for real-time messaging.This is a great product for windows based data intensive development. I would suggest that anyone considering which language to use seriously consider VFP.
5 of 5 people found the following review helpful:
5.0 out of 5 stars
The Only Database You'll Ever Need,
By Don S. (Cleveland, OH USA) - See all my reviews
This review is from: Microsoft Visual FoxPro 7.0 Professional Upgrade [Old Version] (CD-ROM)
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!
Share your thoughts with other customers: Create your own review
|
|