Overview | Module | Use | Devguide | Index

Methods' Summary | Methods' Details | Attributes' Summary | Attributes' Details

:: com :: sun :: star :: sdbc ::
interface XResultSetUpdate
  Base Hierarchy
      ::com::sun::star::uno::XInterface
       |
       +-XResultSetUpdate
Description provides the possiblity to write changes made on a result set back to database.

Methods' Summary
insertRow | inserts the contents of the insert row into the result set and the database. Must be on the insert row when this method is called.
updateRow | updates the underlying database with the new contents of the current row. Cannot be called when on the insert row.
deleteRow | deletes the current row from the result set and the underlying database. Cannot be called when on the insert row.
cancelRowUpdates | cancels the updates made to a row.
moveToInsertRow | moves the cursor to the insert row. The current cursor position is remembered while the cursor is positioned on the insert row.
moveToCurrentRow | moves the cursor to the remembered cursor position, usually the current row. This method has no effect if the cursor is not on the insert row.

Methods' Details
insertRow
void insertRow() | raises( | SQLException );
Description inserts the contents of the insert row into the result set and the database. Must be on the insert row when this method is called. Throws SQLException if a database access error occurs.
updateRow
void updateRow() | raises( | SQLException );
Description updates the underlying database with the new contents of the current row. Cannot be called when on the insert row. Throws SQLException if a database access error occurs.
deleteRow
void deleteRow() | raises( | SQLException );
Description deletes the current row from the result set and the underlying database. Cannot be called when on the insert row. Throws SQLException if a database access error occurs.
cancelRowUpdates
void cancelRowUpdates() | raises( | SQLException );
Description cancels the updates made to a row. This method may be called after calling an `updateXXX` method(s) and before calling XResultSetUpdate::updateRow() to rollback the updates made to a row. If no updates have been made or `updateRow` has already been called, then this method has no effect. Throws SQLException if a database access error occurs.
moveToInsertRow
void moveToInsertRow() | raises( | SQLException );
Description moves the cursor to the insert row. The current cursor position is remembered while the cursor is positioned on the insert row. The insert row is a special row associated with an updatable result set. It is essentially a buffer where a new row may be constructed by calling the `updateXXX` methods prior to inserting the row into the result set. Only the `updateXXX` , `getXXX` , and XResultSetUpdate::insertRow() methods may be called when the cursor is on the insert row. All of the columns in a result set must be given a value each time this method is called before calling `insertRow` . The method `updateXXX` must be called before a `getXXX` method can be called on a column value. Throws SQLException if a database access error occurs.
moveToCurrentRow
void moveToCurrentRow() | raises( | SQLException );
Description moves the cursor to the remembered cursor position, usually the current row. This method has no effect if the cursor is not on the insert row. Throws SQLException if a database access error occurs.

Top of Page

Copyright © 2003 Sun Microsystems, Inc.