This dialog box permits creating and opening for browsing the EDB query based on direct specifying of SQL statement SELECT. Later on the user can catalog the browsed query having performed the command of saving it in the browser window.
Drop-down lists | Owner – a drop-down list of owners of components of external data source (if the source supports the notion of an owner); Table – a drop-down list of names of all tables of the present EDB. If the owner's name is specified, only the tables based on the data components which belong to this owner are displayed. Field – a drop-down list of names of all fields of selected table. |
Editing pane of SELECT statement | Intended for entering text specifying SELECT statement. To use names from lists in the text of SELECT statement it is necessary to place the input caret to the required place of the text which is being entered, select the name in the list of owners, tables or fields and then push one of the buttons When pushing the button When pushing the button |
OK | Sends the request to the data source with specified statement SELECT and opens a browser window of received EDB query. |
Cancel | Cancels the operation and closes the dialog box. |
Building EDB query using SELECT statement
“Properties of query” for EDB. Page “SQL”