:: com :: sun :: star :: sdb ::

unpublished service SingleSelectQueryAnalyzer
Description
represents a service for analyzing a single select statement.

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.

See also
SingleSelectQueryComposer

Exported Interfaces
XSingleSelectQueryAnalyzer
(referenced entity's summary:)
simplifies the analyzing of single select statements.
::com::sun::star::sdbcx::XTablesSupplier
Description
access to the selected tables.

The selected tables are those present in the FROM part of a SELECT statement.

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 All Orders , the SQL statement SELECT * FROM "All Orders" is perfectly valid when used with a SingleSelectQueryAnalyzer .

In this case, the name container returned by ::com::sun::star::sdbcx::XTablesSupplier::getTables will in fact not return a Table , but a Query object. Semantically, however, this object still acts as a table in the SQL statement.

::com::sun::star::sdbcx::XColumnsSupplier
Description
access the selected columns.
XParametersSupplier
Usage Restrictions
optional
Description
access to the parameters which are used in the where clause.

 
Top of Page