Queries
- The DataSource Service
- Queries
A com.sun.star.sdb.QueryDefinition encapsulates a definition of an SQL statement stored in Apache OpenOffice API. It is similar to a view or a stored procedure, because it can be reused, and executed and altered by the user in the GUI. It is possible to run a QueryDefinition
against a different database by changing the underlying DataSource
properties. It can also be created without being connected to a database.
The purpose of the query services available at a DataSource
is to define and edit queries. The query services by themselves do not offer methods to execute queries. To open a query, use a com.sun.star.sdb.RowSet service or the com.sun.star.sdb.XCommandPreparation interface of a connection. See the sections The RowSet Service and PreparedStatement From DataSource Queries for additional details.
Content on this page is licensed under the Public Documentation License (PDL). |