Share via


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

  • Reference (Visual FoxPro)
    Includes Visual FoxPro general, programming language, user interface, and error message reference topics.
  • 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.