Property ID

Description

DBPROP_ABORTPRESERVE

Type: VT_BOOL

Typical R/W: Read-only

Default: VARIANT_TRUE

Description: The behavior of a rowset after an abort operation is determined by this property. With the Advantage OLE DB Provider, after aborting a transaction, the rowset remains active. That is, it is possible to fetch new rows, update, delete, and insert rows, and so on.

DBPROP_ACCESSORDER

Type: VT_I4

Typical R/W: Read-only

Default: DBPROPVAL_AO_RANDOM

Description: Sets the order in which columns must be accessed on the rowset. For the Advantage OLE DB Provider, this value is always DBPROPVAL_AO_RANDOM meaning columns can be accessed in any order.

DBPROP_BLOCKINGSTORAGEOBJECTS

Type: VT_BOOL

Typical R/W: Read-only

Description: Blocking Storage Objects

Indicates whether storage objects might prevent use of other methods on the rowset. For the Advantage OLE DB Provider, this property is set to VARIANT_FALSE meaning instantiated storage objects do not prevent the use of other methods.

DBPROP_BOOKMARKINFO

Type: VT_I4

Typical R/W: Read-only

Default: 0

Description: A bitmask specifying additional information about bookmarks over the rowset. For the Advantage OLE DB Provider, this value is always zero because bookmarks are not valid across rowsets.

DBPROP_BOOKMARKS

Type: VT_BOOL

Typical R/W: Read-only

Default: VARIANT_TRUE

Description: Indicates whether the rowset supports bookmarks. For the Advantage OLE DB Provider, this value is always VARIANT_TRUE for non-schema rowsets and always VARIANT_FALSE for schema rowsets.

DBPROP_BOOKMARKSKIPPED

Type: VT_BOOL

Typical R/W: Read-only

Default: VARIANT_FALSE

Description: Indicates whether the rowset allows IRowsetLocate::GetRowsAt, IRowsetScroll::GetApproximatePosition, or IRowsetFind::FindNextRow to continue if a bookmark row was deleted. For the Advantage OLE DB Provider, this value is always VARIANT_FALSE meaning DB_E_BADBOOKMARK is returned if a bookmark row is deleted.

DBPROP_BOOKMARKTYPE

Type: VT_I4

Typical R/W: Read-only

Default: DBPROPVAL_BMK_NUMERIC

Description: The bookmark type. The Advantage OLE DB Provider implements numeric bookmarks only. An Advantage OLE DB Provider bookmark is 32-bit unsigned integer, type DBTYPE_UI4.

DBPROP_CACHEDEFERRED

Type: VT_BOOL

Typical R/W: Read-only

Default: VARIANT_FALSE

Description: Cache Deferred Columns. For the Advantage OLE DB Provider, this value is always VARIANT_FALSE because the value of a deferred column is not cached, and multiple calls to IRowset::GetData for the column can return different values.

DBPROP_CANFETCHBACKWARDS

Type: VT_BOOL

Typical R/W: Read/Write

Default: VARIANT_FALSE

Description: Indicates whether the rowset can fetch backward. The Advantage OLE DB Provider supports backward fetching in non-sequential rowsets if this property is set to VARIANT_TRUE. The Advantage OLE DB Provider supports high performance bi-directional recordsets. In cases where the recordset will only be read through in one direction, it is possible to get even higher performance by using a forward-only cursor. If both this property and DBPROP_CANSCROLLBACKWARDS are set to FALSE, then the recordset is assumed to be forward-only, and the Advantage OLE DB provider will use an aggressive read-ahead record caching scheme that can reduce network traffic and improve performance. See Read-Ahead Record Caching for more information.

DBPROP_CANHOLDROWS

Type: VT_BOOL

Typical R/W: Read-only

Default: VARIANT_TRUE

Description: Whether the provider can hold rows. For the Advantage OLE DB Provider, this value is always VARIANT_TRUE because the consumer can retrieve more rows or change the next fetch position, while holding previously fetched rows.

