¶
7.5.8.Rowsets
¶
Properties
Table7.26.Supported Rowset Properties
| Property | R/W | Default | Notes |
|---|---|---|---|
| DBPROP_ABORTPRESERVE | Read/Write | ||
| DBPROP_ACCESSORDER | Read-Only | DBPROPVAL_AO_RANDOM | |
| DBPROP_BLOCKINGSTORAGEOBJECTS | Read-Only | VARIANT_TRUE | |
| DBPROP_BOOKMARKINFO | Read-Only | DBPROPVAL_BI_CROSSROWSET | |
| DBPROP_BOOKMARKS | Read/Write | VARIANT_FALSE | |
| DBPROP_BOOKMARKSKIPPED | Read-Only | VARIANT_FALSE | |
| DBPROP_BOOKMARKTYPE | Read-Only | DBPROPVAL_BMK_NUMERIC | |
| DBPROP_CACHEDEFERRED | Read-Only | VARIANT_FALSE | |
| DBPROP_CANFETCHBACKWARDS | Read/Write | VARIANT_FALSE | |
| DBPROP_CANHOLDROWS | Read/Write | VARIANT_FALSE | |
| DBPROP_CANSCROLLBACKWARDS | Read/Write | VARIANT_FALSE | |
| DBPROP_CHANGEINSERTEDROWS | Read-Only | VARIANT_FALSE | |
| DBPROP_COLUMNRESTRICT | Read-Only | VARIANT_FALSE | |
| DBPROP_COMMANDTIMEOUT | Read/Write | ||
| DBPROP_COMMITPRESERVE | Read/Write | VARIANT_FALSE | |
| DBPROP_DEFERRED | Read-Only | VARIANT_FALSE or VARIANT_TRUE | |
| DBPROP_DELAYSTORAGEOBJECTS | Read/Write | VARIANT_FALSE | |
| DBPROP_FINDCOMPAREOPS | Read-Only | 0 | |
| DBPROP_HIDDENCOLUMNS | Read-Only | ||
| DBPROP_IAccessor | Read-Only | VARIANT_TRUE | |
| DBPROP_IColumnsInfo | Read-Only | VARIANT_TRUE | |
| DBPROP_IColumnsRowset | Read/Write | VARIANT_FALSE | |
| DBPROP_IConnectionPointContainer | Read/Write | VARIANT_FALSE | |
| DBPROP_IConvertType | Read-Only | VARIANT_TRUE | |
| DBPROP_IMMOBILEROWS | Read/Write | VARIANT_FALSE | |
| DBPROP_IMultipleResults | Read/Write | VARIANT_FALSE | |
| DBPROP_IRowset | Read-Only | VARIANT_TRUE | |
| DBPROP_IRowsetChange | Read/Write | VARIANT_FALSE | |
| DBPROP_IRowsetIdentity | Read/Write | VARIANT_FALSE | |
| DBPROP_IRowsetInfo | Read-Only | VARIANT_TRUE | |
| DBPROP_IRowsetLocate | Read/Write | VARIANT_FALSE | |
| DBPROP_IRowsetRefresh | Read/Write | VARIANT_FALSE | |
| DBPROP_IRowsetResynch | Read/Write | VARIANT_FALSE | |
| DBPROP_IRowsetScroll | Read/Write | VARIANT_FALSE | |
| DBPROP_IRowsetUpdate | Read/Write | VARIANT_FALSE | |
| DBPROP_ISequentialStream | Read-Only | VARIANT_TRUE | |
| DBPROP_ISupportErrorInfo | Read/Write | VARIANT_FALSE | |
| DBPROP_LITERALBOOKMARKS | Read-Only | VARIANT_FALSE | |
| DBPROP_LITERALIDENTITY | Read-Only | VARIANT_TRUE | |
| DBPROP_LOCKMODE | Read/Write | DBPROPVAL_LM_NONE | |
| DBPROP_MAXOPENROWS | Read-Only | 0 | |
| DBPROP_MAXPENDINGROWS | Read-Only | 0 | |
| DBPROP_MAXROWS | Read/Write | 0 | |
| DBPROP_NOTIFICATIONGRANULARITY | Read-Only | DBPROPVAL_NT_SINGLEROW | |
| DBPROP_NOTIFICATIONPHASES | Read-Only | DBPROPVAL_NP_OKTODO | DBPROPVAL_NP_ABOUTTODO | DBPROPVAL_NP_SYNCHAFTER | DBPROPVAL_NP_FAILEDTODO | DBPROPVAL_NP_DIDEVENT | |
| DBPROP_NOTIFYCOLUMNSET DBPROP_NOTIFYROWDELETE DBPROP_NOTIFYROWFIRSTCHANGE DBPROP_NOTIFYROWINSERT DBPROP_NOTIFYROWRESYNCH DBPROP_NOTIFYROWSETCHANGED DBPROP_NOTIFYROWSETFETCHPOSITIONCHANGE DBPROP_NOTIFYROWSETRELEASE DBPROP_NOTIFYROWUNDOCHANGE DBPROP_NOTIFYROWUNDODELETE DBPROP_NOTIFYROWUNDOINSERT DBPROP_NOTIFYROWUPDATE | Read-Only | DBPROPVAL_NP_OKTODO | DBPROPVAL_NP_ABOUTTODO | DBPROPVAL_NP_SYNCHAFTER | |
| DBPROP_ORDEREDBOOKMARKS | Read/Write | VARIANT_FALSE | |
| DBPROP_OTHERINSERT | Read/Write | VARIANT_FALSE | |
| DBPROP_OTHERUPDATEDELETE | Read/Write | VARIANT_FALSE | |
| DBPROP_OWNINSERT | Read/Write | VARIANT_TRUE | |
| DBPROP_OWNUPDATEDELETE | Read/Write | VARIANT_TRUE | |
| DBPROP_QUICKRESTART | Read/Write | VARIANT_FALSE | |
| DBPROP_REENTRANTEVENTS | Read-Only | VARIANT_FALSE | |
| DBPROP_REMOVEDELETED | Read/Write | VARIANT_FALSE | |
| DBPROP_REPORTMULTIPLECHANGES | Read-Onle | VARIANT_FALSE | |
| DBPROP_RETURNPENDINGINSERTS | Read-Only | VARIANT_FALSE | |
| DBPROP_ROWRESTRICT | Read-Only | VARIANT_FALSE | |
| DBPROP_ROWSET_ASYNCH | Read-Only | VARIANT_FALSE | |
| DBPROP_ROWTHREADMODEL | Read-Only | DBPROPVAL_RT_FREETHREAD | |
| DBPROP_SERVERCURSOR | Read-Only | VARIANT_TRUE | |
| DBPROP_SERVERDATAONINSERT | Read-Only | VARIANT_FALSE | |
| DBPROP_SKIPROWCOUNTRESULTS | Read-Only | VARIANT_TRUE | |
| DBPROP_STRONGIDENTITY | Read-Only | VARIANT_FALSE | |
| DBPROP_TRANSACTEDOBJECT | Reaq-Only | VARIANT_FALSE | |
| DBPROP_UNIQUEROWS | Read/Write | VARIANT_FALSE | |
| DBPROP_UPDATABILITY | Read/Write | 0 |
¶
Interfaces
VIRTOLEDB supports the following rowset interfaces.
Table7.27.Supported Rowset Interfaces
| Interface | Description |
|---|---|
| IAccessor | |
| IColumnsInfo | |
| IConvertType | |
| IRowset | |
| IRowsetChange | |
| IRowsetIdentity | |
| IRowsetInfo | |
| IRowsetLocate | |
| IRowsetScroll | |
| ISupportErrorInfo |