<html> <head> <title>Service View</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <link rel="stylesheet" type="text/css" href="../../../../idl.css"> </head> <body> <div id="adc-idlref"> <a name="_top_"> </a><table class="navimain" border="0" cellpadding="3"> <tr> <td class="navimain"><a href="../module-ix.html" class="navimain">Overview</a></td> <td class="navimain"><a href="module-ix.html" class="navimain">Module</a></td> <td class="navimain"><a href="View-xref.html" class="navimain">Use</a></td> <td class="navimainnone">Devguide</td> <td class="navimain"><a href="../../../../index-files/index-1.html" class="navimain">Index</a></td> </tr> </table> <table class="navisub" border="0" cellpadding="0"> <tr> <td class="navisub">Services' Summary</td> <td class="navisub"><a href="#InterfacesSummary" class="navisub">Interfaces' Summary</a></td> <td class="navisub"><a href="#PropertiesSummary" class="navisub">Properties' Summary</a></td> <td class="navisub">Services' Details</td> <td class="navisub"><a href="#InterfacesDetails" class="navisub">Interfaces' Details</a></td> <td class="navisub"><a href="#PropertiesDetails" class="navisub">Properties' Details</a></td> </tr> </table> <hr> <table border="0" width="100%" cellpadding="5" cellspacing="3" class="title-table" style="margin-bottom:6pt;"> <tr> <td><p class="namechain"><a href="../../../../module-ix.html" class="namechain">::</a> <a href="../../../module-ix.html" class="namechain">com</a> :: <a href="../../module-ix.html" class="namechain">sun</a> :: <a href="../module-ix.html" class="namechain">star</a> :: <a href="module-ix.html" class="namechain">sdbcx</a> :: </p> </td> </tr> <tr> <td class="title">service View</td> </tr> <tr> <td><dl> <dt><b>Description</b></dt> <dd>is used to specify views on data. A view object is only used for creation and deletion. Inspecting the command of a view is normally not supported. </dd> <dd><p> If a view is going to be added to a database, the view must have a unique name within the view and the table container, as it can be used like a table. <b> Note: </b> After addition, both the containers for views and the container for tables must contain an element for the view. </p> </dd> </dl> </td> </tr> </table> <hr> <a name="InterfacesSummary"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Exported Interfaces - Summary</td> </tr> <tr> <td class="imsum_left"><a href="XRename.html">XRename</a></td> <td class="imsum_right"><p>is optional for implementation. (<a href="#XRename">details</a>)</p> </td> </tr> <tr> <td class="imsum_left">::com::sun::star::<a href="../beans/module-ix.html">beans</a>::<a href="../beans/XPropertySet.html">XPropertySet</a></td> <td class="imsum_right"><dl> <dt>(referenced entity's summary:)</dt> <dd>provides information about and access to the properties from an implementation. </dd> </dl> </td> </tr> <tr> <td class="imsum_left"><a href="XAlterView.html">XAlterView</a></td> <td class="imsum_right"><p>allows changing the view's <a href="View.html#Command">Command</a>. (<a href="#XAlterView">details</a>)</p> </td> </tr> </table> <a name="PropertiesSummary"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Properties' Summary</td> </tr> <tr> <td class="imsum_left">[ readonly ] string<br> <a href="#Name">Name</a></td> <td class="imsum_right">is the name of the view. </td> </tr> <tr> <td class="imsum_left">[ readonly ] string<br> <a href="#CatalogName">CatalogName</a></td> <td class="imsum_right">is the name of the views catalog, may be empty. </td> </tr> <tr> <td class="imsum_left">[ readonly ] string<br> <a href="#SchemaName">SchemaName</a></td> <td class="imsum_right">is the name of the view's schema, may be empty. </td> </tr> <tr> <td class="imsum_left">[ readonly ] string<br> <a href="#Command">Command</a></td> <td class="imsum_right">is the command for creating the view. </td> </tr> <tr> <td class="imsum_left">[ readonly ] long<br> <a href="#CheckOption">CheckOption</a></td> <td class="imsum_right">indicates if a check option should be used for the view. </td> </tr> </table> <a name="InterfacesDetails"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Exported Interfaces - Details</td> </tr> <tr/> <tr> <td class="imdetail"><a name="XRename" class="membertitle"><a href="XRename.html">XRename</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt><b>Usage Restrictions</b></dt> <dd><i>optional</i></dd> <dt><b>Description</b></dt> <dd>is optional for implementation. </dd> </dl> </td> </tr> </table> </td> </tr> <tr/> <tr> <td class="imdetail"><a name="XPropertySet" class="membertitle">::com::sun::star::<a href="../beans/module-ix.html">beans</a>::<a href="../beans/XPropertySet.html">XPropertySet</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt>(referenced entity's summary:)</dt> <dd>provides information about and access to the properties from an implementation. </dd> </dl> </td> </tr> </table> </td> </tr> <tr/> <tr> <td class="imdetail"><a name="XAlterView" class="membertitle"><a href="XAlterView.html">XAlterView</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt><b>Usage Restrictions</b></dt> <dd><i>optional</i></dd> <dt><b>Description</b></dt> <dd>allows changing the view's <a href="View.html#Command">Command</a>. </dd> </dl> </td> </tr> </table> </td> </tr> </table> <a name="PropertiesDetails"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle">Properties' Details</td> </tr> <tr> <td class="imdetail"><a name="Name" class="membertitle">Name</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>[ readonly ] string <b>Name</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>is the name of the view. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="CatalogName" class="membertitle">CatalogName</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>[ readonly ] string <b>CatalogName</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>is the name of the views catalog, may be empty. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="SchemaName" class="membertitle">SchemaName</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>[ readonly ] string <b>SchemaName</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>is the name of the view's schema, may be empty. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="Command" class="membertitle">Command</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>[ readonly ] string <b>Command</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>is the command for creating the view. </dd> <dd><p>This is typically a SQL Select-Statement.</p> <p>This property might be empty when a backend does not support retrieving the current SQL command of a view. However, if the <code>View</code> supports altering its command via the <a href="#XAlterView">XAlterView</a> interface, then it's required to also provide the current SQL command in the <code>Command</code> property.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="CheckOption" class="membertitle">CheckOption</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>[ readonly ] long <b>CheckOption</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>indicates if a check option should be used for the view. </dd> <dt><b>See also</b></dt> <dd><a href="CheckOption.html">CheckOption</a></dd> </dl> </td> </tr> </table> </td> </tr> </table> <br> <a href="#_top_">Top of Page</a><hr size="3"><p class="copyright" align="center">Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.</p> </div> <!-- id="adc-idlref" --> </body> </html>