View

Reference documentation for a View object

Overview

A View object represents an individual table view in a Database Server. A database table view, often simply referred to as a "view," is a virtual or logical table generated by a query on one or more database tables. Users or applications can then query the view as if it were a regular table, even though it does not store any data itself.

Properties Summary

The following properties can be configured for a View object:

Property	Summary
hiddenInDeveloper	Use this property to hide the view from the Servoy Developer environment
isMetadataTable	Returns whether table was flagged as metadata view

Events Summary

The following events can be handled for a View object.

Property	Summary
onRecordInsert	occurs prior to a new record being inserted into the table
onRecordUpdate	occurs prior to an existing record being updated in the database
onRecordDelete	occurs prior to an existing record being deleted from the database
afterRecordInsert	occurs subsequent to a new record being inserted into the table
afterRecordUpdate	occurs subsequent to an existing record being updated in the database
afterRecordDelete	occurs subsequent to an existing record being deleted from the database
onFoundSetRecordCreate	occurs prior to a new record being created in the foundset
onFoundSetFind	occurs prior to the foundset going into find mode
onFoundSetSearch	occurs prior to executing a search on the foundset
afterFoundSetRecordCreate	occurs subsequent to the creation of a new record
afterFoundSetFind	occurs subsequent to entering find mode
afterFoundSetSearch	occurs subsequent to performing the search for a foundset
onValidate	occurs before an insert operation, it can block the insert operation by returning false

Properties Details

See Table Properties Details.

Events Details

See Table Events Details.

Column

See Table Column.

Calculation

See Table Calculation.

Method

See Table Method.

Aggregration

See Table Aggregration.