GIS ObjectLand. User Manual
previouscontentsnext / Windows / External databases / Property sheet "Properties of query" for EDB query

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

Purpose

This page of the property sheet “Properties of query” serves for editing of SQL statement SELECT which determines the query.

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.

See also

EDB tables

Building EDB query using SELECT statement

Properties of query on the basis of SELECT statement

previoustopnext