Properties' Summary |
::com::sun::star::sdbc::XConnection
ActiveConnection |
is the connection generated by a DataSource or by a URL. It could
also be set from outside. When set from outside the RowSet is not responsible for the closing of the connection.
|
string
DataSourceName |
is the name of the datasource to use, this could be a named datasource
or the URL of a data access component.
|
string
Command |
is the command which should be executed, the type of command depends
on the CommandType.
|
long
CommandType |
is the type of the command.
|
[ readonly ] string
ActiveCommand |
is the command which is currently used.
|
boolean
IgnoreResult |
indicates whether all results should be discarded or not.
|
string
Filter |
additional filter for a row set.
|
boolean
ApplyFilter |
indicates whether the filter should be applied or not,
default is false.
|
string
HavingClause |
[ OPTIONAL ]
additional having clause for the row set
|
string
GroupBy |
[ OPTIONAL ]
additional group by for the row set
|
string
Order |
is a additional sort order definition for a row set.
|
[ readonly ] long
Privileges |
indicates the privileges for insert, update, and delete.
|
[ readonly ] boolean
IsModified |
indicates that the current row is modified.
|
[ readonly ] boolean
IsNew |
indicates that the current row is going to be inserted to the database.
|
[ readonly ] long
RowCount |
contains the number of rows accessed in a the data source.
|
[ readonly ] boolean
IsRowCountFinal |
indicates that all rows of the row set have been counted.
|
string
UpdateTableName |
[ OPTIONAL ]
is the name of the table which should be updated, this is usually used
for queries which relate to more than one table.
|
string
UpdateCatalogName |
[ OPTIONAL ]
is the name of the table catalog
|
string
UpdateSchemaName |
[ OPTIONAL ]
is the name of the table schema.
|
Exported Interfaces - Details |
XCompletedExecution
- Description
- can be used to allow an interaction handler to supply missing data during a execute process.
If you want a row set to be based on a parametrized query, you will usually use
the ::com::sun::star::sdbc::XParameters interface.
However, you can also choose to let an interaction handler supply such data. For this, you may
for instance instantiate an InteractionHandler, which asks the user for the
data, or you may write your own one, which supplies the data from somewhere else.
The default implementation will only ask for parameters which aren't set before through the ::com::sun::star::sdbc::XParameters interface.
- See also
- InteractionHandler
|
|
XRowSetApproveBroadcaster
- Description
- approving of actions performed on the row set.
The support of this interface implies a semantical extension to the ::com::sun::star::sdbc::XResultSetUpdate
interface which is supported via the ::com::sun::star::sdbc::ResultSet.
- See also
- XResultSetUpdate
|
|
::com::sun::star::sdbc::XResultSetUpdate
|
::com::sun::star::sdbcx::XDeleteRows
|
XResultSetAccess
- Description
- creates a second result set which is based on the same data.
The new result set is interoperable with the row set which created it,
e.g., you can exchange bookmarks between both sets.
If the row set is not alive (i.e., it was not executed before),
NULL
is returned.
|
|
XParametersSupplier
- Usage Restrictions
- optional
- Description
- gives access to the parameters contained in the SQL statement represented by the component.
If your RowSet is bound to an SQL command or query which contains parameters, or has
a Filter or Order which contains parameters, then those can be accessed
using the XParametersSupplier interface.
The returned container contains parameter objects which do allow write access to the parameters (which
is equivalent to using the ::com::sun::star::sdbc::XParameters interface inherited from
::com::sun::star::sdbc::RowSet). Additionally, they provide information about the parameters,
such as their name (if they have one), their type, and the like.
|
|
Properties' Details |
ActiveConnection
::com::sun::star::sdbc::XConnection ActiveConnection;
- Description
- is the connection generated by a DataSource or by a URL. It could
also be set from outside. When set from outside the RowSet is not responsible for the closing of the connection.
|
|
DataSourceName
string DataSourceName;
- Description
- is the name of the datasource to use, this could be a named datasource
or the URL of a data access component.
|
|
Command
string Command;
- Description
- is the command which should be executed, the type of command depends
on the CommandType.
In case of a CommandType of CommandType::COMMAND,
means in case the Command specifies an SQL statement, the inherited
::com::sun::star::sdbc::RowSet::EscapeProcessing
becomes relevant:
It then can be to used to specify whether the SQL statement should be analyzed on the
client side before sending it to the database server.
The default value for ::com::sun::star::sdbc::RowSet::EscapeProcessing
is true. By switching it to false, you can pass backend-specific SQL statements,
which are not standard SQL, to your database.
- See also
- CommandType, ::com::sun::star::sdbc::RowSet::EscapeProcessing
|
|
CommandType
long CommandType;
- Description
- is the type of the command.
- See also
- CommandType
|
|
ActiveCommand
[ readonly ] string ActiveCommand;
- Description
- is the command which is currently used.
- See also
- CommandType
|
|
IgnoreResult
boolean IgnoreResult;
- Description
- indicates whether all results should be discarded or not.
|
|
Filter
string Filter;
- Description
- additional filter for a row set.
|
|
ApplyFilter
boolean ApplyFilter;
- Description
- indicates whether the filter should be applied or not,
default is false.
|
|
HavingClause
string HavingClause;
- Usage Restrictions
- optional
- Description
- additional having clause for the row set
|
|
GroupBy
string GroupBy;
- Usage Restrictions
- optional
- Description
- additional group by for the row set
|
|
Order
string Order;
- Description
- is a additional sort order definition for a row set.
|
|
Privileges
[ readonly ] long Privileges;
- Description
- indicates the privileges for insert, update, and delete.
- See also
- ::com::sun::star::sdbcx::Privilege
|
|
IsModified
[ readonly ] boolean IsModified;
- Description
- indicates that the current row is modified.
|
|
IsNew
[ readonly ] boolean IsNew;
- Description
- indicates that the current row is going to be inserted to the database.
|
|
RowCount
[ readonly ] long RowCount;
- Description
- contains the number of rows accessed in a the data source.
|
|
IsRowCountFinal
[ readonly ] boolean IsRowCountFinal;
- Description
- indicates that all rows of the row set have been counted.
|
|
UpdateTableName
string UpdateTableName;
- Usage Restrictions
- optional
- Description
- is the name of the table which should be updated, this is usually used
for queries which relate to more than one table.
|
|
UpdateCatalogName
string UpdateCatalogName;
- Usage Restrictions
- optional
- Description
- is the name of the table catalog
|
|
UpdateSchemaName
string UpdateSchemaName;
- Usage Restrictions
- optional
- Description
- is the name of the table schema.
|
|
Copyright © 2000, 2013 LibreOffice contributors and/or their affiliates. All rights reserved.
LibreOffice was created by The Document Foundation, based on OpenOffice.org, which is Copyright 2000, 2010 Oracle and/or its affiliates.
The Document Foundation acknowledges all community members, please find more info at our website.