Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

API

SDK

Tips ‘n’ Tricks

Miscellaneous


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

unpublished service SingleSelectQueryAnalyzer
Usage Restrictions
not published
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 - 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.

See also
XSingleSelectQueryAnalyzer::getQueryWithSubstitution
::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

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache, OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. The Apache feather logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.