On the View Properties page select the database, to which the view, the view's physical name and view query's text are added:
Determine the following parameters on this page:
Database. Select the database in the drop-down list. The driver specified in settings of the selected database is set automatically on changing a database.
Physical Name. By default, table identifier is used as the physical name of the table.
Permit an Incorrect View to Be Created. The checkbox is deselected by default.Select it to permit creation of a view with an incorrect query.
Saved View. Selecting this checkbox enables the user to work both with view data and with data of a standard table. When the checkbox is selected, editing view data does not result in changing data of basic tables. When data of the basic tables is changed, view contents is not refreshed. Indexes can be created for a saved view.
NOTE. Unable to create a view, which is saved incorrectly.
Driver. Select the driver type in the drop-down list. For details about available drivers see the Supported DBMS section. The Driver list displays by default the driver used in the selected database. If required, it is available to select another driver and determine the SQL query text for this driver. The parameter is relevant if the repository is used on servers with different DBMS, and settings in repository database are changed.
Query Text. Generate an SQL query in this field. The view is to be built based on this query.
Apply to All DBMS. The button determines query text for all databases, that is, changing the driver does not affect query text. Clicking this button returns a request to confirm the operation. Answer Yes to set query text for all databases. Confirmation is required if at least one driver other than the current one, has non-empty query text.
See also: