MDAC 2.5 SDK - OLE DB Providers
OLE DB Provider for Microsoft Jet
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_JETOLEDB_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 an abort or an abort that preserves, the only operations allowed on a rowset are to release row and accessor handles and to release the rowset. |
DBPROP_APPENDONLY | Type: VT_BOOL
Typical R/W: R/W Description: Append-Only Rowset If the value is VARIANT_TRUE, when a rowset is opened it will initially be empty. If the rowset was obtained by IOpenRowset::OpenRowset, this is equivalent to positioning the start of the rowset at the end of the table. If the rowset was obtained by executing a command, this is equivalent to placing the start of the rowset at the end of the command's results. A rowset opened with VARIANT_TRUE will be populated only by those rows inserted in it. DBPROP_APPENDONLY set to VARIANT_TRUE implies:
|
DBPROP_BLOCKINGSTORAGEOBJECTS | Type: VT_BOOL
Typical R/W: R only Description: Blocking Storage Objects Specifies whether storage objects might prevent use of other methods on the rowset. For this provider, the value is always VARIANT_TRUE, which indicates that, after creating an instance of a storage object, the use of other methods on the rowset might be prevented. That is, after a storage object is created and before it is released, methods other than those on the storage objects might return E_UNEXPECTED.
|
DBPROP_BOOKMARKS | Type: VT_BOOL
Typical R/W: R/W Description: Use Bookmarks Specifies whether the rowset supports bookmarks; that is:
|
DBPROP_BOOKMARKSKIPPED | Type: VT_BOOL
Typical R/W: R only Description: Skip Deleted Bookmarks Specifies whether the rowset allows IRowsetLocate::GetRowsAt or IRowsetFind::FindNextRow to continue if a bookmark row was deleted, is a row to which the consumer does not have access rights, or is no longer a member of the rowset. For this provider, the value is always VARIANT_FALSE, which indicates that GetRowsAt or FindNextRow returns DB_E_BADBOOKMARK. |
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 instance, 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. The validity of numeric bookmarks is not changed by modifying the row's columns. |
DBPROP_CACHEDEFERRED | Type: VT_BOOL
Typical R/W: R only Description: Cache Deferred Columns
|
DBPROP_CANFETCHBACKWARDS | Type: VT_BOOL
Typical R/W: R/W Description: Fetch Backward Specifies whether the rowset can fetch backward; that is:
|
DBPROP_CANHOLDROWS | Type: VT_BOOL
Typical R/W: R/W Description: Hold Rows Specifies values as either:
|
DBPROP_CANSCROLLBACKWARDS | Type: VT_BOOL
Typical R/W: R/W Description: Scroll Backward Specifies whether the rowset can scroll backward; that is:
If the rowset supports IRowsetLocate, the value of this property is VARIANT_TRUE, because this method supports backward scrolling by definition. |
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_COLUMNRESTRICT | Type: VT_BOOL
Typical R/W: R only Description: Column Privileges For this provider, the value is always VARIANT_TRUE, which indicates that access rights are restricted on a column-by-column basis. If the rowset exposes IRowsetChange, IRowsetChange::SetData cannot be called for at least one column. A provider must not execute a query that would specify a column for which the consumer has no read access rights. |
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: Storage objects are also used in delayed update mode. |
DBPROP_IAccessor
DBPROP_IColumnsInfo DBPROP_IColumnsRowset DBPROP_IConnectionPointContainer DBPROP_IConvertType DBPROP_IRowset DBPROP_IRowsetChange DBPROP_IRowsetIdentity DBPROP_IRowsetInfo DBPROP_IRowsetLocate DBPROP_IRowsetResynch DBPROP_IRowsetScroll DBPROP_IRowsetUpdate DBPROP_ISupportErrorInfo DBPROP_IRowsetIndex |
Type: VT_BOOL
Typical R/W: R/W, except as noted below. Description: IAccessor IColumnsInfo IColumnsRowset IConnectionPointContainer IConvertType IRowset IRowsetChange IRowsetIdentity IRowsetInfo IRowsetLocate IRowsetResynch IRowsetScroll IRowsetUpdate ISupportErrorInfo IRowsetIndex IRowsetSetIndex 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 values of the DBPROP_IRowset, DBPROP_IAccessor, and DBPROP_IRowsetInfo properties are read-only and are always VARIANT_TRUE. They cannot be set to VARIANT_FALSE. If the consumer does not set the value of any of these properties to True, the resulting rowset supports IRowset, IAccessor, IColumnsInfo, IConvertType, and IRowsetInfo. Setting DBPROP_IRowsetLocate to VARIANT_TRUE automatically sets DBPROP_BOOKMARKS to VARIANT_TRUE. Setting DBPROP_IRowsetUpdate to VARIANT_TRUE automatically sets DBPROP_IRowsetChange 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) obey 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_LITERALBOOKMARKS | Type: VT_BOOL
Typical R/W: R only Description: Literal Bookmarks
|
DBPROP_LITERALIDENTITY | Type: VT_BOOL
Typical R/W: R only Description: Literal Row Identity
|
DBPROP_MAXOPENROWS | Type: VT_I4
Typical R/W: R/W Description: Maximum Open Rows Specifies the maximum number of rows that can be active at the same time. This limit does not reflect resource limitations such as RAM but does apply if the rowset implementation uses some strategy that results in a limit. If there is no limit, the value of this property is zero. |
DBPROP_MAXPENDINGROWS | Type: VT_I4
Typical R/W: R only Description: Maximum Pending Rows Specifies the maximum number of rows that can have pending changes at the same time. This limit does not reflect resource limitations such as RAM but does apply if the rowset implementation uses some strategy that results in a limit. If there is no limit, this value is zero. For this provider, the value is always 1. |
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_MAYWRITECOLUMN | Type: VT_BOOL
Typical R/W: R only Description: Column Writable Specifies whether a particular column is writable. This property can be set implicitly through the command used to create the rowset. For example, if the rowset is created by the SQL statement SELECT A,B FROM MyTable FOR UPDATE OF A, this property is VARIANT_TRUE for column A and VARIANT_FALSE for column B. For this provider, the value is always V_FALSE. |
DBPROP_MEMORYUSAGE | Type: VT_I4
Typical R/W: R only Description: Memory Usage Estimates the amount of memory that can be used by the rowset. If it is 0, the rowset can use unlimited memory. If it is 1–99 inclusive, the rowset can use the specified percentage of total available virtual memory (physical and page file). If it is greater than or equal to 100, the rowset can use up to the specified number of kilobytes of memory. |
DBPROP_NOTIFICATIONGRANULARITY | Type: VT_I4
Typical R/W: R only Description: Notification Granularity
|
DBPROP_NOTIFICATIONPHASES | Type: VT_I4
Typical R/W: R only Description: Notification Phases Specifies a bitmask that indicates the notification phases supported by the provider. This provider sets the following:
|
DBPROP_NOTIFYCOLUMNSET
DBPROP_NOTIFYROWDELETE DBPROP_NOTIFYROWFIRSTCHANGE DBPROP_NOTIFYROWINSERT DBPROP_NOTIFYROWRESYNCH DBPROP_NOTIFYROWSETFETCHPOSITIONCHANGE DBPROP_NOTIFYROWSETRELEASE DBPROP_NOTIFYROWUNDOCHANGE DBPROP_NOTIFYROWUNDODELETE DBPROP_NOTIFYROWUNDOINSERT DBPROP_NOTIFYROWUPDATE |
Type: VT_I4
Typical R/W: R only Description: Column Set Notification Row Delete Notification Row First Change Notification Row Insert Notification Row Resynchronization Rowset Release Notification Rowset Fetch Position Change Row Undo Change Notification Row Undo Delete Notification Row Undo Insert Notification Row Update Notification Specifies a bitmask that indicates whether the notification phase can be canceled. This provider returns all flags for the above properties:
|
DBPROP_ORDEREDBOOKMARKS | Type: VT_BOOL
Typical R/W: R only Description: Bookmarks Ordered
|
DBPROP_OTHERINSERT | Type: VT_BOOL
Typical R/W: R only Description: Others' Inserts Visible |
DBPROP_OTHERUPDATEDELETE | Type: VT_BOOL
Typical R/W: R/W Description: Others' Changes Visible Specifies values as either:
|
DBPROP_OWNINSERT | Type: VT_BOOL
Typical R/W: R/W Description: Own Inserts Visible Specifies values as either:
|
DBPROP_OWNUPDATEDELETE | Type: VT_BOOL
Typical R/W: R/W Description: Own Changes Visible Specifies values as either:
|
DBPROP_QUICKRESTART | Type: VT_BOOL
Typical R/W: R/W Description: Quick Restart Specifies values as either:
|
DBPROP_REENTRANTEVENTS | Type: VT_BOOL
Typical R/W: R only Description: Reentrant events
|
DBPROP_REMOVEDELETED | Type: VT_BOOL
Typical R/W: R/W 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
|
DBPROP_RETURNPENDINGINSERTS | Type: VT_BOOL
Typical R/W: R only Description: Return Pending Inserts
|
DBPROP_ROWRESTRICT | Type: VT_BOOL
Typical R/W: R only Description: Row Privileges
|
DBPROP_ROWSET_ASYNCH | Type: VT_I4
Typical R/W: R/W Description: Asynchronous Rowset Processing Specifies a bitmask that indicates the asynchronous processing performed on the rowset. For this provider, no bits are set (the default). The rowset is initialized and populated synchronously. All requested interfaces are available when the method requesting the rowset returns, and requesting rows block until the requested number of hRows are obtained or until the end of the rowset is reached. |
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.
|
DBPROP_STRONGIDENTITY | Type: VT_BOOL
Typical R/W: R only Description: Strong Row Identity For this provider, the value is always VARIANT_FALSE, which indicates that there is no guarantee that the handles of newly inserted rows can be compared successfully. In this case, IRowsetIdentity::IsSameRow might return DB_E_NEWLYINSERTED. |
DBPROP_TRANSACTEDOBJECT | Type: VT_BOOL
Typical R/W: R only Description: Objects Transacted Specifies values as either:
If this property is set on a column that does not contain an object, it is ignored. |
DBPROP_UPDATABILITY | Type: VT_I4
Typical R/W: R/W Description: Updatability Specifies a bitmask that indicates the supported methods on IRowsetChange; that is, zero or more of:
|