Features

Run queries of large FoxPro data files in sub-second times.

Easily manipulate data interactively and programmatically.

Create persistent relationships between tables, stored procedures, events, triggers, rules, and default values.

Build applications based on queries that return filtered Visual FoxPro or Microsoft SQL Server data for increased performance. Take remote data offline for added power.

Control user actions with code that executes when a database is opened, closed, or modified.

Quickly and directly manipulate large amounts of data in corporate transaction-processing solutions.

Manipulate large amounts of data by using Structured Query Language (SQL) statements.

Provide access to Visual FoxPro data from other clients such as Microsoft Visual Studio .NET and Office XP.

Easily migrate Visual FoxPro data to SQL Server databases.

Use the CursorAdapter class for unified data access to native Visual FoxPro tables, XML, Microsoft SQL Server 2000, and ODBC or OLE DB data sources.

Create auto-increment counter fields for primary key fields in Visual FoxPro data tables.

Fully access standard Microsoft Windows events—for example, mouse movements that enable drag-and-drop operations.

Organize and manage all files in a project.

Visually create forms and reports by using drag-and-drop operations to move controls bound to data.

Visually create classes of reusable forms and controls.

Reduce development time with tools that simplify the editing of visual control common properties at design time.

Quickly step through common application development tasks, such as the creation of forms, queries, and reports. Use the Application Wizard to create a complete application quickly.

Create class libraries of reusable code, forms, and controls.

Manage class libraries and other common application components with easy-to-use visual tools.

Choose from more than 100 prebuilt, reusable classes that provide common functionality, and add them to applications easily.

Build applications by using an object-oriented application framework, which consists of a generic set of classes that form the core of an application.

Interact directly with the integrated development environment (IDE) and your applications during runtime.

View and quickly navigate to source procedures, functions, and methods.

Reduce coding time with features that display color-coded syntax, block indent, comments, bookmarks, and shortcuts.

Coordinate the efforts of individual users and development teams, and extend control over the versioning process.

Coordinate the efforts of individual users and development teams, and extend control over the versioning process.

Increase productivity with event tracking, coverage logging, and breakpoint support.

Test applications by checking which lines of code are being executed ("coverage") and perform "profiling" to determine bottlenecks in code.

Control and encapsulate error handling in code using TRY...CATCH...FINALLY structure, escalate exceptions using THROW, and manage using Exception objects.

Build smart client desktop forms using rich features, such as orienting tabs on page frames, locking and automatically resizing columns, highlighting grid rows, changing background color and positioning images on command buttons.

Display and rotate images on forms with support for file formats such as .bmp, .jpeg, .gif, animated .gif, .wmf, .emf, .tiff, and more.

Bind native and custom events and methods to other Visual FoxPro objects.

Build SQL SELECT statement queries using two-way editing between the Query/View designer and source code output.

Subclass member classes, such as pages in page frames and headers and columns in grids. Subclass the DataEnvironment class and use the DataEnvironment and CursorAdapter builders. You can manage application objects using the new Collection class.

Use the Task Pane to manage development tasks and access Visual FoxPro Help, XML Web services, and community news. The new Toolbox provides easy access to frequently used items such as classes, controls, and code snippets. You can search for and replace symbol and text references throughout projects and files using the Code References tool.