Fast Development in Visual FoxPro

   

Microsoft® Visual FoxPro® offers a host of features to help you write code faster. These features include wizards, a Component Gallery, the Visual FoxPro Foundation Classes, an Application Framework, and an Application Builder. Wizards help you quickly accomplish common tasks, such as creating forms, formatting reports, and setting up queries. The Component Gallery helps you reuse code by providing a central location for software objects such as class libraries, forms, buttons, and so on. The Visual FoxPro Foundation Classes are provided with the Component Gallery and help reduce coding by providing "out-of-the-box" functionality. The Application Framework makes it easier to develop Visual FoxPro applications by providing several common application objects. The Application Builder works with the Application Framework to help you add, edit, or remove tables, forms, and reports.

Accomplishing Common Tasks Quickly with Wizards

Wizard Description
Application Wizard (new) Creates a project and a Visual FoxPro Application Framework, and then opens the Application Builder so you can add a database, tables, reports, and forms.

For more information, see Application Wizard (5.0) online in MSDN Library Visual Studio 6.0.

Connection Wizards (new) Includes the Code Generation Wizard and the Reverse Engineering Wizard. These wizards help you manage transfers between Visual FoxPro class libraries and Microsoft Visual Modeler models.

For more information, see Connection Wizards Overview online in MSDN Library Visual Studio 6.0.

Cross-Tab Wizard Creates a cross-tab query, displaying the results of a query in a spreadsheet format.

For more information, see Cross-Tab Wizard online in MSDN Library Visual Studio 6.0.

Database Wizard (new) Uses predefined templates to help you create a database containing appropriate tables. After the wizard generates the database, you can add the database to a Project or to the Component Gallery or open the Database Designer to modify the database tables and relationships.

For more information, see Database Wizard online in MSDN Library Visual Studio 6.0.

Documenting Wizard (enhanced) Formats and produces text files from your code in projects and program files. For example, the wizard can indent your source code, capitalize reserved words and variables, and produce a report of the keywords in the program.

For more information, see Documenting Wizard online in MSDN Library Visual Studio 6.0.

Form Wizard (enhanced) Creates a form for data entry from a single table. The size of the form is based on your Maximum design area setting on the Forms tab of the Options dialog box.

For more information, see Form Wizard online in MSDN Library Visual Studio 6.0.

Graph Wizard (enhanced) Creates a graph from a Visual FoxPro table using Microsoft Graph. The larger your table is, the longer it will take the wizard to process your graph. You might consider limiting the scope of records in a large table by creating a view before you run the Graph Wizard.

For more information, see Graph Wizard online in MSDN Library Visual Studio 6.0.

Import Wizard (enhanced) Imports data into Visual FoxPro tables from other file formats.

For more information, see Import Wizard online in MSDN Library Visual Studio 6.0.

Label Wizard (enhanced) Creates labels from a table.

For more information, see Label Wizard online in MSDN Library Visual Studio 6.0.

Local View Wizard Creates views using native data. If you do not have a database open, you are prompted to open a database or create one.

For more information, see Local View Wizard online in MSDN Library Visual Studio 6.0.

Mail Merge Wizard (enhanced) Creates either a data source for a Microsoft® Word merged document or a text file that can be used by any word processor. You must have a current version of Microsoft Word and Open Database Connectivity (ODBC) installed on your computer in order to create a Microsoft Word merged document. Visual FoxPro Setup can install ODBC. For information about merged documents, see Microsoft Word Help.

For more information, see Mail Merge Wizard online in MSDN Library Visual Studio 6.0.

One-To-Many Form Wizard Creates a form for data entry from two related tables. The size of the form is based on your Maximum design area setting on the Forms tab of the Options dialog box.

For more information, see One-To-Many Form Wizard online in MSDN Library Visual Studio 6.0.

One-To-Many Report Wizard Creates a report that groups records from a parent table with records from a child table. The wizard prompts you with simple questions as you go through a brief series of steps, in which you specify the table and fields that you want to use to create controls on your report.

For more information, see One-To-Many Report Wizard online in MSDN Library Visual Studio 6.0.

Oracle Upsizing Wizard Creates an Oracle database that duplicates, as much as possible, the functionality of a Visual FoxPro database. You can use the Oracle Upsizing Wizard to:
  • Move local data to a remote server.

  • Transform local base tables and local views into remote base tables and remote views.

  • Migrate a local application to a client/server application.

