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

Page “Changing SQL expression”

Purpose

This page of the wizard of adding/changing an EDB table serves for viewing and, if necessary, manual modifying text of SQL expression generated by the system as a result of previous steps of the wizard.

Panes

SQL statements

Contains a list of SQL statements which will be sent to the data source server to execute actions performing adding/changing the EDB table in accordance with the table's parameters specified at the previous steps of the wizard.

Description – verbal description of actions performed by the corresponding statement.

Modified – indicates whether the text of the statement was modified by manual editing in the pane SQL expression of this very page of wizard.

There is a button in the pane:

Reset all – cancels all modifications of the statements' text made in the pane SQL expression and assigns the value No to signs Modified.

SQL expression

Contains text of the SQL statement selected in the pane SQL statements.

If the box Change generated SQL expression is checked then the statement text can be edited manually (the user is supposed to be experienced in SQL language). In this case, the user modifying the statement text takes up responsibility for preservation of integrity of the data and for correctness of its processing.

Editing pane contains text of the statement. First part of the statement including its title and a part of parameters is displayed above the pane and can not be changed. The remaining text (additional parameters of the statement) is displayed in the pane and can be changed if the box described above is checked.

Button Execute

Pushing this button sends SQL statements to the data source server for executing operations of creating or modifying the table.

See also

Adding EDB table as a base table in data source

previoustopnext