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

service SingleSelectQueryAnalyzer

Exported Interfaces - Summary
XSingleSelectQueryAnalyzer
::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
::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