|
Property Name
|
Default Value and Description
|
|
DBPROP_ABORTPRESERVE
|
The value depends on the OpenAccess service you are using.
|
|
DBPROP_ACCESSORDER
|
VALUE=DBPROPVAL_AO_SEQUENTIALSTORAGEOBJECTS
Columns 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.
|