<html> <head> <title>Service SingleSelectQueryAnalyzer</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="SingleSelectQueryAnalyzer-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">Included Services</td> <td class="navisub"><a href="#ExportedInterfaces" class="navisub">Exported Interfaces</a></td> <td class="navisub">Properties' Summary</td> <td class="navisub">Properties' Details</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">sdb</a> :: </p> </td> </tr> <tr> <td class="title"><table class="title-table" width="99%"> <tr> <td width="25%" class="title2">unpublished </td> <td width="50%" class="title">service SingleSelectQueryAnalyzer</td> <td width="*"/></tr> </table> </td> </tr> <tr> <td><dl> <dt><b>Description</b></dt> <dd>represents a service for analyzing a single select statement. </dd> <dd><p> It hides the complexity of parsing and evaluating a single select statement and provides sophisticated methods for accessing a statements filter, group by, having and order criteria, as well as the corresponding select columns and tables. If supported, it even gives access to the parameters. </p> </dd> <dt><b>See also</b></dt> <dd><a href="SingleSelectQueryComposer.html">SingleSelectQueryComposer</a></dd> </dl> </td> </tr> </table> <hr> <a name="ExportedInterfaces"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Exported Interfaces</td> </tr> <tr> <td class="imsum_left"><a href="XSingleSelectQueryAnalyzer.html">XSingleSelectQueryAnalyzer</a></td> <td class="imsum_right"><dl> <dt>(referenced entity's summary:)</dt> <dd>simplifies the analyzing of single select statements. </dd> </dl> </td> </tr> <tr> <td class="imsum_left">::com::sun::star::<a href="../sdbcx/module-ix.html">sdbcx</a>::<a href="../sdbcx/XTablesSupplier.html">XTablesSupplier</a></td> <td class="imsum_right"><dl> <dt><b>Description</b></dt> <dd>access to the selected tables. </dd> <dd><p>The selected tables are those present in the <code>FROM</code> part of a <code>SELECT</code> statement.</p> <p>Note that OpenOffice.org since version 2.0.4 also supports queries which are based on other queries. For example, given that you have a database containing a query named <code>All Orders</code>, the SQL statement <code>SELECT * FROM "All Orders"</code> is perfectly valid when used with a <a href="SingleSelectQueryAnalyzer.html">SingleSelectQueryAnalyzer</a>.</p> <p>In this case, the name container returned by ::com::sun::star::<a href="../sdbcx/module-ix.html">sdbcx</a>::<a href="../sdbcx/XTablesSupplier.html">XTablesSupplier</a>::<a href="../sdbcx/XTablesSupplier.html#getTables">getTables</a> will in fact not return a <a href="Table.html">Table</a>, but a <a href="Query.html">Query</a> object. Semantically, however, this object still acts as a table in the SQL statement.</p> </dd> <dt><b/></dt> <dd/></dl> </td> </tr> <tr> <td class="imsum_left">::com::sun::star::<a href="../sdbcx/module-ix.html">sdbcx</a>::<a href="../sdbcx/XColumnsSupplier.html">XColumnsSupplier</a></td> <td class="imsum_right"><dl> <dt><b>Description</b></dt> <dd>access the selected columns. </dd> </dl> </td> </tr> <tr> <td class="imsum_left"><a href="XParametersSupplier.html">XParametersSupplier</a></td> <td class="imsum_right"><dl> <dt><b>Usage Restrictions</b></dt> <dd><i>optional</i></dd> <dt><b>Description</b></dt> <dd>access to the parameters which are used in the where clause. </dd> </dl> </td> </tr> </table> <br> <a href="#_top_">Top of Page</a><hr size="3"><p class="copyright" align="center">Copyright © 2008 Sun Microsystems, Inc.</p> </div> <!-- id="adc-idlref" --> </body> </html>