+---------------------------------+
|          CREATE QUERY           |
+---------------------------------+
CREATE QUERY [<file> | ?]

-----------------------------------
Opens RQBE window.
-----------------------------------

The CREATE QUERY command opens an RQBE window so you can interactively
create a query (SQL SELECT command).  All you need to do is specify
settings in the RQBE window and FoxPro takes care of the rest.

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

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

After you create a query, the query is stored as a FoxPro program file
with a .QPR extension.  A query program can be executed with the DO
command.

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

Clauses
-------

<file> | ?
        Creates query with name <file> or displays Save As dialog.

-----------------------------------

See also:  MODIFY QUERY, SELECT - SQL, SQL

-----------------------------------