Working with Views

When you want a customized and updateable data set for your application, you can create and use views. Views combine the qualities of tables and queries by providing a way to extract a set of data from one or more related tables.

You can retrieve data from local or remote data sources by creating and using local and remote views, create views from multiple tables or based on other views, update data from multiple tables, customize views, use views to display data, update views, and move data offline for manipulation.

In This Section

• Creating Views
  Describes how to create views in general.
• Creating Local Views
  Describes how to create views from data stored locally.
• Accessing Remote Data with Views
  Describes how to create views from data stored on a remote server.
• Creating a Multitable View
  Describes how to access related information that is stored in separate tables by creating or modifying views and adding tables.
• Combining Views
  Describes how to create views based on other views.
• Customizing Views
  Describes ways to customize views in the View Designer, such as defining how fields in a view appear, controlling the update method, adding expressions to remote views, prompting for parameters, and setting timeout intervals.
• Customizing Views Using SQL SELECT Statements
  Describes how to customize views by viewing and editing the SQL SELECT statement generated for views by the View Designer.
• Modifying, Renaming, and Deleting Views
  Describes how to modify existing views.
• Displaying Data with Views
  Describes how to use views to display and update data.
• Manipulating Offline Data
  Offers conceptual information on using Visual FoxPro offline view features to change, collect, and display data outside of the host database.
• Optimizing View Performance
  Explains how to set performance and data fetching options.

Related Sections

Working with Data

Provides information to help you create effective applications by analyzing data requirements and designing your application components to meet those needs.

Working with Tables

Discusses how to make sure your tables have the structure that your application requires. Data type and index choices are essential to the success of your application.

Working with Records

Explains how to store data in the table by adding new records and that you can change and delete existing records through the interface or by using commands.

• Creating Queries
  Describes how to create and use queries to select and display data from tables or views.