+---------------------------------+
|          MODIFY QUERY           |
+---------------------------------+
MODIFY QUERY [<file> | ?]
        [NOWAIT]

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

The MODIFY QUERY command lets you interactively modify an existing query
or create a new query in an RQBE window.

FoxPro makes it easy for you to create or modify a query (an SQL SELECT
command).  All you need to do is specify settings in the RQBE window and
FoxPro takes care of the rest.

SQL is an advanced relational database language that is used to define,
manipulate and control relational databases.

FoxPro currently includes the SQL command, SELECT, that 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.

Clauses
-------

<file>
        An existing query may be modified by including the name of the query
<file>.  If the file name you include doesn't exist or cannot be found,
a new query may be created.

        Issuing the command MODIFY QUERY without any additional arguments opens
a RQBE window where you may create a new query.  The name "UNTITLED" is
temporarily assigned to the query.  When you exit the RQBE window you
may save the query with a different name.  After you have created a
query, the query is stored as a FoxPro program file with a .QRY
extension.  A query program may be executed with the DO command.

?
        If you include ? the Open File dialog appears displaying a list of
existing query files to choose from, or you can enter the name of a new
file to create.

NOWAIT
        When the MODIFY QUERY command is issued from within a program, an RQBE
window is opened and program execution is suspended until the RQBE
window is closed.  Including the NOWAIT option continues program
execution after the RQBE window has been opened.  The program doesn't
wait for the RQBE window to be closed, but continues executing on the
program line immediately following that containing the MODIFY QUERY
NOWAIT command.

        This option is available only from within programs.  Including the
NOWAIT option has no effect on the MODIFY QUERY command when it is
issued from the Command window.

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

See Also:  CREATE QUERY, SELECT - SQL, SQL

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