Queries

From Apache OpenOffice Wiki
Jump to: navigation, search



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).
Personal tools
In other languages