CREATE QUERY

Topic group Related topics

Opens a new or existing query in the SQL designer.

Syntax

CREATE QUERY [<filename> | ? | <filename skeleton>]

<filename> | ? | <filename skeleton>

The SQL query file to create or modify. The default extension is .SQL. The ? and <filename skeleton> options display a dialog box from which you can select a file. If you specify a file without including its path, dBASE Plus looks for the file in the current directory. If you issue CREATE QUERY without an option, dBASE Plus creates an untitled SQL query file.

Description

Use CREATE QUERY to open the SQL designer and create new or edit existing SQL queries. The SQL designer automatically generates an SQL statement that defines the query, and stores this statement in an editable source code file with a .SQL extension. The .SQL file can be run directly from the Navigator or used as the sql property of a Query object.

If you're creating a new SQL query file, CREATE QUERY displays an empty design surface. If you specify an existing file, dBASE Plus asks whether you want to modify it. If you reply no, nothing further happens. Use the MODIFY QUERY command to edit an existing file without being asked whether you want to modify it.