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.