CREATE QUERY opens the Query designer so you can interactively create a query.

A SQL SELECT command is used to retrieve data from tables. SELECT is very powerful and can replace a series of Visual FoxPro commands. Because one SQL SELECT performs the function of a series of Visual FoxPro commands, SELECT optimizes program performance.

Think of SELECT as a way to pose a query to Visual FoxPro to obtain information from tables. SELECT allows you to specify the information you want without telling Visual FoxPro how to retrieve the information. Visual FoxPro determines the best way to retrieve the information.

After you create a query, the query is stored as a Visual FoxPro program file with a .qpr extension. A query program can be executed with DO. You must include the query file extension when executing a query with DO, as shown in the following example.

	Copy Code
DO my_query.qpr

Issuing the command CREATE QUERY without any additional arguments opens a new query window. The name QUERY1 is assigned to the query. When you exit the Query window, you can save the query with a different name.

Reference

Other Resources