DBROWSTATUS Enumerated Type
Providers use DBROWSTATUS values to return information about the status of a row and whether an operation succeeds or fails for each row in the rowset.
The values of DBROWSTATUS have the following meanings.
Value |
Description |
|---|---|
DBROWSTATUS_S_OK |
The operation upon the row succeeded. |
DBROWSTATUS_S_MULTIPLECHANGES |
Occurs when updating or deleting a single row caused more than one row to be updated or deleted in the data store. For more information, see DBPROP_REPORTMULTIPLECHANGES. |
DBROWSTATUS_S_PENDINGCHANGES |
Can occur after a consumer has called IRowset::ReleaseRows, and the row had a pending change. The row will be released, and the corresponding element of rgRowStatus will contain this value. |
DBROWSTATUS_S_ROWSETCOLUMN |
IRowSchemaChange::DeleteColumns may return this row status when asked to delete a rowset column from a row. The value is actually nulled, but the column remains in the row and rowset. |
DBROWSTATUS_S_NOCHANGE |
Occurs when an operation succeeds for a row but no changes were made. IRowSetRefresh::RefreshVisibleData often returns this row status as a status flag to indicate that the row has not changed. |
DBROWSTATUS_E_CANCELED |
Operation on a row was canceled during notification. The row operation was not completed, and the corresponding row status contains this value. |
DBROWSTATUS_E_CANTRELEASE |
The operation upon the row failed because the row could not be released. |
DBROWSTATUS_E_CONCURRENCYVIOLATION |
The row was not updated because someone else already updated the row. Presumably, the data from the first update conflicts with the data that was part of the second concurrently attempted update. |
DBROWSTATUS_E_DELETED |
The row has already been deleted at the server. This indicates an error and that the requested operation failed. Under these circumstances, the status for the corresponding row contains this value. |
DBROWSTATUS_E_PENDINGINSERT |
This can occur when the rowset is in deferred update mode, which occurs when you insert or create a new row in the client application but the change has not yet been transmitted to the server. For example, if the consumer inserts a new row, and then tries to resynchronize with the data source, the newly inserted row was not yet transmitted to data source, so the requested operation failed. Another example would be where IRowsetRefresh:RefreshVisibleData is called with fOverwrite set to False. In that case, the server can't overwrite the newly inserted row, so the provider returns an error. |
DBROWSTATUS_E_NEWLYINSERTED |
If the DBPROP_CHANGEINSERTEDROWS is set to false and consumer calls IRowsetChange::DeleteRows or IRowsetChange::SetData for newly inserted rows, DeleteRows returns a status of DBROWSTATUS_E_NEWLYINSERTED for the row and SetData returns DB_E_NEWLYINSERTED. |
DBROWSTATUS_E_INTEGRITYVIOLATION |
Occurs when the provider recognizes that deleting a referred row violates the integrity constraints for the column or table. |
DBROWSTATUS_E_INVALID |
Row handle or bookmark was invalid. Operation for the row failed. This can happen because either the consumer used a row handle or bookmark that was not valid or it might have referred to a row that the current thread does not have access to. Under these circumstances, the status for the corresponding row contains this value. |
DBROWSTATUS_E_MAXPENDCHANGESEXCEEDED |
The operation upon the row failed because the maximum number of pending changes was exceeded. |
DBROWSTATUS_E_OBJECTOPEN |
Consumer referred to a row on which a storage object was open, and the operation is not allowed until storage object is released. For example, when rowset is in deferred update mode, the consumer cannot undo any pending changes made through storage object that is still open. |
DBROWSTATUS_E_OUTOFMEMORY |
The rowset ran out of memory and was unable to perform operation for the row. |
DBROWSTATUS_E_PERMISSIONDENIED |
The consumer did not have sufficient permission to perform operation for the row. |
DBROWSTATUS_E_LIMITREACHED |
The row was not fetched for the following reason: Fetching rows required further execution of the command, such as when the rowset uses a server-side cursor. Execution has been stopped and cannot be resumed because a resource limit has been reached. Under these circumstances, the status for the corresponding row contains this value. |
DBROWSTATUS_E_SCHEMAVIOLATION |
The operation upon the row failed because of a schema violation. This row status indicates an error and that the data in the row would conflict with the requirements imposed by the database schema. |
DBROWSTATUS_E_FAIL |
The consumer encountered a recoverable, provider-specific error, such as an RPC failure when transmitting the change to a remote server. Under these circumstances, the status for the corresponding row contains this value. |