(incubating) | The Free and Open Productivity Suite

Developer's Guide

API

SDK

Tips 'n' Tricks

Miscellaneous

Content for OpenOffice.org version 3.3.
Overview Module Use Devguide Index
Services' Summary Interfaces' Summary Properties' Summary Services' Details Interfaces' Details Properties' Details

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

Copyright © 1995, 2010, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Apache OpenOffice is an effort undergoing incubation at The Apache Software Foundation (ASF), sponsored by the Apache Incubator. Incubation is required of all newly accepted projects until a further review indicates that the infrastructure, communications, and decision making process have stabilized in a manner consistent with other successful ASF projects. While incubation status is not necessarily a reflection of the completeness or stability of the code, it does indicate that the project has yet to be fully endorsed by the ASF.

Copyright & License
Apache and the Apache feather logos are trademarks of The Apache Software Foundation. OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.