com.esri.sde.sdk.client
Class SeDelete

java.lang.Object
  com.esri.sde.sdk.client.SeStreamOp
      com.esri.sde.sdk.client.SeDelete

public class SeDelete
extends SeStreamOp

Used to perform a Delete operation. Use an instance of this class to delete rows by row Id or using a Where clause.

See Also:

SeRow

Constructor Summary

SeDelete(SeConnection conn)
Creates an SeDelete object given an SeConnection.

Method Summary

void	byId(java.lang.String table, SeObjectId id) Deletes a row from an ArcSDE table using the row id.
void	byIdList(java.lang.String table, SeObjectId[] idList) Deletes rows from an ArcSDE table using a list of row ids to determine which rows to delete.
void	fromTable(java.lang.String table, java.lang.String whereClause) Deletes rows from an ArcSDE table using a where clause to determine which rows to delete.
void	fromTableWithDynamicBind(java.lang.String table, java.lang.String whereClause) Prepares this stream to delete rows from an ArcSDE table using the specified where clause, which contains dynamic parameters.
void	restoreRows(java.lang.String table, SeObjectId[] rowIdList) Restores a set of rows in a miltiversion table to the values they held at the creation of the currently set version.
void	restoreRowsFromLineageByRowId(java.lang.String table, SeObjectId[] rowIdList) Restores a set of rows in a miltiversion table to the values they held at the most recent state in the lineage of the current version.

Methods inherited from class com.esri.sde.sdk.client.SeStreamOp

cancel, close, describeColumn, equivalenceRows, execute, flushBufferedWrites, inProgress, setDynamicParameters, setLogfile, setRowLocking, setState, unequivalenceRows

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SeDelete

public SeDelete(SeConnection conn)
         throws SeException

Creates an SeDelete object given an SeConnection.

Throws:

SeException

Method Detail

restoreRows

public void restoreRows(java.lang.String table,
                        SeObjectId[] rowIdList)
                 throws SeException

Restores a set of rows in a miltiversion table to the values they held at the creation of the currently set version.

Throws:

SeException

restoreRowsFromLineageByRowId

public void restoreRowsFromLineageByRowId(java.lang.String table,
                                          SeObjectId[] rowIdList)
                                   throws SeException

Restores a set of rows in a miltiversion table to the values they held at the most recent state in the lineage of the current version. This function differs from SE_stream_restore_rows in that it does not stop at the state where the currently set version was created. It will continue working up the lineage until the row is found.

Throws:

SeException

byId

public void byId(java.lang.String table,
                 SeObjectId id)
          throws SeException

Deletes a row from an ArcSDE table using the row id. A call to this method immediately deletes the row from the database. The application does not need to call execute()

Throws:

SeException

byIdList

public void byIdList(java.lang.String table,
                     SeObjectId[] idList)
              throws SeException

Deletes rows from an ArcSDE table using a list of row ids to determine which rows to delete. A call to this method immediately deletes the rows from the database. The application does not need to call execute()

Throws:

SeException

fromTable

public void fromTable(java.lang.String table,
                      java.lang.String whereClause)
               throws SeException

Deletes rows from an ArcSDE table using a where clause to determine which rows to delete. A call to this method immediately deletes the rows from the database. However, one of the following methods must be invoked for the delete to be committed to the database: SeConnection.commitTransaction() or SeConnection.close()

Throws:

SeException

fromTableWithDynamicBind

public void fromTableWithDynamicBind(java.lang.String table,
                                     java.lang.String whereClause)
                              throws SeException

Prepares this stream to delete rows from an ArcSDE table using the specified where clause, which contains dynamic parameters. A subsequent call to SeDelete.execute(), deletes the rows that satisfy the where clause constraint.

Parameters:

table - the name of the ArcSDE Table to delete from.

whereClause - a where clause containing dynamic parameter markers.

Throws:

SeException