DBPROP_CANSCROLLBACKWARDS

Type: VT_BOOL

Typical R/W: Read/Write

Default: VARIANT_FALSE

Description: Indicates whether the rowset can scroll backward. The Advantage OLE DB Provider supports backward scrolling in non-sequential rowsets if this property is set to VARIANT_TRUE. The Advantage OLE DB Provider supports high performance bi-directional recordsets. In cases where the recordset will only be read through in one direction, it is possible to get even higher performance by using a forward-only cursor. If both this property and DBPROP_CANFETCHBACKWARDS are set to FALSE, then the recordset is assumed to be forward-only, and the Advantage OLE DB provider will use an aggressive read-ahead record caching scheme that can reduce network traffic and improve performance. See Read-Ahead Record Caching for more information.

DBPROP_CHANGEINSERTEDROWS

Type: VT_BOOL

Typical R/W: Read-only

Default: VARIANT_TRUE

Description: Whether inserted rows can be updated. For the Advantage OLE DB Provider, this value is always VARIANT_TRUE because inserted rows can be updated and deleted.

DBPROP_COLUMNRESTRICT

Type: VT_BOOL

Typical R/W: Read-only

Description: Whether access rights are restricted on a column-by-column basis. For the Advantage OLE DB Provider, this value is VARIANT_TRUE if the rowset is an ADT table than contains an AutoIncrement column because AutoIncrement columns cannot be updated. This value is VARIANT_FALSE if the rowset is an ADT table than does not contain an AutoIncrement column or if the rowset is a DBF table.

DBPROP_COMMANDTIMEOUT

Type: VT_I4

Typical R/W: Read/Write

Default: 0

Description: The number of seconds before a command (SQL query) times out and is aborted. The Advantage OLE DB Provider supports timeouts on the ICommand::Execute method and will abort the SQL query after the number of seconds specified by this property if the SQL query has not already completed execution. The default value of 0 means there is no timeout associated with the query.

DBPROP_COMMITPRESERVE

Type: VT_BOOL

Typical R/W: Read-only

Default: VARIANT_TRUE

Description: The behavior of a rowset after a commit operation is determined by this property. With the Advantage OLE DB Provider, after committing a transaction, 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: Read-only

Default: VARIANT_FALSE

Description: When data in a column is fetched. For the Advantage OLE DB Provider, this value is always VARIANT_FALSE because the data in the column is fetched when the row containing it is fetched.

DBPROP_DELAYSTORAGEOBJECTS

Type: VT_BOOL

Typical R/W: Read-only

Description: Delay Storage Object Updates

Specifies whether changes to the storage object (BLOB) are delayed just like non-BLOB data when in delayed update mode. For the Advantage OLE DB Provider, this property is set to VARIANT_FALSE meaning changes to BLOB data are immediately transmitted to the data source object.

DBPROP_HIDDENCOLUMNS

Type: VT_I4

Typical R/W: Read-only

Default: 0

Description: For the Advantage OLE DB Provider, this value is always zero because unique rows are not supported, so no hidden columns are needed to make rows unique.

DBPROP_IAccessor

DBPROP_IColumnsInfo

DBPROP_IConvertType

DBPROP_IRowset

DBPROP_IRowsetInfo

Type: VT_BOOL

Typical R/W: Read-only

Default: VARIANT_TRUE

Description: The Advantage OLE DB Provider supports these interfaces on all rowsets.

DBPROP_IChapteredRowset

DBPROP_IRowsetView

Type: VT_BOOL

Typical R/W: Read-only

Default: VARIANT_TRUE

Description: The Advantage OLE DB Provider exposes the IRowsetView and IChapteredRowset interfaces for non-schema rowsets.

DBPROP_IConnectionPointContainer

Type: VT_BOOL

Typical R/W: Read/Write

