Rowset Property Group
- Last Updated: May 12, 2026
- 3 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
OLE DB data consumers can request certain properties to be satisfied by the rowsets that result from an OpenRowset or ICommand::Execute call. Common properties include the set of interfaces to be supported by the resulting rowset.
The ADO Client supports the IRowsetIdentity interface. This allows the data consumer to determine when two row handles represent the same underlying data.
The following table provides the properties that are included in the ADO Client properties group. The table shows the initial default values. Some of these properties can be changed at the Command level (through ICommandProperties->SetProperties) or Session level (through IOpenRowset). The resulting rowset will contain different values for these properties.
Rowset Properties Supported by the ADO Client
| Property Name | Default Value and Description |
| DBPROP_ABORTPRESERVE | The value depends on the OpenAccess service you are using. |
| DBPROP_ACCESSORDER | VALUE=DBPROPVAL_AO_SEQUENTIALSTORAGEOBJECTSColumns bound as storage objects can only be accessed in sequential order as determined by the column ordinal. |
| DBPROP_BLOCKINGSTORAGEOBJECTS | VALUE=VARIANT_FALSE. Instantiated storage objects do not prevent the use of other methods. |
| DBPROP_BOOKMARKINFO | VALUE=DBPROPVAL_BI_CROSSROWSET (if bookmarks are supported) VALUE=0 (if bookmarks are not supported) |
| DBPROP_BOOKMARKS | VALUE=FALSE. The rowset does not support bookmarks. |
| DBPROP_BOOKMARKSKIPPED | VALUE=VARIANT_FALSE. GetRowsAt, GetApproximatePosition, or FindNextRow returns DB_E_BADBOOKMARK. |
| DBPROP_BOOKMARKTYPE | VALUE=DBPROPVAL_BMK_NUMERIC. The bookmark type is numeric. |
| DBPROP_CANFETCHBACKWARDS | VALUE=VARIANT_FALSE. cRows must be non-negative. |
| DBPROP_CANHOLDROWS | VALUE=VARIANT_FALSE. The rowset might require pending changes to be transmitted to the data store before fetching additional rows. |
| DBPROP_CANSCROLLBACKWARDS | VALUE=VARIANT_FALSE. IRowsOffset must be non-negative. |
| DBPROP_CHANGEINSERTEDROWS | VALUE=VARIANT_FALSE. DeleteRows returns a status of DBROWSTATUS_E_NEWLYINSERTED for newly inserted rows, and SetData returns DB_E_NEWLYINSERTED. |
| DBPROP_COLUMNRESTRICT | Specifies whether access rights are restricted on a column-by-column basis.VALUE=VARIANT_TRUE. Access rights are restricted on a column-by-column basis. VALUE=VARIANT_FALSE. Access rights are not restricted on a column-by-column basis. |
| DBPROP_COMMITPRESERVE | The value is specific to the OpenAccess SDK Server you are using. |
| DBPROP_DELAYSTORAGEOBJECTS | VALUE=VARIANT_FALSE. Storage objects are used in immediate update mode. |
| DBPROP_IAccessor | VALUE=VARIANT_TRUE |
| DBPROP_IColumnsInfo | VALUE=VARIANT_TRUE |
| DBPROP_IColumnsRowset | VALUE=VARIANT_TRUE |
| DBPROP_IConvertType | VALUE=VARIANT_TRUE |
| DBPROP_IMultipleResults | VALUE=VARIANT_FALSE |
| DBPROP_IRowset | VALUE=VARIANT_TRUE |
| DBPROP_IRowsetChange | VALUE=VARIANT_TRUE |
| DBPROP_IRowsetIdentity | VALUE=VARIANT_FALSE |
| DBPROP_IRowsetInfo | VALUE=VARIANT_TRUE |
| DBPROP_IRowsetLocate | VALUE=VARIANT_TRUE |
| DBPROP_IRowsetRefresh | VALUE=VARIANT_FALSE |
| DBPROP_IRowsetScroll | VALUE=VARIANT_FALSE |
| DBPROP_IRowsetUpdate | VALUE=VARIANT_FALSE |
| DBPROP_ISequentialStream | VALUE=VARIANT_FALSE |
| DBPROP_ISupportErrorInfo | VALUE=VARIANT_TRUE |
| DBPROP_IMMOBILEROWS | VALUE=VARIANT_TRUE. The rowset will not reorder inserted or updated rows. |
| DBPROP_LITERALBOOKMARKS | VALUE=VARIANT_FALSE. Bookmarks can only be compared with IRowsetLocate::Compare. |
| DBPROP_LITERALIDENTITY | VALUE=VARIANT_FALSE. The consumer must call IRowsetIdentity::IsSameRow to determine whether two row handles point to the same row. |
| DBPROP_LOCKMODE | VALUE=DBPROPVAL_LM_NONE. The ADO Client is not required to lock rows to ensure successful updates. |
| DBPROP_MAXOPENROWS | Specifies the maximum number of rows that can be active at the same time. VALUE=4096 |
| DBPROP_MAXPENDINGROWS | VALUE=0. There is no limit on the number of rows that can have pending changes at the same time. |
| DBPROP_MAXROWS | VALUE=0. There is no limit on the number of rows that can be returned in a rowset. |
| DBPROP_MEMORYUSAGE | VALUE=0. There is no limit on the amount of memory that the rowset can use. |
| DBPROP_OTHERINSERT | VALUE=VARIANT_FALSE. The rowset cannot see updates and deletes made by others. |
| DBPROP_OTHERUPDATEDELETE | VALUE=VARIANT_FALSE. The rowset cannot see updates and deletes made by others. |
| DBPROP_OWNINSERT | VALUE=VARIANT_FALSE. The rowset cannot see rows inserted by consumers of the rowset unless the command is executed again. |
| DBPROP_OWNUPDATEDELETE | VALUE=VARIANT_FALSE. The rowset cannot see updates and deletes made by consumers of the rowset unless the command is executed again. |
| DBPROP_QUICKRESTART | VALUE=VARIANT_TRUE. IRowset::RestartPosition is not expensive to execute and does not execute the command that created the rowset again. |
| DBPROP_REENTRANTEVENTS | VALUE=VARIANT_TRUE. The ADO Client supports reentrancy during callbacks to the IRowsetNotify interface. |
| DBPROP_REMOVEDELETED | VALUE=VARIANT_FALSE. Static cursors do not remove deleted rows. |
| DBPROP_REPORTMULTIPLECHANGES | VALUE=VARIANT_FALSE. An update or delete always affects a single row or the ADO Client cannot detect whether it affects multiple rows. |
| DBPROP_RETURNPENDINGINSERTS | VALUE=VARIANT_FALSE. The methods that fetch rows cannot return pending insert rows. |
| DBPROP_ROWRESTRICT | VALUE=VARIANT_FALSE. Access rights are not restricted on a row-by-row basis. |
| DBPROP_ROWTHREADMODEL | VALUE=DBPROPVAL_RT_FREETHREAD. The ADO Client uses the free-threaded model. |
| DBPROP_SERVERCURSOR | VALUE=VARIANT_FALSE. The data provider determines where to locate the cursor. |
| DBPROP_STRONGIDENTITY | VALUE=VARIANT_FALSE. There is no guarantee that the handles of newly inserted rows can be compared successfully. |
| DBPROP_TRANSACTEDOBJECT | VALUE=VARIANT_FALSE. Any object created on the specified column is not transacted. |
| DBPROP_UNIQUEROWS | VALUE=VARIANT_FALSE. Rows in the rowset may or may not be uniquely identified by their column values. |
| DBPROP_UPDATABILITY | A combination of zero or one or more of the following:Value=DBPROPVAL_UP_CHANGE. SetData is supported.Value=DBPROPVAL_UP_DELETE. DeleteRows is supported.Value=DBPROPVAL_UP_INSERT. InsertRow is supported. |