:: 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.


Exported Interfaces - Summary
XSingleSelectQueryAnalyzer
(referenced entity's summary:)
simplifies the analyzing of single select statements.
::com::sun::star::sdbcx::XTablesSupplier

access to the selected tables. (details)

::com::sun::star::sdbcx::XColumnsSupplier

access the selected columns.

XParametersSupplier

access to the parameters which are used in the where clause. (details)

Exported Interfaces - Details
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