The Query Properties dialog box enables you to set properties for a Database Query. Options displayed in this dialog box are based on the Query Type you have selected in the Database Query dialog box. For each type of query, there is a different set of tabs. These Query Types are:
Deletes one or more records from the Database, according to condition(s) you set.
If the Delete query is selected, the available tabs are:
Adds a new record to the specified table of the database.
If Insert query is selected, the available tab is:
Selects and displays records from a specified database. This will be based on
condition(s) you set in this dialog box.
If the Select query is selected, the available tabs are:
Update query
Updates records in the database based on condition(s) you set in this dialog box.
If you choose Update Query, the dialog box will contain:
If you choose Delete tab, the Tables drop-down list will be displayed. Use this to select an entire table where record(s) must be deleted.
The Insert tab includes two sections:
(i) the Tables drop-down list, where you can choose a table to insert records.
(ii) the Fields and Values section. In this section, you can assign values to
fields. To assign a value, select a field and click Edit. The Set Value dialog box will be displayed. Now set a value for
the selected field. If you want a field to be omitted in a query, select it and click Clear.
The Select tab includes three sections:
(i) the Tables drop-down list. You can use this to choose the table where the
record(s) must be selected
(ii) Available Fields
(iii) Selected Fields
The Available Fields section lists all the fields of the chosen table.
The Selected Fields section lists all fields you have selected in various tables.
These tables are contained or included in a current database, and they are listed in the
drop-down menu.
The fields you select and see in the Selected Fields section will be displayed in
the feedback on the web page.
If you want to select a field(s) in a current table, select it (them) in the Available
Fields section, and click Add >. The field(s) will be added to the Selected
Fields section.
If you want to select all fields of the current table, click Add All >>.
To remove a field(s) from your list of selected fields, select it (them) and click Remove
<.
If you want to remove all selected fields, click Remove All <<.
The Update tab includes the following sections:
(i) the Tables drop-down list where you can choose a table to update your
record(s).
(ii) the Fields and Values section where you can assign values to fields. To assign
value to a field, select the field and click Edit. The Set
Value dialog box will be displayed. Here you can set a value for the selected
field. If you want the field to be omitted from the query, select the field and click Clear.
The Order tab includes the following sections:
(i) the Tables drop-down list. Here you can choose a table you want. In this table,
select the fields you want your query to be ordered by.
(ii) Available Fields
(iii) Fields to Order By
The Available Fields section lists all the fields from the current table. The Fields to Order By section lists all fields from various tables. These fields will be used in the current query to show sorting order in the feedback on your web page. To select a field(s) from the current table, select it (them) in the Available Fields section, and click Add >. The field(s) will be added to the Fields to Order By section. If you want to add all the fields of the current table, click Add All >>. To remove a field(s) from the list displayed in the Fields to Order By section, click Remove <. If you want to remove all selected fields, click Remove All <<. The field name in the Fields to Order By section will have a small arrow to the left of its name. The direction of this arrow indicates whether the sorting will be ascending or descending. If the arrow points upward, the sorting will be ascending. If the arrow points downward, the sorting will be descending.
The Criteria tab includes Condition window and condition managing buttons/controls.
Building binary operations is necessary to perform your Query. The Condition window helps you perform binary operations of the current query. The operations will appear in a form of a logical tree. The operations will be logically connected by AND/OR binary operations. This method will let you to construct a very complex condition tree.
To add a logical operation at the same level as the selected object is, click Add
Logic. The Choose Logic Operation dialog box appears. Specify the AND and
OR logical operations.
To add a logical operation at the level higher than the selected object is, click Insert
Logic. The Choose Logic Operation dialog box appears. Choose between the AND
and OR logical operations.
To add a binary operation, click Add Condition. The Add
Condition dialog box appears. Set the binary operation. For example:
table_1.Field_1<>5
To delete a condition or a logic operation, select it in the condition window and click Delete.
To edit a condition or logic operation, select it and click Edit. The Choose
Logic Operation or Add Condition dialog box appears.
To see a selected item in SQL click Show SQL. The Part of SQL
Text dialog box appears where you can see a part of the SQL statement relevant to
condition you chose.
The Feedback tab enables you to customize the feedback properties in your query.
Select All Records to display all selected records from a database on one page.
Select Custom and enter a number of records to be displayed on a page. Pages are
provided with automatic navigation from one to another.