Difference between revisions of "Documentation/DevGuide/Database/View Service"
From Apache OpenOffice Wiki
< Documentation | DevGuide
m (1 revision(s)) |
OOoWikiBot (Talk | contribs) m (Robot: Changing Category:Database Access) |
||
Line 12: | Line 12: | ||
{{PDL1}} | {{PDL1}} | ||
− | [[Category: Database Access]] | + | |
+ | [[Category:Documentation/Developers Guide/Database Access]] |
Revision as of 11:52, 4 June 2008
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 com.sun.star.sdbcx.CheckOption 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). |