Export (0) Print
Expand All

Rowset Properties

SQL Server 2000

Rowset Properties

The DBPROPSET_ROWSET property set contains the following properties. All of these properties are in the Rowset property group. Additional properties are defined in DBPROPSET_SSCE_ROWSET.

Property ID Description
DBPROP_ABORTPRESERVE Type: VT_BOOL
Typical R/W: R only
Description: Preserve on Abort
For this provider, the value is always VARIANT_FALSE, which indicates that, after aborting a transaction, the only operations allowed on a rowset are to release row and accessor handles and to release the rowset.
DBPROP_ACCESSORDER Type: VT_I4
R/W: R
Description: Access Order
For this provider, the value is always DBPROPVAL_AO_RANDOM.
DBPROP_BLOCKINGSTORAGEOBJECTS Type: VT_BOOL
Typical R/W: R only
For this provider, the value is always VARIANT_TRUE.
DBPROP_BOOKMARKS Type: VT_BOOL
Typical R/W: R/W
Description: Use Bookmarks
Specifies whether the rowset supports bookmarks. The provider supports the following values:
VARIANT_TRUE, which indicates that the rowset supports bookmarks. Column 0 is the bookmark for the rows. Getting this column obtains a bookmark value, which can be used to reposition to the row.
VARIANT_FALSE, which indicates that the rowset does not support bookmarks. The rowset is sequential, and the values of the DBPROP_LITERALBOOKMARKS and DBPROP_ORDEREDBOOKMARKS properties are ignored.
DBPROP_BOOKMARKTYPE Type: VT_I4
Typical R/W: R only
Description: Bookmark Type
Specifies the bookmark type supported by the rowset.
For this provider, the value is always DBPROPVAL_BMK_NUMERIC, which indicates that the bookmark type is numeric. Numeric bookmarks are based on a row's properties that are not dependent on the values of the row's columns. For example, a numeric bookmark can be based on the absolute position of the row within the rowset or on a row ID that the storage engine assigned to a tuple when it was created. Modifying the row's columns does not change the validity of numeric bookmarks.
DBPROP_CANFETCHBACKWARDS Type: VT_BOOL
Typical R/W: R/W
Description: Fetch Backward
Specifies whether the rowset can fetch backward. The providers supports the following values:
VARIANT_TRUE, which indicates that cRows in IRowset::GetNextRows, IRowsetLocate::GetRowsAt, and IRowsetScroll::GetRowsAtRatio can be negative. When it is negative, these methods fetch rows backward from the specified row.
VARIANT_FALSE, which indicates that cRows must be nonnegative.
DBPROP_CANHOLDROWS Type: VT_BOOL
Typical R/W: R
Description: Hold Rows
For this provider, this property is always VARIANT_FALSE.
DBPROP_CANSCROLLBACKWARDS Type: VT_BOOL
Typical R/W: R
Description: Scroll Backward
For this provider, this property is always VARIANT_FALSE, which indicates that IRowsOffset must be nonnegative.
DBPROP_CHANGEINSERTEDROWS Type: VT_BOOL
Typical R/W: R/W
Description: Change Inserted Rows
For this provider, the value is always VARIANT_TRUE, which indicates that the consumer can call IRowsetChange::DeleteRows or IRowsetChange::SetData for newly inserted rows.
A newly inserted row is defined as a row for which the insertion has been transmitted to the data store, as opposed to a pending insert row.
DBPROP_COMMITPRESERVE Type: VT_BOOL
Typical R/W: R only
Description: Preserve On Commit
For this provider, the value is always VARIANT_TRUE, which indicates that after a commit that preserves, the rowset remains active. That is, it is possible to fetch new rows, update, delete, and insert rows, and so on.
DBPROP_DEFERRED Type: VT_BOOL
Typical R/W: R only
Description: Defer Column
For this provider, the value is always VARIANT_TRUE, which indicates that the data in the column is not fetched until an accessor is used on the column.
DBPROP_DELAYSTORAGEOBJECTS Type: VT_BOOL
Typical R/W: R only
Description: Delay Storage Object Updates
For this provider, the value is always VARIANT_TRUE, which indicates that storage objects are also used in delayed update mode.
DBPROP_IAccessor
DBPROP_IColumnsInfo
DBPROP_IConvertType
DBPROP_IRowset
DBPROP_IRowsetChange
DBPROP_IRowsetInfo
DBPROP_IRowsetUpdate
DBPROP_ISupportErrorInfo
DBPROP_IRowsetIndex
DBPROP_IRowsetCurrentIndex
DBPROP_IRowsetBookmark
Type: VT_BOOL
Typical R/W: R/W, except as noted below.
Description:
If the value of any of these properties is set to VARIANT_TRUE, the rowset supports the specified interface. These properties are primarily used to request interfaces through ICommandProperties::SetProperties.
The following properties are read-only and are always VARIANT_TRUE:
DBPROP_IAccessor
DBPROP_IColumnsInfo
DBPROP_IConvertType
DBPROP_IRowset
DBPROP_IRowsetInfo
DBPROP_ISupportErrorInfo
Setting DBPROP_IRowsetUpdate to VARIANT_TRUE automatically sets DBPROP_IRowsetChange to VARIANT_TRUE. Setting DBPROP_IRowsetCurrentIndex to VARIANT_TRUE automatically sets DBPROP_IRowsetIndex to VARIANT_TRUE.
DBPROP_ILockBytes
DBPROP_IsequentialStream
Type: VT_BOOL
Typical R/W: R/W
Description: ILockBytes
ISequentialStream
If the value of this property is set to VARIANT_TRUE, the specified column is treated as a storage object that exposes the specified interface.
DBPROP_IMMOBILEROWS Type: VT_BOOL
Typical R/W: R only
Description: Immobile Rows
For this provider, the value is always VARIANT_FALSE, which indicates that, if the rowset is ordered, inserted rows and updated rows (where one or more of the columns in the ordering criteria are updated) follow the ordering criteria of the rowset. If the rowset is not ordered, inserted rows are not guaranteed to appear in a determinate position, and the position of updated rows is not changed.
This property is meaningful only if DBPROP_OWNINSERT is VARIANT_TRUE.
DBPROP_LOCKMODE TYPE: VT_I4
R/W: R
Description: Lock Mode
For this provider, the value is always DBPROPVAL_LM_SINGLEROW.
DBPROP_MAXOPENROWS Type: VT_I4
Typical R/W: R
Description: Maximum Open Rows
This value is 1 for Microsoft® SQL Server™ 2000 Windows® CE Edition (SQL Server CE).
DBPROP_MAXROWS Type: VT_I4
Typical R/W: R only
Description: Maximum Rows
Specifies the maximum number of rows that can be returned in a rowset. If there is no limit, this value is 0.
For this provider, the value is always 0.
DBPROP_OTHERINSERT Type: VT_BOOL
Typical R/W: R/W
Description: Base Tables are True; others are False.
DBPROP_OTHERUPDATEDELETE Type: VT_BOOL
Typical R/W: R/W
Description: Others' Changes Visible
Specifies either of the following values:
VARIANT_TRUE, which indicates that the rowset can see updates and deletes made by a user other than a consumer of the rowset. For example, suppose a user other than a consumer of the rowset updates the data underlying a row or deletes the row. If the row is released completely, any consumer of the rowset will see that change the next time it fetches the row. This includes updates and deletes made by other parties in the same transaction as well as updates and deletes by parties outside the transaction.
The transaction isolation level does not affect the ability of the rowset to see updates or deletes by other parties in the same transaction, such as other rowsets in the same session. However, it does restrict the ability of the rowset to see updates or deletes by parties outside the transaction.