Default: VARIANT_TRUE

Description: The Advantage OLE DB Provider supports the IConnectionPointContainer interface for non-schema rowsets.

DBPROP_IRowsetChange

DBPROP_IRowsetUpdate

Type: VT_BOOL

Typical R/W: Read/Write

Default: VARIANT_FALSE

Description: The Advantage OLE DB Provider supports the IRowsetChange and IRowsetUpdate interfaces for non-schema rowsets. A rowset created with DBPROP_IRowsetChange equal to VARIANT_TRUE exhibits immediate update mode behaviors. When DBPROP_IRowsetUpdate is VARIANT_TRUE, DBPROP_IRowsetChange is also VARIANT_TRUE. The rowset exhibits delayed update mode behavior for the current row.

DBPROP_IRowsetIdentity

Type: VT_BOOL

Typical R/W: Read-only

Default: VARIANT_TRUE

Description: The Advantage OLE DB Provider supports the IRowsetIdentity interface. If a rowset supports this interface, any two row handles representing the same underlying row will always reflect the same data and state. Consumers can call the IRowsetIdentity::IsSameRow method to compare two row handles to see whether they refer to the same row instance.

DBPROP_IRowsetIndex

DBPROP_IRowsetCurrentIndex

Type: VT_BOOL

Typical R/W: Read-only

Default: VARIANT_TRUE

Description: The Advantage OLE DB Provider supports the IRowsetIndex and IRowsetCurrentIndex interfaces for non-schema rowsets. Advantage supports getting and setting the current index order, seeking within an index order, and setting a range on an index order.

DBPROP_IRowsetLocate

DBPROP_IRowsetScroll

DBPROP_IRowsetExactScroll

Type: VT_BOOL

Typical R/W: Read-only

Default: VARIANT_TRUE

Description: The Advantage OLE DB Provider can expose the IRowsetLocate and IRowsetScroll interfaces for non-schema rowsets.

DBPROP_IRowsetRefresh

Type: VT_BOOL

Typical R/W: Read-only

Default: VARIANT_TRUE

Description: The Advantage OLE DB Provider exposes the IRowsetRefresh interface for non-schema rowsets.

DBPROP_ISequentialStream

Type: VT_BOOL

Typical R/W: Read-only

Description: ISequentialStream interface

For the Advantage OLE DB Provider, this property is set to VARIANT_TRUE meaning the rowset is capable of manipulating the contents of columns as a storage object supporting ISequentialStream.

DBPROP_ISupportErrorInfo

Type: VT_BOOL

Typical R/W: Read-only

Default: VARIANT_TRUE

Description: The Advantage OLE DB Provider exposes the ISupportErrorInfo interface on non-schema rowsets.

DBPROP_IColumnsRowset

Type: VT_BOOL

Typical R/W: Read-only

Default: VARIANT_TRUE for rowsets opened through IOpenRowset, VARIANT_FALSE for rowsets opened through ICommand.

Description: The Advantage OLE DB Provider supports this interface on rowsets opened through IOpenRowset::OpenRowset (rowsets opened with adCmdTableDirect in ADO). It is not supported on rowsets created through command objects (ICommand::Execute).

DBPROP_IMMOBILEROWS

Type: VT_BOOL

Typical R/W: Read-only

Default: VARIANT_FALSE

Description: For the Advantage OLE DB Provider, this value is always VARIANT_FALSE, which means if the rowset is ordered, inserted rows appear in the rowset's proper order. If the rowset is not ordered, the inserted row appears at the end. If IRowsetChange::SetData changes a column that is used to order the rowset, the row is moved. (If the rowset is not ordered, the position of the row is not changed.)

DBPROP_LITERALBOOKMARKS

Type: VT_BOOL

Typical R/W: Read-only

Default: VARIANT_TRUE

