Partager via


Working with Queries

When your application includes tables, you can select and display data from those tables using queries. You can use queries for various tasks:

  • Answering a question quickly. For example, you can find out information such as:

    • Customer name and address associated with a particular ID number

    • Number of outstanding orders

    • Number of customers with overdue balances

    • Region or salesperson with the best sales record

  • Viewing a relevant subset of your data

  • Organizing and generating data for a report. You can also run reports separately without using a query.

You can create queries from tables, define and organize query results, collect user input using queries, and customize queries. You can also direct queries to different destinations so that you can use them in other parts of your application.

In This Section

  • Working with Data
    Provides an overview and information about using data in your applications, for example, analyzing data requirements and designing your application components to meet those requirements.

  • Working with Tables (Visual FoxPro)
    Discusses how to structure your tables to meet your application requirements. 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.

  • Working with Views (Visual FoxPro)
    Explains how to use views to create a customized updateable data set for your application.