Difference between revisions of "Documentation/DevGuide/Database/View Service"
From Apache OpenOffice Wiki
< Documentation | DevGuide
(Initial author Sun Microsystems, Inc.) |
OOoWikiBot (Talk | contribs) m (FINAL VERSION FOR L10N) |
||
| (3 intermediate revisions by 2 users 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 12: | Line 13: | ||
{{PDL1}} | {{PDL1}} | ||
| − | [[Category: Database Access]] | + | |
| + | [[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). |