Description: For the Advantage OLE DB Provider, this value is always VARIANT_TRUE, which means that bookmarks can be compared literally. That is, they can be compared as a sequence of bytes.

DBPROP_LITERALIDENTITY

Type: VT_BOOL

Typical R/W: Read-only

Default: VARIANT_TRUE

Description: For the Advantage OLE DB Provider, this value is always VARIANT_TRUE, which means the consumer can perform a binary comparison of two row handles to determine whether they point to the same row.

DBPROP_LOCKMODE

Type: VT_I4

Typical R/W: Read-only

Default: DBPROPVAL_LM_SINGLEROW

Description: For the Advantage OLE DB Provider, this value is always DBPROPVAL_LM_SINGLEROW, which means the provider uses the minimum level of locking necessary to ensure that changes successfully written to a single row returned by the most recent fetch will not fail due to a concurrency violation. Therefore, when using deferred update mode, IRowsetUpdate::Update will not fail due to a concurrency violation. The provider takes a lock on the row when IRowsetChange::SetData is first called on the row. The implications of DBPROPVAL_LM_SINGLEROW, and DBPROP_LOCKMODE in general, are the same in both immediate and deferred update modes.

DBPROP_MAXOPENROWS

Type: VT_I4

Typical R/W: Read-only

Default: 0

Description: The Advantage OLE DB Provider does not limit the number of rows that can be active in rowsets.

DBPROP_MAXPENDINGROWS

Type: VT_I4

Typical R/W: Read-only

Default: 1

Description: The Advantage OLE DB Provider limits the number of rowset rows with changes pending to one.

DBPROP_MAXROWS

Type: VT_I4

Typical R/W: Read-only

Default: 0

Description: The Advantage OLE DB Provider does not limit the number of rows in a rowset.

DBPROP_NOTIFICATIONGRANULARITY

Type: VT_I4

Typical R/W: Read-only

Default: DBPROPVAL_NT_MULTIPLEROWS

Description: For methods that operate on multiple rows, the Advantage OLE DB Provider calls IRowsetNotify::OnRowChange once for all rows that succeed and once for all rows that fail.

DBPROP_NOTIFICATIONPHASES

Type: VT_I4

Typical R/W: Read-only

Default: DBPROPVAL_NP_OKTODO | DBPROPVAL_NP_ABOUTTODO | DBPROPVAL_NP_SYNCHAFTER | DBPROPVAL_NP_FAILEDTODO | DBPROPVAL_NP_DIDEVENT

Description: The Advantage OLE DB Provider supports all notification phases.

DBPROP_NOTIFYCOLUMNSET

DBPROP_NOTIFYROWDELETE

DBPROP_NOTIFYROWFIRSTCHANGE

DBPROP_NOTIFYROWINSERT

DBPROP_NOTIFYROWRESYNCH

DBPROP_NOTIFYROWSETCHANGED

DBPROP_NOTIFYROWSETFETCHPOSITIONCHANGE

DBPROP_NOTIFYROWSETRELEASE

DBPROP_NOTIFYROWUNDOCHANGE

DBPROP_NOTIFYROWUNDODELETE

DBPROP_NOTIFYROWUNDOINSERT

DBPROP_NOTIFYROWUPDATE

Type: VT_I4

Typical R/W: Read-only

Default: DBPROPVAL_NP_OKTODO | DBPROPVAL_NP_ABOUTTODO

Description: The Advantage OLE DB Provider supports cancellation at the DBPROPVAL_NP_OKTODO and DBPROPVAL_NP_ABOUTTODO phases for all events.

DBPROP_ORDEREDBOOKMARKS

Type: VT_BOOL

Typical R/W: Read-only

Default: VARIANT_FALSE

Description: For the Advantage OLE DB Provider, this value is always VARIANT_FALSE, which means that bookmarks can be compared only for equality.

DBPROP_OTHERINSERT

DBPROP_OTHERUPDATEDELETE

DBPROP_OWNINSERT

