The Database Query dialog box enables you to set a Data Source (a Database Structure Descriptor) for your query, and Query Type.

Data sources

The Data Sources pull-down menu enables you to select a Database Structure Descriptor to be used. If you have not declared any DSDs, you should click the To Database Wizard… button and edit or create your DSDs.

Query Type

The Query Type pull-down menu enables you to select type of a SQL Query. A Database Query can be one of the following types:

DELETE Deletes one or more records from a Database. (See the Delete Command section.)
INSERT Adds a new record to a specified field of your database. (See the Insert Command section.)
SELECT Selects and displays records from a specified database. (See the Select Command section.)
UPDATE Updates records in a database. (See the Update Command section.)

After you have selected a Data Source and Query Type, click the Edit Query button to access the Query Properties dialog box and edit your query.