View Service

From Apache OpenOffice Wiki
< Documentation‎ | DevGuide
Revision as of 12:51, 15 May 2009 by OOoWikiBot (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

A view is a virtual table created from a SELECT on other database tables or views. This service creates a database view programmatically. It is not necessary to know the SQL syntax for the CREATE VIEW statement, but a few properties have to be set. When creating a view, supply the value for the property Name, the SELECT statement to the property Command and if the database driver supports a check option, set it in the property CheckOption. Possible values of are NONE, CASCADE and LOCAL. A schema or catalog name can be provided (optional).

Content on this page is licensed under the Public Documentation License (PDL).
Personal tools
In other languages