<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<!--NewPage-->
<HTML>
<HEAD>
<!-- Generated by javadoc (build 1.6.0_18) on Sat Dec 04 05:26:45 UTC 2010 -->
<TITLE>
SelectStatement
</TITLE>
<META NAME="date" CONTENT="2010-12-04">
<LINK REL ="stylesheet" TYPE="text/css" HREF="../../../../../stylesheet.css" TITLE="Style">
<SCRIPT type="text/javascript">
function windowTitle()
{
if (location.href.indexOf('is-external=true') == -1) {
parent.document.title="SelectStatement";
}
}
</SCRIPT>
<NOSCRIPT>
</NOSCRIPT>
</HEAD>
<BODY BGCOLOR="white" onload="windowTitle();">
<HR>
<!-- ========= START OF TOP NAVBAR ======= -->
<A NAME="navbar_top"><!-- --></A>
<A HREF="#skip-navbar_top" title="Skip navigation links"></A>
<TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY="">
<TR>
<TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1">
<A NAME="navbar_top_firstrow"><!-- --></A>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY="">
<TR ALIGN="center" VALIGN="top">
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A> </TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A> </TD>
<TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> <FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT> </TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A> </TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A> </TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../index-all.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A> </TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A> </TD>
</TR>
</TABLE>
</TD>
<TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM>
</EM>
</TD>
</TR>
<TR>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
<A HREF="../../../../../org/apache/ws/jaxme/sqls/Schema.Name.html" title="interface in org.apache.ws.jaxme.sqls"><B>PREV CLASS</B></A>
<A HREF="../../../../../org/apache/ws/jaxme/sqls/SelectStatement.OrderColumn.html" title="interface in org.apache.ws.jaxme.sqls"><B>NEXT CLASS</B></A></FONT></TD>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
<A HREF="../../../../../index.html?org/apache/ws/jaxme/sqls/SelectStatement.html" target="_top"><B>FRAMES</B></A>
<A HREF="SelectStatement.html" target="_top"><B>NO FRAMES</B></A>
<SCRIPT type="text/javascript">
<!--
if(window==top) {
document.writeln('<A HREF="../../../../../allclasses-noframe.html"><B>All Classes</B></A>');
}
//-->
</SCRIPT>
<NOSCRIPT>
<A HREF="../../../../../allclasses-noframe.html"><B>All Classes</B></A>
</NOSCRIPT>
</FONT></TD>
</TR>
<TR>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
SUMMARY: <A HREF="#nested_class_summary">NESTED</A> | FIELD | CONSTR | <A HREF="#method_summary">METHOD</A></FONT></TD>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
DETAIL: FIELD | CONSTR | <A HREF="#method_detail">METHOD</A></FONT></TD>
</TR>
</TABLE>
<A NAME="skip-navbar_top"></A>
<!-- ========= END OF TOP NAVBAR ========= -->
<HR>
<!-- ======== START OF CLASS DATA ======== -->
<H2>
<FONT SIZE="-1">
org.apache.ws.jaxme.sqls</FONT>
<BR>
Interface SelectStatement</H2>
<DL>
<DT><B>All Superinterfaces:</B> <DD><A HREF="../../../../../org/apache/ws/jaxme/sqls/ConstrainedStatement.html" title="interface in org.apache.ws.jaxme.sqls">ConstrainedStatement</A>, <A HREF="../../../../../org/apache/ws/jaxme/sqls/Statement.html" title="interface in org.apache.ws.jaxme.sqls">Statement</A></DD>
</DL>
<DL>
<DT><B>All Known Subinterfaces:</B> <DD><A HREF="../../../../../org/apache/ws/jaxme/sqls/oracle/OraSelectStatement.html" title="interface in org.apache.ws.jaxme.sqls.oracle">OraSelectStatement</A></DD>
</DL>
<DL>
<DT><B>All Known Implementing Classes:</B> <DD><A HREF="../../../../../org/apache/ws/jaxme/sqls/oracle/OraSelectStatementImpl.html" title="class in org.apache.ws.jaxme.sqls.oracle">OraSelectStatementImpl</A>, <A HREF="../../../../../org/apache/ws/jaxme/sqls/impl/SelectStatementImpl.html" title="class in org.apache.ws.jaxme.sqls.impl">SelectStatementImpl</A></DD>
</DL>
<HR>
<DL>
<DT><PRE>public interface <B>SelectStatement</B><DT>extends <A HREF="../../../../../org/apache/ws/jaxme/sqls/ConstrainedStatement.html" title="interface in org.apache.ws.jaxme.sqls">ConstrainedStatement</A></DL>
</PRE>
<P>
<p>Interface of a SELECT statement.</p>
<P>
<P>
<DL>
<DT><B>Author:</B></DT>
<DD><a href="mailto:joe@ispsoft.de">Jochen Wiedmann</a></DD>
</DL>
<HR>
<P>
<!-- ======== NESTED CLASS SUMMARY ======== -->
<A NAME="nested_class_summary"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TH ALIGN="left" COLSPAN="2"><FONT SIZE="+2">
<B>Nested Class Summary</B></FONT></TH>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static interface</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/SelectStatement.OrderColumn.html" title="interface in org.apache.ws.jaxme.sqls">SelectStatement.OrderColumn</A></B></CODE>
<BR>
Provides a single column for an <code>ORDER BY</code>
clause.</TD>
</TR>
</TABLE>
<!-- ========== METHOD SUMMARY =========== -->
<A NAME="method_summary"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TH ALIGN="left" COLSPAN="2"><FONT SIZE="+2">
<B>Method Summary</B></FONT></TH>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/SelectStatement.html#addOrderColumn(java.lang.Object)">addOrderColumn</A></B>(java.lang.Object pColumn)</CODE>
<BR>
Adds a column to the ORDER BY clause.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/SelectStatement.html#addOrderColumn(java.lang.Object, boolean)">addOrderColumn</A></B>(java.lang.Object pColumn,
boolean pDescending)</CODE>
<BR>
Adds a column to the ORDER BY clause.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/SelectStatement.html#addOrderColumn(org.apache.ws.jaxme.sqls.SelectStatement.OrderColumn)">addOrderColumn</A></B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/SelectStatement.OrderColumn.html" title="interface in org.apache.ws.jaxme.sqls">SelectStatement.OrderColumn</A> pColumn)</CODE>
<BR>
Adds a column to the ORDER BY clause.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/SelectStatement.html#addResultColumn(org.apache.ws.jaxme.sqls.ColumnReference)">addResultColumn</A></B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/ColumnReference.html" title="interface in org.apache.ws.jaxme.sqls">ColumnReference</A> pColumn)</CODE>
<BR>
Adds a result column to the statement.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.html" title="interface in org.apache.ws.jaxme.sqls">Table</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/SelectStatement.html#createView(java.lang.String)">createView</A></B>(java.lang.String pName)</CODE>
<BR>
Creates a view, which may be used to embed the statement into
a separate query.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.html" title="interface in org.apache.ws.jaxme.sqls">Table</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/SelectStatement.html#createView(org.apache.ws.jaxme.sqls.Table.Name)">createView</A></B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.Name.html" title="interface in org.apache.ws.jaxme.sqls">Table.Name</A> pName)</CODE>
<BR>
Creates a view, which may be used to embed the statement into
a separate query.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/SelectStatement.html#getMaxRows()">getMaxRows</A></B>()</CODE>
<BR>
Returns the limit of the number of rows in the result set, or
zero, if the size of the result set is unlimited.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> java.util.Iterator</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/SelectStatement.html#getOrderColumns()">getOrderColumns</A></B>()</CODE>
<BR>
Returns the list of order columns.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> java.util.Iterator</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/SelectStatement.html#getResultColumns()">getResultColumns</A></B>()</CODE>
<BR>
Returns the list of result columns.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="../../../../../org/apache/ws/jaxme/sqls/SelectTableReference.html" title="interface in org.apache.ws.jaxme.sqls">SelectTableReference</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/SelectStatement.html#getSelectTableReference()">getSelectTableReference</A></B>()</CODE>
<BR>
Shortcut for <code>(SelectTableReference) getTable()</code>.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> java.util.Iterator</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/SelectStatement.html#getSelectTableReferences()">getSelectTableReferences</A></B>()</CODE>
<BR>
Returns an Iterator over all the table references.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/SelectStatement.html#getSkippedRows()">getSkippedRows</A></B>()</CODE>
<BR>
Returns the number of rows to skip at the result sets beginning.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> boolean</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/SelectStatement.html#isDistinct()">isDistinct</A></B>()</CODE>
<BR>
Returns whether the statement should have a DISTINCT clause.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/SelectStatement.html#setDistinct(boolean)">setDistinct</A></B>(boolean pDistinct)</CODE>
<BR>
Sets whether the statement should have a DISTINCT clause.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/SelectStatement.html#setMaxRows(int)">setMaxRows</A></B>(int pMaxRows)</CODE>
<BR>
Limits the size of the result set to the given number of rows.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/SelectStatement.html#setSkippedRows(int)">setSkippedRows</A></B>(int pSkippedRows)</CODE>
<BR>
Indicates that the given number of rows should be skipped at the
result sets beginning.</TD>
</TR>
</TABLE>
<A NAME="methods_inherited_from_class_org.apache.ws.jaxme.sqls.ConstrainedStatement"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TH ALIGN="left"><B>Methods inherited from interface org.apache.ws.jaxme.sqls.<A HREF="../../../../../org/apache/ws/jaxme/sqls/ConstrainedStatement.html" title="interface in org.apache.ws.jaxme.sqls">ConstrainedStatement</A></B></TH>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE><A HREF="../../../../../org/apache/ws/jaxme/sqls/ConstrainedStatement.html#getWhere()">getWhere</A></CODE></TD>
</TR>
</TABLE>
<A NAME="methods_inherited_from_class_org.apache.ws.jaxme.sqls.Statement"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TH ALIGN="left"><B>Methods inherited from interface org.apache.ws.jaxme.sqls.<A HREF="../../../../../org/apache/ws/jaxme/sqls/Statement.html" title="interface in org.apache.ws.jaxme.sqls">Statement</A></B></TH>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE><A HREF="../../../../../org/apache/ws/jaxme/sqls/Statement.html#createFunction(java.lang.String)">createFunction</A>, <A HREF="../../../../../org/apache/ws/jaxme/sqls/Statement.html#getSQLFactory()">getSQLFactory</A>, <A HREF="../../../../../org/apache/ws/jaxme/sqls/Statement.html#getTableReference()">getTableReference</A>, <A HREF="../../../../../org/apache/ws/jaxme/sqls/Statement.html#newCase(org.apache.ws.jaxme.sqls.Column.Type)">newCase</A>, <A HREF="../../../../../org/apache/ws/jaxme/sqls/Statement.html#setTable(org.apache.ws.jaxme.sqls.Table)">setTable</A></CODE></TD>
</TR>
</TABLE>
<P>
<!-- ============ METHOD DETAIL ========== -->
<A NAME="method_detail"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TH ALIGN="left" COLSPAN="1"><FONT SIZE="+2">
<B>Method Detail</B></FONT></TH>
</TR>
</TABLE>
<A NAME="getSelectTableReference()"><!-- --></A><H3>
getSelectTableReference</H3>
<PRE>
<A HREF="../../../../../org/apache/ws/jaxme/sqls/SelectTableReference.html" title="interface in org.apache.ws.jaxme.sqls">SelectTableReference</A> <B>getSelectTableReference</B>()</PRE>
<DL>
<DD><p>Shortcut for <code>(SelectTableReference) getTable()</code>.</p>
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="getSelectTableReferences()"><!-- --></A><H3>
getSelectTableReferences</H3>
<PRE>
java.util.Iterator <B>getSelectTableReferences</B>()</PRE>
<DL>
<DD><p>Returns an Iterator over all the table references.</p>
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="addOrderColumn(org.apache.ws.jaxme.sqls.SelectStatement.OrderColumn)"><!-- --></A><H3>
addOrderColumn</H3>
<PRE>
void <B>addOrderColumn</B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/SelectStatement.OrderColumn.html" title="interface in org.apache.ws.jaxme.sqls">SelectStatement.OrderColumn</A> pColumn)</PRE>
<DL>
<DD><p>Adds a column to the ORDER BY clause.</p>
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="addOrderColumn(java.lang.Object)"><!-- --></A><H3>
addOrderColumn</H3>
<PRE>
void <B>addOrderColumn</B>(java.lang.Object pColumn)</PRE>
<DL>
<DD><p>Adds a column to the ORDER BY clause. The column is sorted in
ascending order.</p>
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="addOrderColumn(java.lang.Object, boolean)"><!-- --></A><H3>
addOrderColumn</H3>
<PRE>
void <B>addOrderColumn</B>(java.lang.Object pColumn,
boolean pDescending)</PRE>
<DL>
<DD><p>Adds a column to the ORDER BY clause. The column is sorted in
ascending or descending order, depending on the parameter
<code>pDescending</code>.</p>
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>pDescending</CODE> - True for descending or false for ascending</DL>
</DD>
</DL>
<HR>
<A NAME="addResultColumn(org.apache.ws.jaxme.sqls.ColumnReference)"><!-- --></A><H3>
addResultColumn</H3>
<PRE>
void <B>addResultColumn</B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/ColumnReference.html" title="interface in org.apache.ws.jaxme.sqls">ColumnReference</A> pColumn)</PRE>
<DL>
<DD><p>Adds a result column to the statement. By default all columns
are returned.</p>
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="getResultColumns()"><!-- --></A><H3>
getResultColumns</H3>
<PRE>
java.util.Iterator <B>getResultColumns</B>()</PRE>
<DL>
<DD><p>Returns the list of result columns.</p>
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="getOrderColumns()"><!-- --></A><H3>
getOrderColumns</H3>
<PRE>
java.util.Iterator <B>getOrderColumns</B>()</PRE>
<DL>
<DD><p>Returns the list of order columns. The elements
returned by the iterator are instances of
<A HREF="../../../../../org/apache/ws/jaxme/sqls/SelectStatement.OrderColumn.html" title="interface in org.apache.ws.jaxme.sqls"><CODE>SelectStatement.OrderColumn</CODE></A>.</p>
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="setDistinct(boolean)"><!-- --></A><H3>
setDistinct</H3>
<PRE>
void <B>setDistinct</B>(boolean pDistinct)</PRE>
<DL>
<DD><p>Sets whether the statement should have a DISTINCT clause. By
default no DISTINCT clause is present.</p>
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="isDistinct()"><!-- --></A><H3>
isDistinct</H3>
<PRE>
boolean <B>isDistinct</B>()</PRE>
<DL>
<DD><p>Returns whether the statement should have a DISTINCT clause. By
default no DISTINCT clause is present.</p>
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="setMaxRows(int)"><!-- --></A><H3>
setMaxRows</H3>
<PRE>
void <B>setMaxRows</B>(int pMaxRows)</PRE>
<DL>
<DD><p>Limits the size of the result set to the given number of rows.
Defaults to zero, in which case the size of the result set is
unlimited.</p>
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="getMaxRows()"><!-- --></A><H3>
getMaxRows</H3>
<PRE>
int <B>getMaxRows</B>()</PRE>
<DL>
<DD><p>Returns the limit of the number of rows in the result set, or
zero, if the size of the result set is unlimited.</p>
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="setSkippedRows(int)"><!-- --></A><H3>
setSkippedRows</H3>
<PRE>
void <B>setSkippedRows</B>(int pSkippedRows)</PRE>
<DL>
<DD><p>Indicates that the given number of rows should be skipped at the
result sets beginning. The default is zero, in which case no rows
are skipped.</p>
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="getSkippedRows()"><!-- --></A><H3>
getSkippedRows</H3>
<PRE>
int <B>getSkippedRows</B>()</PRE>
<DL>
<DD><p>Returns the number of rows to skip at the result sets beginning.
The default is zero, in which case no rows are skipped.</p>
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="createView(org.apache.ws.jaxme.sqls.Table.Name)"><!-- --></A><H3>
createView</H3>
<PRE>
<A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.html" title="interface in org.apache.ws.jaxme.sqls">Table</A> <B>createView</B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.Name.html" title="interface in org.apache.ws.jaxme.sqls">Table.Name</A> pName)</PRE>
<DL>
<DD><p>Creates a view, which may be used to embed the statement into
a separate query.</p>
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="createView(java.lang.String)"><!-- --></A><H3>
createView</H3>
<PRE>
<A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.html" title="interface in org.apache.ws.jaxme.sqls">Table</A> <B>createView</B>(java.lang.String pName)</PRE>
<DL>
<DD><p>Creates a view, which may be used to embed the statement into
a separate query.</p>
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<!-- ========= END OF CLASS DATA ========= -->
<HR>
<!-- ======= START OF BOTTOM NAVBAR ====== -->
<A NAME="navbar_bottom"><!-- --></A>
<A HREF="#skip-navbar_bottom" title="Skip navigation links"></A>
<TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY="">
<TR>
<TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1">
<A NAME="navbar_bottom_firstrow"><!-- --></A>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY="">
<TR ALIGN="center" VALIGN="top">
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A> </TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A> </TD>
<TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> <FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT> </TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A> </TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A> </TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../index-all.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A> </TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A> </TD>
</TR>
</TABLE>
</TD>
<TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM>
</EM>
</TD>
</TR>
<TR>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
<A HREF="../../../../../org/apache/ws/jaxme/sqls/Schema.Name.html" title="interface in org.apache.ws.jaxme.sqls"><B>PREV CLASS</B></A>
<A HREF="../../../../../org/apache/ws/jaxme/sqls/SelectStatement.OrderColumn.html" title="interface in org.apache.ws.jaxme.sqls"><B>NEXT CLASS</B></A></FONT></TD>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
<A HREF="../../../../../index.html?org/apache/ws/jaxme/sqls/SelectStatement.html" target="_top"><B>FRAMES</B></A>
<A HREF="SelectStatement.html" target="_top"><B>NO FRAMES</B></A>
<SCRIPT type="text/javascript">
<!--
if(window==top) {
document.writeln('<A HREF="../../../../../allclasses-noframe.html"><B>All Classes</B></A>');
}
//-->
</SCRIPT>
<NOSCRIPT>
<A HREF="../../../../../allclasses-noframe.html"><B>All Classes</B></A>
</NOSCRIPT>
</FONT></TD>
</TR>
<TR>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
SUMMARY: <A HREF="#nested_class_summary">NESTED</A> | FIELD | CONSTR | <A HREF="#method_summary">METHOD</A></FONT></TD>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
DETAIL: FIELD | CONSTR | <A HREF="#method_detail">METHOD</A></FONT></TD>
</TR>
</TABLE>
<A NAME="skip-navbar_bottom"></A>
<!-- ======== END OF BOTTOM NAVBAR ======= -->
<HR>
</BODY>
</HTML>
distrib
>
Mandriva
>
2011.0
>
x86_64
>
media
>
main-release
>
by-pkgid
>
a151a9789d7f6da162486c8d892d2428
>
files
>
533
