Difference between revisions of "Documentation/DevGuide/Database/View Service"
From Apache OpenOffice Wiki
< Documentation | DevGuide
OOoWikiBot (Talk | contribs) m (Robot: Changing Category:Database Access) |
OOoWikiBot (Talk | contribs) m (FINAL VERSION FOR L10N) |
||
(One intermediate revision by the same user not shown) | |||
Line 6: | Line 6: | ||
|NextPage=Documentation/DevGuide/Database/Group Service | |NextPage=Documentation/DevGuide/Database/Group Service | ||
}} | }} | ||
− | {{DISPLAYTITLE:View Service}} | + | {{Documentation/DevGuideLanguages|Documentation/DevGuide/Database/{{SUBPAGENAME}}}} |
+ | {{DISPLAYTITLE:View Service}} | ||
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 <code>Command</code> and if the database driver supports a check option, set it in the property <code>CheckOption</code>. Possible values of <idl>com.sun.star.sdbcx.CheckOption</idl> are <code>NONE</code>, <code>CASCADE</code> and <code>LOCAL</code>. A schema or catalog name can be provided (optional). | 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 <code>Command</code> and if the database driver supports a check option, set it in the property <code>CheckOption</code>. Possible values of <idl>com.sun.star.sdbcx.CheckOption</idl> are <code>NONE</code>, <code>CASCADE</code> and <code>LOCAL</code>. A schema or catalog name can be provided (optional). | ||
Line 13: | Line 14: | ||
{{PDL1}} | {{PDL1}} | ||
− | [[Category:Documentation/ | + | [[Category:Documentation/Developer's Guide/Database Access]] |
Latest revision as of 12:51, 15 May 2009
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). |