:: 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
::com::sun::star::sdb::SingleSelectQueryComposer

Exported Interfaces
::com::sun::star::sdb::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 ::com::sun::star::sdb::SingleSelectQueryAnalyzer .

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

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

 
Top of Page