Working with Data

You can create more effective applications by analyzing your data requirements and then designing your databases, tables, and indexes to meet these needs.

In This Section

Developing Databases

Describes how to use databases in Visual FoxPro to establish relationships between tables, enforce referential integrity, and manage local and remote data.

Working with Tables (Visual FoxPro)

Introduces creating and working with tables.

Enforcing Business Rules

Provides an overview about how to enforce business rules by using validation rules, preventing duplicate values in fields, and maintaining relationships between tables.

Working with Queries

Describes how to use queries to select and display data from tables or views.

Working with Views (Visual FoxPro)

Explains how to use views to create a customized updatable data set for your application.

Importing and Exporting Data

Explains how information is copied between Visual FoxPro and other applications by importing to and exporting from Visual FoxPro.

Upsizing Visual FoxPro Databases

Discusses building and upsizing a local prototype of your application using Visual FoxPro tables, views, and databases to represent data accessed on a remote server.

Programming for Shared Access

Explains how programming for shared access makes it possible for you to create an application that will run on several machines in a network environment.

Visual FoxPro Data Access Using the OLE DB Provider

Describes the Visual FoxPro OLE DB Provider and how to access Visual FoxPro data from other languages and applications.


Reference (Visual FoxPro)

Includes Visual FoxPro general, programming language, user interface, and error message reference topics.

Related Sections

Developing Visual FoxPro Applications

Includes conceptual information about how to develop Visual FoxPro applications, instructions for creating databases and the user interface, and other tasks needed to create Visual FoxPro applications.

Application Planning

Stresses that careful planning saves time, effort, and money and that many of the decisions you make during the planning phase will impact how you create elements of the application.

Enhancing Applications Using SQL Pass-Through Technology

Describes how you can use SQL pass-through (SPT) technology to create objects on the server, run stored procedures on a remote server, and execute commands using native server syntax.

© , 1996-2020 • Updated: 11/10/20
Comment or report problem with topic