<html> <head> <title>Constants' Group KeyRule</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="navimainnone">Use</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"><a href="#Constants" class="navisub">Constants</a></td> <td class="navisub"><a href="#ConstantDetails" class="navisub">Constants' 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">sdbc</a> :: </p> </td> </tr> <tr> <td class="title">constants group KeyRule</td> </tr> <tr> <td><dl> <dt><b>Description</b></dt> <dd>determines the rules for foreign key constraints. </dd> </dl> </td> </tr> </table> <hr> <a name="Constants"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Constants</td> </tr> <tr> <td class="imsum_left"><a href="#CASCADE">CASCADE</a></td> <td class="imsum_right">a possible value for the column's <code>UPDATE_RULE</code> and <code>DELETE_RULE</code> in the <a href="XResultSet.html">XResultSet</a> objects returned by the methods <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getImportedKeys">getImportedKeys()</a> , <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getExportedKeys">getExportedKeys()</a> , and <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getCrossReference">getCrossReference()</a> . </td> </tr> <tr> <td class="imsum_left"><a href="#RESTRICT">RESTRICT</a></td> <td class="imsum_right">a possible value for the column's <code>UPDATE_RULE</code> and <code>DELETE_RULE</code> in the <a href="XResultSet.html">XResultSet</a> objects returned by the methods <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getImportedKeys">getImportedKeys()</a> , <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getExportedKeys">getExportedKeys()</a> , and <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getCrossReference">getCrossReference()</a> . </td> </tr> <tr> <td class="imsum_left"><a href="#SET_NULL">SET_NULL</a></td> <td class="imsum_right">a possible value for the column's <code>UPDATE_RULE</code> and <code>DELETE_RULE</code> in the <a href="XResultSet.html">XResultSet</a> objects returned by the methods <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getImportedKeys">getImportedKeys()</a> , <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getExportedKeys">getExportedKeys()</a> , and <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getCrossReference">getCrossReference()</a> . </td> </tr> <tr> <td class="imsum_left"><a href="#NO_ACTION">NO_ACTION</a></td> <td class="imsum_right">a possible value for the column's <code>UPDATE_RULE</code> and <code>DELETE_RULE</code> in the <a href="XResultSet.html">XResultSet</a> objects returned by the methods <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getImportedKeys">getImportedKeys()</a> , <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getExportedKeys">getExportedKeys()</a> , and <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getCrossReference">getCrossReference()</a> . </td> </tr> <tr> <td class="imsum_left"><a href="#SET_DEFAULT">SET_DEFAULT</a></td> <td class="imsum_right">a possible value for the column's <code>UPDATE_RULE</code> and <code>DELETE_RULE</code> in the <a href="XResultSet.html">XResultSet</a> objects returned by the methods <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getImportedKeys">getImportedKeys()</a> , <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getExportedKeys">getExportedKeys()</a> , and <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getCrossReference">getCrossReference()</a> . </td> </tr> </table> <a name="ConstantDetails"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle">Constants' Details</td> </tr> <tr> <td class="imdetail"><a name="CASCADE" class="membertitle">CASCADE</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>CASCADE</b> = 0;<hr> <dl> <dt><b>Description</b></dt> <dd>a possible value for the column's <code>UPDATE_RULE</code> and <code>DELETE_RULE</code> in the <a href="XResultSet.html">XResultSet</a> objects returned by the methods <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getImportedKeys">getImportedKeys()</a> , <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getExportedKeys">getExportedKeys()</a> , and <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getCrossReference">getCrossReference()</a> . </dd> <dd><P> For the column <code>UPDATE_RULE</code> , it indicates that when the primary key is updated, the foreign key (imported key) is changed to agree with it. </P> <P> For the column <code>DELETE_RULE</code> , it indicates that when the primary key is deleted, rows that imported that key are deleted. </P> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="RESTRICT" class="membertitle">RESTRICT</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>RESTRICT</b> = 1;<hr> <dl> <dt><b>Description</b></dt> <dd>a possible value for the column's <code>UPDATE_RULE</code> and <code>DELETE_RULE</code> in the <a href="XResultSet.html">XResultSet</a> objects returned by the methods <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getImportedKeys">getImportedKeys()</a> , <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getExportedKeys">getExportedKeys()</a> , and <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getCrossReference">getCrossReference()</a> . </dd> <dd><P> For the column <code>UPDATE_RULE</code> , it indicates that a primary key may not be updated if it has been imported by another table as a foreign key. </P> <P> For the column <code>DELETE_RULE</code> , it indicates that a primary key may not be deleted if it has been imported by another table as a foreign key. </P> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="SET_NULL" class="membertitle">SET_NULL</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>SET_NULL</b> = 2;<hr> <dl> <dt><b>Description</b></dt> <dd>a possible value for the column's <code>UPDATE_RULE</code> and <code>DELETE_RULE</code> in the <a href="XResultSet.html">XResultSet</a> objects returned by the methods <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getImportedKeys">getImportedKeys()</a> , <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getExportedKeys">getExportedKeys()</a> , and <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getCrossReference">getCrossReference()</a> . </dd> <dd><P> For the columns <code>UPDATE_RULE</code> and <code>DELETE_RULE</code> , it indicates that when the primary key is updated or deleted, the foreign key (imported key) is changed to <code>NULL</code>. </P> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="NO_ACTION" class="membertitle">NO_ACTION</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>NO_ACTION</b> = 3;<hr> <dl> <dt><b>Description</b></dt> <dd>a possible value for the column's <code>UPDATE_RULE</code> and <code>DELETE_RULE</code> in the <a href="XResultSet.html">XResultSet</a> objects returned by the methods <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getImportedKeys">getImportedKeys()</a> , <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getExportedKeys">getExportedKeys()</a> , and <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getCrossReference">getCrossReference()</a> . </dd> <dd><P> For the columns <code>UPDATE_RULE</code> and <code>DELETE_RULE</code> , it indicates that if the primary key has been imported, it cannot be updated or deleted. </P> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="SET_DEFAULT" class="membertitle">SET_DEFAULT</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>SET_DEFAULT</b> = 4;<hr> <dl> <dt><b>Description</b></dt> <dd>a possible value for the column's <code>UPDATE_RULE</code> and <code>DELETE_RULE</code> in the <a href="XResultSet.html">XResultSet</a> objects returned by the methods <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getImportedKeys">getImportedKeys()</a> , <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getExportedKeys">getExportedKeys()</a> , and <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getCrossReference">getCrossReference()</a> . </dd> <dd><P> For the columns <code>UPDATE_RULE</code> and <code>DELETE_RULE</code> , it indicates that if the primary key is updated or deleted, the foreign key (imported key) is set to the default value. </P> </dd> </dl> </td> </tr> </table> </td> </tr> </table> <a href="#_top_">Top of Page</a><hr size="3"><p class="copyright" align="center">Copyright © 2000, 2012 LibreOffice contributors and/or their affiliates. All rights reserved.</p><p class="copyright" align="center">LibreOffice was created by The Document Foundation, based on OpenOffice.org, which is Copyright 2000, 2010 Oracle and/or its affiliates.</p><p class="copyright" align="center">The Document Foundation acknowledges all community members, please find more info <a href="http://www.libreoffice.org/about-us/credits/" target="_blank">at our website</a>.<p> </p><p class="copyright" align="center"><a href="http://www.libreoffice.org/privacy" target="_blank">Privacy Policy</a> | <a href="http://www.libreoffice.org/imprint" target="_blank">Impressum (Legal Info)</a> | Copyright information: The source code of LibreOffice is licensed under the GNU Lesser General Public License (<a href="http://www.libreoffice.org/download/license/" target="_blank">LGPLv3</a>). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our <a href="http://wiki.documentfoundation.org/TradeMark_Policy" target="_blank">trademark policy</a>.</p> </div> <!-- id="adc-idlref" --> </body> </html>
