Query Designer

The Query Designer is a powerful tool for creating and editing profile queries, intended for selecting or modifying table data. To design a new query double-click the Create query in design view item within the Profile Window | Queries page. To design the existing query select its name within the Profile Window | Queries page and click the Design button on the toolbar or in the popup menu.

The Query Designer window is divided into several tabs. The Designer tab is provided for adding tables to the query and selecting the columns, included into the query. The Options tab allows you to define various query properties, such as query name, type, description, etc. The Conditions tab allows you to define the criteria for SELECT, UPDATE, and DELETE queries. The Insert Values tab is intended for defining values in INSERT queries. The Columns tab contains various properties of the selected query columns: grouping and sorting for SELECT, or update values for UPDATE queries.

Please refer to topics to Designing Query Structure, Designing Query Conditions, Designing Query Values, and Designing Query Columns respectively for details.

Besides query graphical representation, Query Designer also provides you with the SQL View of the query. This view is accessible through the SQL View button and displays the SQL statement, generated by the designer, or edited manually by user. You can use this mode to view the query SQL before its execution, or to create complicate queries, which can't be designed by the standard means of Query Designer.

All changes made to the query design takes effect only after the Apply button is pressed. If you want to discard all changes and revert to the last saved query design, click Revert.