GIS ObjectLand. User Manual
previouscontentsnext / Windows / External databases / Dialog boxes

Dialog box “Search” for EDB

Purpose

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.

Panes

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 or .

When pushing the button the name from the corresponding list will be inserted into the position of the input caret.

When pushing the button a qualified name will be inserted into the position of the input caret: for a table it will be <owner's name>.<table name>, for a field – <owner's name>.<table name>.<field name>. Owner's name is present only for the data sources which support this notion.

Buttons

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.

See also

Building EDB query using SELECT statement

“Properties of query” for EDB. Page “SQL”

previoustopnext