Difference between revisions of "Documentation/DevGuide/Database/Queries"
m |
OOoWikiBot (Talk | contribs) m (FINAL VERSION FOR L10N) |
||
(2 intermediate revisions by the same user not shown) | |||
Line 7: | Line 7: | ||
|NextPage=Documentation/DevGuide/Database/Adding and Editing Predefined Queries | |NextPage=Documentation/DevGuide/Database/Adding and Editing Predefined Queries | ||
}} | }} | ||
− | {{DISPLAYTITLE:Queries}} | + | {{Documentation/DevGuideLanguages|Documentation/DevGuide/Database/{{SUBPAGENAME}}}} |
+ | {{DISPLAYTITLE:Queries}} | ||
<!--<idltopic>com.sun.star.sdb.QueryDefinition</idltopic>--> | <!--<idltopic>com.sun.star.sdb.QueryDefinition</idltopic>--> | ||
A <idl>com.sun.star.sdb.QueryDefinition</idl> encapsulates a definition of an SQL statement stored in {{PRODUCTNAME}} 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 <code>QueryDefinition</code> against a different database by changing the underlying <code>DataSource</code> properties. It can also be created without being connected to a database. | A <idl>com.sun.star.sdb.QueryDefinition</idl> encapsulates a definition of an SQL statement stored in {{PRODUCTNAME}} 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 <code>QueryDefinition</code> against a different database by changing the underlying <code>DataSource</code> properties. It can also be created without being connected to a database. | ||
Line 14: | Line 15: | ||
{{PDL1}} | {{PDL1}} | ||
− | [[Category: Database Access]] | + | |
+ | [[Category:Documentation/Developer's Guide/Database Access]] |
Revision as of 12:42, 15 May 2009
- The DataSource Service
- Queries
A com.sun.star.sdb.QueryDefinition encapsulates a definition of an SQL statement stored in OpenOffice.org 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). |