19 #ifndef __com_sun_star_sdb_XSQLQueryComposer_idl__
20 #define __com_sun_star_sdb_XSQLQueryComposer_idl__
29 module
com { module sun { module star { module sdb {
85 sequence< sequence<com::sun::star::beans::PropertyValue> >
121 [in]
boolean ascending)
is an exception that provides information on a database access error.
Definition: SQLException.idl:45
provides information about and access to the properties from an implementation.
Definition: XPropertySet.idl:64
should be provided by a tool which simplifies the handling with SQL select statements.
Definition: XSQLQueryComposer.idl:40
string getComposedQuery()
returns the query composed with filters and sort criteria.
sequence< sequence< com::sun::star::beans::PropertyValue > > getStructuredFilter()
returns the currently used filter.
string getOrder()
returns the currently used sort order.
void setFilter([in] string filter)
makes it possible to set a filter condition for the query.
void setQuery([in] string command)
sets a new query for the composer, which may be expanded by filters and sort criteria.
void appendFilterByColumn([in] com::sun::star::beans::XPropertySet column)
appends a new filter condition by a com::sun::star::sdb::DataColumn providing the name and the value ...
void appendOrderByColumn([in] com::sun::star::beans::XPropertySet column, [in] boolean ascending)
appends an additional part to the sort order criteria of the select statement.
void setOrder([in] string order)
makes it possible to set a sort condition for the query.
string getFilter()
returns the currently used filter.
string getQuery()
returns the query used for composing.
base interface of all UNO interfaces
Definition: XInterface.idl:48
Definition: Ambiguous.idl:22