JavaScript Editor js editor     Web development 



Main Page

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


Describes the different methods you can use to create queries.


JavaScript Editor js editor     Web development