Mirror views

Mirror views create aliases of a table-view with an optional extension applied to all the columns.

The aliases can be used in different situations. One of the most common is whan a record needs to be connected to more that one record of the same table.

Selection views

The selection views apply a WHERE clause to the table, with an automatic filter on rhe records.

Manual views

In the manual views, the SELECT statement is created by the developer, and can be in any form.

The statement is anyway included in a schema, that once created can have the same properties of a table schema, including connections, and can be used in any part of the program in the same way.

This kind of view can be used in many cases, for example to show a record twice.

Complex views

The complex views are one of the most powerful features of CrossModel.

These views include two or more different table or views, and still they can be inserted or updated like a single table, thanks to the insert-update stored procedures.