GIS ObjectLand. User Manual
previouscontentsnext / Windows / External databases / Wizard of adding EDB table based on a view of an external source

Page “Query”

Purpose

This page of the wizard of adding/changing an EDB table as a VIEW allows viewing and changing of the search condition for the records included into the view.

Panes

List of simple conditions

The pane contains the list of lines each of which corresponds to a simple condition in the search condition.

Simple condition

The pane of simple condition serves for entering and editing simple conditions making part of search condition.

Radio buttons Logical operator serve for specifying the logical operator connecting simple conditions. If the search condition consists of one simple condition, the radio button No should be checked. If the search condition is made up of several simple conditions, the radio button No should be checked only for the first simple condition making part of search condition.

The drop-down list Field serves for selecting the name of the table field for which simple condition is specified.

The drop-down list Relation serves for specifying a relation in the simple condition. The offered list of possible relations depends on the type of the table field for which simple condition is specified.

The presence of input fields 1st operand and 2nd operand depends on the relation of the simple condition being specified.

Buttons

The buttons serve for placing parentheses in the expression for the search condition. The “+” buttons add an opening parenthesis, the “” buttons remove it.

Add

The button Add serves for adding the simple condition specified in the pane “Simple condition” in search condition.

Change

When pushing the button Change the simple condition specified in simple condition pane will replace the condition selected in the condition pane.

Remove

The button Remove allows removing the simple condition selected in the condition pane.

Clear

The button Clean cleans the contents of the condition pane, that is, removes all simple conditions.

See also

Searching records in a table

Adding EDB table as a view in data source

previoustopnext