The Query Properties dialog box enables you to set properties for a Database Query. Options displayed in this dialog box depend 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. The Query Types are:
Deletes one or more records from your Database, according to condition(s) you set.
If Delete query is selected, the available tabs are:
Adds a new record to a specified table of your 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 choose in this dialog box.
If Select query is selected, the available tabs are:
Updates records in your database depending on condition(s) you choose in this dialog box.
If you choose Update Query, the dialog box contains:
If you choose the Delete tab, the Tables drop-down list will be displayed. Choose a table you want to delete record(s) from.
The Insert tab includes two sections: (i) the Tables drop-down list,
where you can choose a table to insert records into; (ii) the Fields and Values
section, where 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
the query, select the field and click Clear.
The Select tab
The Select tab includes three sections: (i) the Tables drop-down list, where you can choose a table to select record(s) from; (ii) Available Fields, and (iii) Selected Fields.
The Available Fields section lists all fields from a chosen table. The Selected
Fields section lists all fields you have selected from various tables. These are the
tables that are contained or included in a current database. These tables are the ones
listed in the drop down menu. Fields you select and see in the selection field section
will be displayed in a feedback on your web page. If you want to select field(s) from your
current table, select it 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 your current table, click Add All >>. To remove field(s)
from your list of selected fields, select it and click Remove <. If you want to
remove all of your selected fields, click Remove All <<.
The Update tab
The Update tab includes the following sections: (i) the Tables drop-down
list, where you can choose a table to update your record(s), and (ii) the Fields and
Values section. In this section you can assign values to your fields. To set a 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 a field to be omitted from your query, select the field and click Clear.
The Order tab
The Order tab includes the following sections: (i) the Tables drop-down list, where you can choose a table you want. In this table, select fields you want your query to be ordered by; (ii) the Available Fields and (iii) the Fields to Order By.
The Available Fields section lists all fields of the current table. The Fields
to Order By section lists all the fields you chose from various tables. These
fields will be used in a current query to show a sorting order in a feedback on your web
page. To select field(s) from a current table, select it 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 fields of your current table, click Add All
>>. To remove field(s) from a list displayed in the Fields to Order By
section, click Remove <. If you want to remove all selected fields, click Remove
All <<. A field name in the Fields to Order By section will have a small
arrow to its left. The direction of this arrow indicates whether your 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
The Criteria tab includes the Condition window and condition managing buttons/controls.
The Condition window displays binary operations of your current query. The query will be performed if the conditions are satisfied. You must build the binary operations. These will be displayed in a form of a logical tree. The operations are logically connected by the AND/OR binary operations. These enable you to construct a very complex condition tree.
To add a logical operation at the same level with a selected object, click Add Logic.
The Choose Logic Operation dialog box will be displayed. Here you can specify AND
and OR logical operations. To add a logical operation at a level higher than a selected
object, click Insert Logic. The Choose Logic Operation dialog box will be
displayed. Here you can choose between the AND and OR logical operations. To add a binary
operation, click Add Condition. The Add Condition
dialog box will be displayed. Here you can set the binary operation. For example:
table_1.Field_1<>5
To delete a condition or a logic, select it in the condition window and click Delete.
To edit a condition or a logic, select it and click Edit. Either the Choose Logic
Operation or the Add Condition dialog box will be displayed.
The Feedback tab
The Feedback tab enables you to customize feedback properties of your query.
The Style section enables you to choose whether a feedback will be displayed in
a Table or List format. In the Result Portion you can enter a number
of records to be displayed for each feedback on your web page.
The Show Image As section provides you with two options. (i) One option displays
images included in a feedback as Embedded objects. (ii)The other option
displays links to them. (Linked). The Enumeration check box is available
only for the List feedback. It toggles on/off enumeration of query results on your
web page.
The Fields Caption check box is available only for the List feedback. It toggles
on/off display of field captions in a feedback.
The Border check box toggles on/off display of borders in a feedback table in
your web page.
The Alignment section enables you to set alignment of data columns of a
feedback table displayed on your web page.