Setting Query Output Destinations
The following table describes destinations for query output.
| Output option | Destination |
|---|---|
Browse |
Display the results of the query in a browse window. |
Cursor |
Save the results of the query in a temporary read-only table with a name that you specify. |
Table |
Save the results of the query as a table with a name that you specify. |
Screen |
Display the results of the query in the main Visual FoxPro window or in the currently active output window. |
In This Section
- How to: Choose a Query Output Destination
Describes how to specify the destination to send query results to, such as a cursor, table, or screen.
- How to: Store Query Results in a Table, Array, or Cursor
Explains how to story your query results in a table, array, or cursor.
- How to: Populate Query Results in a Form Control
Describes how to use query results to populate a control on a form, such as a list box control, combo box control, or grid control.
- How to: Print Query Results in a Report or Label
Explains how to send query results to an existing report or label.
- How to: Display Query Results in a Window
Explains how to display query results in a window, such as the default browse window or the main Visual FoxPro window.
Reference
- Browse Window
Display records in an active window.
- SELECT - SQL Command
Retrieve data form one or more tables.
- Query Destination Dialog Box
Make it possible for you to send the results of your query to seven different outputs. This command is available only for queries.
Related Sections
- Working with Queries
Describes how to use queries to select and display data from tables or views.
- How to: Organize Query Results
Describes how you can organize the data results appearing in the query output.
- How to: Customize Queries
Describes ways to customize queries in the Query Designer, such as narrowing or expanding queries, eliminating duplicate queries, extracting percentage of top records, and adding expressions for filtering.
- How to: Query Multiple Tables and Views
Describes how to create queries from multiple tables.
- How to: Update Data in a View
Describes how to update data in views and their base tables.
- How to: Create Queries (Visual FoxPro)
Describes the different methods you can use to create queries.