DBPROP_OWNUPDATEDELETE

Type: VT_BOOL

Typical R/W: Read-only

Default: VARIANT_TRUE

Description: For the Advantage OLE DB Provider, this value is always VARIANT_TRUE for rowsets opened via IOpenRowset which means rowsets can see our and others updates, inserts, and deletes. For rowsets opened via the command object, the value will depend upon whether a dynamic or static cursor is returned.

DBPROP_QUICKRESTART

Type: VT_BOOL

Typical R/W: Read-only

Default: VARIANT_TRUE

Description: For the Advantage OLE DB Provider, this value is always VARIANT_TRUE which means IRowset::RestartPosition is relatively quick to execute.

DBPROP_REENTRANTEVENTS

Type: VT_BOOL

Typical R/W: Read-only

Default: VARIANT_FALSE

Description: The Advantage OLE DB Provider does not support reentrancy during notifications.

DBPROP_REMOVEDELETED

Type: VT_BOOL

Typical R/W: Read-only

Description: The Advantage OLE DB Provider alters the value of the property based on the table type being used and the ShowDeleted setting for DBF tables. When the rowset is an ADT table, this value will be VARIANT_TRUE. When the rowset is a DBF table, and the ShowDeleted setting is FALSE, this value will be VARIANT_TRUE. When the rowset is a DBF table, and the ShowDeleted setting is TRUE, this value will be VARIANT_FALSE.

DBPROP_REPORTMULTIPLECHANGES

Type: VT_BOOL

Typical R/W: Read-only

Default: VARIANT_FALSE

Description: For the Advantage OLE DB Provider, this value is always VARIANT_FALSE, which means an update or delete always affects a single row.

DBPROP_RETURNPENDINGINSERTS

Type: VT_BOOL

Typical R/W: Read-only

Default: VARIANT_FALSE

Description: When a method that fetches rows is called, the Advantage OLE DB Provider does not return pending insert rows.

DBPROP_ROWRESTRICT

Type: VT_BOOL

Typical R/W: Read-only

Default: VARIANT_FALSE

Description: The Advantage OLE DB Provider rowsets do not support access rights based on the row. If the IRowsetChange interface is exposed on a rowset, the SetData method can be called by the consumer.

DBPROP_ROWTHREADMODEL

Type: VT_BOOL

Typical R/W: Read-only

Default: DBPROPVAL_RT_FREETHREAD

Description: A bitmask specifying the threading models supported by the rowset. For the Advantage OLE DB Provider, this value is always DBPROPVAL_RT_FREETHREAD.

DBPROP_STRONGIDENTITY

Type: VT_BOOL

Typical R/W: Read-only

Default: VARIANT_TRUE

Description: Strong row identity. For the Advantage OLE DB Provider, this value is always VARIANT_TRUE because the handles of newly inserted rows can be compared as specified by DBPROP_LITERALIDENTITY.

DBPROP_UNIQUEROWS

Type: VT_BOOL

Typical R/W: Read-only

Description: Whether rows in the rowset may or may not be uniquely identified by their column values. For the Advantage OLE DB Provider, this value is VARIANT_TRUE if the rowset is an ADT or VFP (Visual FoxPro) table than contains an AutoIncrement column because rowsets with AutoIncrement columns are guaranteed to be unique. It is also TRUE if the table contains a RowVersion column. Other wise this value is VARIANT_FALSE.

DBPROP_UPDATABILITY

Type: VT_I4

Typical R/W: Read/Write

Default: DBPROPVAL_UP_CHANGE | DBPROPVAL_UP_DELETE | DBPROPVAL_UP_INSERT

Description: The Advantage OLE DB Provider supports all DBPROP_UPDATABILITY values. Setting DBPROP_UPDATABILITY does not create a modifiable rowset. To make a rowset modifiable, set DBPROP_IRowsetChange or DBPROP_IRowsetUpdate.