VARIANT_FALSE, which indicates that the rowset cannot see updates and deletes by others.

DBPROP_OWNINSERT Type: VT_BOOL
Typical R/W: R/W
Description: Own Inserts Visible
DBPROP_OWNUPDATEDELETE Type: VT_BOOL
Typical R/W: R/W
Description: Own Changes Visible
DBPROP_QUICKRESTART Type: VT_BOOL
Typical R/W: R / W
Description: Quick Restart
DBPROP_REMOVEDELETED Type: VT_BOOL
Typical R/W: R
Description: Remove Deleted Rows
For this provider, the value is always VARIANT_TRUE.
DBPROP_REPORTMULTIPLECHANGES Type: VT_BOOL
Typical R/W: R only
Description: Report Multiple Changes
For this provider, the value is always VARIANT_TRUE.
DBPROP_ROWTHREADMODEL Type: VT_I4
Typical R/W: R only
Description: Row Threading Model
Specifies the threading model of the rowsets generated by the command.
For this provider, the value is always DBPROPVAL_RT_FREETHREAD.
DBPROP_SERVERDATAONINSERT TYPE: VT_BOOL
R/W: R
Description: Server Data on Insert
For this provider, the value is always VARIANT_TRUE.
DBPROP_UPDATABILITY Type: VT_I4
Typical R/W: R/W
Description: Updatability
Show:
© 2014 Microsoft