The property sheet of EDB query build by constructive method serves for viewing and changing query properties: the condition of searching records in query, sorting records, presence and type of calculated fields, the scheme of table join in a query, request modes to the data source and permissions of the current user to the query.
The data in this property sheet is organized as a set of pages. To display the necessary page it is required to click the corresponding tab.
Condition of searching records in a query. | |
Condition of sorting records of EDB query, disabling or enabling display of duplicated records in a query. | |
Viewing and changing calculated fields for a query. | |
Viewing and changing the scheme of table join in a query. | |
Parameters of request to an external data source used to get the resultant set of records of the query. | |
The possibility for the user to perform basic types of actions when browsing the query. |
OK | Confirms changes of properties and closes the property sheet. |
Cancel | Cancels changes of properties and closes the property sheet. |
Properties of a query build constructively
Properties common for queries of both types