is a stored definition of a SQL query. More...

import"Query.idl";

Inheritance diagram for Query:

Included Services
service	com::sun::star::sdb::DataSettings
	is used for customization of data appearance. More...

Exported Interfaces
interface	com::sun::star::sdb::XQueryDefinition
	defines the command of the query. More...

interface	com::sun::star::sdbcx::XDataDescriptorFactory
	is provided for creation of a new query descriptor based on the current information. More...

interface	com::sun::star::sdbcx::XRename

interface	com::sun::star::sdbcx::XColumnsSupplier
	access to the columns of the results sets query. More...

Exported Interfaces inherited from XQueryDefinition
interface	com::sun::star::beans::XPropertySet
	access to the owning database definition object. More...

interface	com::sun::star::ucb::XContent

interface	com::sun::star::lang::XComponent

Additional Inherited Members
Public Member Functions inherited from XPropertySet
com::sun::star::beans::XPropertySetInfo	getPropertySetInfo ()

void	setPropertyValue ([in] string aPropertyName, [in] any aValue) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::beans::PropertyVetoException, com::sun::star::lang::IllegalArgumentException, com::sun::star::lang::WrappedTargetException )
	sets the value of the property with the specified name. More...

any	getPropertyValue ([in] string PropertyName) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::lang::WrappedTargetException )

void	addPropertyChangeListener ([in] string aPropertyName, [in] com::sun::star::beans::XPropertyChangeListener xListener) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::lang::WrappedTargetException )
	adds an XPropertyChangeListener to the specified property. More...

void	removePropertyChangeListener ([in] string aPropertyName, [in] com::sun::star::beans::XPropertyChangeListener aListener) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::lang::WrappedTargetException )
	removes an XPropertyChangeListener from the listener list. More...

void	addVetoableChangeListener ([in] string PropertyName, [in] com::sun::star::beans::XVetoableChangeListener aListener) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::lang::WrappedTargetException )
	adds an XVetoableChangeListener to the specified property with the name PropertyName. More...

void	removeVetoableChangeListener ([in] string PropertyName, [in] com::sun::star::beans::XVetoableChangeListener aListener) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::lang::WrappedTargetException )
	removes an XVetoableChangeListener from the listener list. More...

Public Member Functions inherited from XInterface
any	queryInterface ([in] type aType)
	queries for a new interface to an existing UNO object. More...

void	acquire ()
	increases the reference counter by one. More...

void	release ()
	decreases the reference counter by one. More...

Public Member Functions inherited from XContent
com::sun::star::ucb::XContentIdentifier	getIdentifier ()
	returns the identifier of the content. More...

string	getContentType ()
	returns a type string, which is unique for that type of content (e.g. More...

void	addContentEventListener ([in] com::sun::star::ucb::XContentEventListener Listener)
	adds a listener for content events. More...

void	removeContentEventListener ([in] com::sun::star::ucb::XContentEventListener Listener)
	removes a listener for content events. More...

Public Member Functions inherited from XComponent
void	dispose ()
	The owner of an object calls this method to explicitly free all resources kept by this object and thus break cyclic references. More...

void	addEventListener ([in] XEventListener xListener)
	adds an event listener to the object. More...

void	removeEventListener ([in] XEventListener aListener)
	removes an event listener from the listener list. More...

Public Member Functions inherited from XDataDescriptorFactory
com::sun::star::beans::XPropertySet	createDataDescriptor ()
	returns a descriptor of a definition object. More...

Public Member Functions inherited from XRename
void	rename ([in]string newName) raises (com::sun::star::sdbc::SQLException, com::sun::star::container::ElementExistException)
	is intended to alter the name of an object. More...

Public Member Functions inherited from XColumnsSupplier
com::sun::star::container::XNameAccess	getColumns ()
	returns the container of columns. More...

Public Attributes inherited from DataSettings
string	Filter
	additional filter for the data object. More...

boolean	ApplyFilter
	indicates whether the filter should be applied or not, default is `FALSE`. More...

string	Order
	is an additional sort order definition. More...

com::sun::star::awt::FontDescriptor	FontDescriptor
	specifies the font attributes for data displaying. More...

long	RowHeight
	specifies the height of a data row. More...

com::sun::star::util::Color	TextColor
	specifies the text color (RGB) for displaying text. More...

string	HavingClause
	additional having clause for the data object. More...

string	GroupBy
	additional group by for the data object. More...

Detailed Description

is a stored definition of a SQL query.

It can be used if there is a need to execute SQL statements more than once, or if you want to format the query result fields differently from the underlying table definitions.