OLE DB Programmer's Reference |
The properties listed in this section are contained in the designated property sets and property groups. (For a listing of properties organized by property group, see "Properties by Property Groups.") The "Column?" designation for Rowset properties states whether the property can be set on individual columns or only on the rowset as a whole.
Important The "Typical R/W" value for each property specifies whether that property can typically be read or written. Whether a particular property can actually be read or written is provider-specific and is returned in the dwPropFlags element of the DBPROPINFO structure.
DBPROP_ABORTPRESERVE | DBPROP_IRowsetScroll |
DBPROP_ACCESSORDER | DBPROP_IRowsetUpdate |
DBPROP_ACTIVESESSIONS | DBPROP_IRowsetView |
DBPROP_ALTERCOLUMN | DBPROP_IScopedOperations |
DBPROP_APPENDONLY | DBPROP_ISequentialStream |
DBPROP_ASYNCTXNABORT | DBPROP_IStorage |
DBPROP_ASYNCTXNCOMMIT | DBPROP_IStream |
DBPROP_AUTH_CACHE_AUTHINFO | DBPROP_ISupportErrorInfo |
DBPROP_AUTH_ENCRYPT_PASSWORD | DBPROP_IViewChapter |
DBPROP_AUTH_INTEGRATED | DBPROP_IViewFilter |
DBPROP_AUTH_MASK_PASSWORD | DBPROP_IViewRowset |
DBPROP_AUTH_PASSWORD | DBPROP_IViewSort |
DBPROP_AUTH_PERSIST_ENCRYPTED | DBPROP_LITERALBOOKMARKS |
DBPROP_AUTH_PERSIST_SENSITIVE_AUTHINFO | DBPROP_LITERALIDENTITY |
DBPROP_AUTH_USERID | DBPROP_LOCKMODE |
DBPROP_BLOCKINGSTORAGEOBJECTS | DBPROP_MAXINDEXSIZE |
DBPROP_BOOKMARKINFO | DBPROP_MAXOPENCHAPTERS |
DBPROP_BOOKMARKS | DBPROP_MAXOPENROWS |
DBPROP_BOOKMARKSKIPPED | DBPROP_MAXORSINFILTER |
DBPROP_BOOKMARKTYPE | DBPROP_MAXPENDINGROWS |
DBPROP_BYREFACCESSORS | DBPROP_MAXROWS |
DBPROP_CACHEDEFERRED | DBPROP_MAXROWSIZE |
DBPROP_CANFETCHBACKWARDS | DBPROP_MAXROWSIZEINCLUDESBLOB |
DBPROP_CANHOLDROWS | DBPROP_MAXSORTCOLUMNS |
DBPROP_CANSCROLLBACKWARDS | DBPROP_MAXTABLESINSELECT |
DBPROP_CATALOGLOCATION | DBPROP_MAYWRITECOLUMN |
DBPROP_CATALOGTERM | DBPROP_MEMORYUSAGE |
DBPROP_CATALOGUSAGE | DBPROP_MULTIPLECONNECTIONS |
DBPROP_CHANGEINSERTEDROWS | DBPROP_MULTIPLEPARAMSETS |
DBPROP_CLIENTCURSOR | DBPROP_MULTIPLERESULTS |
DBPROP_COL_AUTOINCREMENT | DBPROP_MULTIPLESTORAGEOBJECTS |
DBPROP_COL_DEFAULT | DBPROP_MULTITABLEUPDATE |
DBPROP_COL_DESCRIPTION | DBPROP_NOTIFICATIONGRANULARITY |
DBPROP_COL_FIXEDLENGTH | DBPROP_NOTIFICATIONPHASES |
DBPROP_COL_INCREMENT | DBPROP_NOTIFYCOLUMNSET |
DBPROP_COL_ISLONG | DBPROP_NOTIFYROWDELETE |
DBPROP_COL_NULLABLE | DBPROP_NOTIFYROWFIRSTCHANGE |
DBPROP_COL_PRIMARYKEY | DBPROP_NOTIFYROWINSERT |
DBPROP_COL_SEED | DBPROP_NOTIFYROWRESYNCH |
DBPROP_COL_UNIQUE | DBPROP_NOTIFYROWSETCHANGED |
DBPROP_COLUMNDEFINITION | DBPROP_NOTIFYROWSETFETCHPOSITIONCHANGE |
DBPROP_COLUMNLCID | DBPROP_NOTIFYROWSETRELEASE |
DBPROP_COLUMNRESTRICT | DBPROP_NOTIFYROWUNDOCHANGE |
DBPROP_COMMANDTIMEOUT | DBPROP_NOTIFYROWUNDODELETE |
DBPROP_COMMITPRESERVE | DBPROP_NOTIFYROWUNDOINSERT |
DBPROP_COMSERVICES | DBPROP_NOTIFYROWUPDATE |
DBPROP_CONCATNULLBEHAVIOR | DBPROP_NULLCOLLATION |
DBPROP_CONNECTIONSTATUS | DBPROP_OLEOBJECTS |
DBPROP_CURRENTCATALOG | DBPROP_OPENROWSETSUPPORT |
DBPROP_DATASOURCENAME | DBPROP_ORDERBYCOLUMNSINSELECT |
DBPROP_DATASOURCEREADONLY | DBPROP_ORDEREDBOOKMARKS |
DBPROP_DATASOURCE_TYPE | DBPROP_OTHERINSERT |
DBPROP_DBMSNAME | DBPROP_OTHERUPDATEDELETE |
DBPROP_DBMSVER | DBPROP_OUTPUTENCODING |
DBPROP_DEFERRED | DBPROP_OUTPUTPARAMETERAVAILABILITY |
DBPROP_DELAYSTORAGEOBJECTS | DBPROP_OUTPUTSTREAM |
DBPROP_DSOTHREADMODEL | DBPROP_OWNINSERT |
DBPROP_FILTERCOMPAREOPS | DBPROP_OWNUPDATEDELETE |
DBPROP_FINDCOMPAREOPS | DBPROP_PERSISTENTIDTYPE |
DBPROP_GENERATEURL | DBPROP_PREPAREABORTBEHAVIOR |
DBPROP_GROUPBY | DBPROP_PREPARECOMMITBEHAVIOR |
DBPROP_HETEROGENEOUSTABLES | DBPROP_PROCEDURETERM |
DBPROP_HIDDENCOLUMNS | DBPROP_PROVIDERFRIENDLYNAME |
DBPROP_IAccessor | DBPROP_PROVIDERMEMORY |
DBPROP_IBindResource | DBPROP_PROVIDERFILENAME |
DBPROP_IChapteredRowset | DBPROP_PROVIDEROLEDBVER |
DBPROP_IColumnsInfo | DBPROP_PROVIDERVER |
DBPROP_IColumnsInfo2 | DBPROP_QUICKRESTART |
DBPROP_IColumnsRowset | DBPROP_QUOTEDIDENTIFIERCASE |
DBPROP_IConnectionPointContainer | DBPROP_REENTRANTEVENTS |
DBPROP_IConvertType | DBPROP_REMOVEDELETED |
DBPROP_ICreateRow | DBPROP_REPORTMULTIPLECHANGES |
DBPROP_IDBAsynchStatus | DBPROP_RESETDATASOURCE |
DBPROP_IDENTIFIERCASE | DBPROP_RETURNPENDINGINSERTS |
DBPROP_IGetRow | DBPROP_ROW_BULKOPS |
DBPROP_IGetSession | DBPROP_ROWRESTRICT |
DBPROP_IGetSourceRow | DBPROP_ROWSET_ASYNCH |
DBPROP_ILockBytes | DBPROP_ROWSETCONVERSIONSONCOMMAND |
DBPROP_IMMOBILEROWS | DBPROP_ROWTHREADMODEL |
DBPROP_IMultipleResults | DBPROP_SCHEMATERM |
DBPROP_INDEX_AUTOUPDATE | DBPROP_SCHEMAUSAGE |
DBPROP_INDEX_CLUSTERED | DBPROP_SERVERCURSOR |
DBPROP_INDEX_FILLFACTOR | DBPROP_SERVERDATAONINSERT |
DBPROP_INDEX_INITIALSIZE | DBPROP_SERVERNAME |
DBPROP_INDEX_NULLCOLLATION | DBPROP_SESS_AUTOCOMMITISOLEVELS |
DBPROP_INDEX_NULLS | DBPROP_SKIPROWCOUNTRESULTS |
DBPROP_INDEX_PRIMARYKEY | DBPROP_SORTONINDEX |
DBPROP_INDEX_SORTBOOKMARKS | DBPROP_SQLSUPPORT |
DBPROP_INDEX_TEMPINDEX | DBPROP_STRONGIDENTITY |
DBPROP_INDEX_TYPE | DBPROP_STRUCTUREDSTORAGE |
DBPROP_INDEX_UNIQUE | DBPROP_SUBQUERIES |
DBPROP_INIT_ASYNCH | DBPROP_SUPPORTEDTXNDDL |
DBPROP_INIT_BINDFLAGS | DBPROP_SUPPORTEDTXNISOLEVELS |
DBPROP_INIT_CATALOG | DBPROP_SUPPORTEDTXNISORETAIN |
DBPROP_INIT_DATASOURCE | DBPROP_TABLESTATISTICS |
DBPROP_INIT_GENERALTIMEOUT | DBPROP_TABLETERM |
DBPROP_INIT_HWND | DBPROP_TBL_TEMPTABLE |
DBPROP_INIT_IMPERSONATION_LEVEL | DBPROP_TRANSACTEDOBJECT |
DBPROP_INIT_LCID | DBPROP_UNIQUEROWS |
DBPROP_INIT_LOCATION | DBPROP_UPDATABILITY |
DBPROP_INIT_LOCKOWNER | DBPROP_USERNAME |
DBPROP_INIT_MODE | MDPROP_AGGREGATECELL_UPDATE |
DBPROP_INIT_OLEDBSERVICES | MDPROP_AXES |
DBPROP_INIT_PROMPT | MDPROP_FLATTENING_SUPPORT |
DBPROP_INIT_PROTECTION_LEVEL | MDPROP_MDX_CASESUPPORT |
DBPROP_INIT_PROVIDERSTRING | MDPROP_MDX_DESCFLAGS |
DBPROP_INIT_TIMEOUT | MDPROP_MDX_FORMULAS |
DBPROP_IParentRowset | MDPROP_MDX_JOINCUBES |
DBPROP_IRow | MDPROP_MDX_MEMBER_FUNCTIONS |
DBPROP_IRowChange | MDPROP_MDX_NONMEASURE_EXPRESSIONS |
DBPROP_IRowSchemaChange | MDPROP_MDX_NUMERIC_FUNCTIONS |
DBPROP_IRowset | MDPROP_MDX_OBJQUALIFICATION |
DBPROP_IRowsetBookmark | MDPROP_MDX_OUTERREFERENCE |
DBPROP_IRowsetChange | MDPROP_MDX_QUERYBYPROPERTY |
DBPROP_IRowsetCurrentIndex | MDPROP_MDX_RANGEROWSET |
DBPROP_IRowsetFind | MDPROP_MDX_SET_FUNCTIONS |
DBPROP_IRowsetIdentity | MDPROP_MDX_SLICER |
DBPROP_IRowsetIndex | MDPROP_MDX_STRING_COMPOP |
DBPROP_IRowsetInfo | MDPROP_NAMED_LEVELS |
DBPROP_IRowsetLocate | MDPROP_VISUALMODE |
DBPROP_IRowsetRefresh |
1998-2001 Microsoft Corporation. All rights reserved.