For more information, see Oracle Upsizing Wizard online in MSDN Library Visual Studio 6.0.

PivotTable Wizard (enhanced) Creates pivot tables. Pivot tables are interactive worksheet tables. With them, you can summarize and analyze data from existing tables. You can choose either to save a pivot table directly in Microsoft Excel or to add one as an object on a form. You must have Microsoft® Excel with Microsoft Query installed on your computer in order to create a pivot table. For more information about pivot tables, see Microsoft Excel Help.

For more information, see PivotTable Wizard online in MSDN Library Visual Studio 6.0.

Query Wizard Creates a selection of records based on some rules you specify.

For more information, see Query Wizard online in MSDN Library Visual Studio 6.0.

Remote View Wizard (enhanced) Creates views using remote data (ODBC). You must have an existing database to store your view in, as well as an existing data source or connection. If you do not have a database open, you are prompted to select an existing database or create one.

For more information, see Remote View Wizard online in MSDN Library Visual Studio 6.0.

Report Wizard (enhanced) Creates reports using one free table or one table or view in a database. The wizard prompts you with simple questions as you go through a brief series of steps, in which you specify the source and fields that you want to use to create controls on your report.

For more information, see Report Wizard online in MSDN Library Visual Studio 6.0.

Sample Wizard (new) This sample wizard is a demonstration of a do-it-yourself wizard that is created by using the files in the Wzsample folder. The Sample Wizard creates an HTML document using data from a table or view.

For more information, see Sample Wizard online in MSDN Library Visual Studio 6.0.

Setup Wizard (enhanced) Creates distribution disks from the files in your distribution tree.

For more information, see Setup Wizard online in MSDN Library Visual Studio 6.0.

SQL Server Upsizing Wizard Creates a SQL Server database that duplicates, as much as possible, the functionality of a Visual FoxPro database. You can use the SQL Server Upsizing Wizard to:
  • Move local data to a remote server.

  • Transform local base tables and local views into remote base tables and remote views.

  • Migrate a local application to a client/server application.

For more information, see SQL Server Upsizing Wizard online in MSDN Library Visual Studio 6.0.

Table Wizard (enhanced) Creates tables based on typical table structures. The Table Wizard lets you select a table that fits your needs from the list of sample tables. You can customize the table's structure and fields as you step through the wizard. You can also modify the table later after the wizard has saved the table.

For more information, see Table Wizard online in MSDN Library Visual Studio 6.0.

Web Publishing Wizard (new) Helps you display data from a table or view in an HTML document. You can use or share the file that the Web Publishing Wizard creates in your browser or edit it in a text editor.

For more information, see Web Publishing Wizard online in MSDN Library Visual Studio 6.0.


Reusing Code with the Component Gallery and Visual FoxPro Foundation Classes

The Component Gallery is a new tool that helps you to group and organize objects such as class libraries, forms, buttons, and so on, into object, project, application, or other groupings. These visual groupings are dynamically customizable so that you can use, duplicate, or rearrange components among several classifications within the Component Gallery. The Component Gallery also contains new Visual FoxPro foundation classes that provide "right-out-of-the-box" functionality.

The Visual FoxPro Foundation Classes provide common database development tools and structures, extensible generic components, including those that enhance Web page development, and wrappers for system application programming interface (API) functions, among other things.

For More Information   See the following topics online in MSDN Library Visual Studio 6.0.

Building Applications Quickly with Application Framework and Application Builder

The Application Framework (enhanced for version 6.0) is designed to make it easier to develop Visual FoxPro applications. An Application Framework includes the project file and a starter class library subclassed from the Visual FoxPro base classes, ready for you to populate with new or existing tables and documents. You can access the Application Framework through the Application Wizard or through the New Application item of the Component Gallery.

The enhanced Application Framework provides the project file, main program file, main menu, and Application object, as in the previous version, and adds a master Include file to assist in localization, an optional configuration file used for applications such as top-level forms to implement settings such as SCREEN=OFF, use of the ProjectHook class for controlling events related to the project, and an Application Meta table for holding information used by the ProjectHook class and the Application Builder.

The Application Builder creates, and then opens, an Application Framework in an open project. You can then add, edit, or remove tables, forms, and reports.

For More Information   See the following topics online in MSDN Library Visual Studio 6.0.