Standard and Custom OLE DB Properties
Following is an alphabetical list of OLE DB Properties supported by the Visual FoxPro OLE DB Provider and Visual FoxPro custom properties. Refer to the OLE DB Programmers Reference for detailed descriptions of these properties.
| Property | Description |
|---|---|
| DBPROP_ABORTPRESERVE | Preserve on Abort |
| DBPROP_ACCESSORDER | Access Order |
| DBPROP_ACTIVESESSIONS | Active Sessions |
| DBPROP_ALTERCOLUMN | Alter Column Support |
| DBPROP_APPENDONLY | Append-Only Rowset |
| DBPROP_ASYNCTXNABORT | Asynchable Abort |
| DBPROP_ASYNCTXNCOMMIT | Asynchable Commit |
| DBPROP_AUTH_CACHE_AUTHINFO | Cache Authentication |
| DBPROP_AUTH_ENCRYPT_PASSWORD | Encrypt Password |
| DBPROP_AUTH_INTEGRATED | Integrated Security |
| DBPROP_AUTH_MASK_PASSWORD | Mask Password |
| DBPROP_AUTH_PASSWORD | Password |
| DBPROP_AUTH_PERSIST_ENCRYPTED | Persist Encrypted |
| DBPROP_AUTH_PERSIST_SENSITIVE_AUTHINFO | Persist Security Info |
| DBPROP_AUTH_USERID | User ID |
| DBPROP_BLOCKINGSTORAGEOBJECTS | Blocking Storage Objects |
| DBPROP_BOOKMARKINFO | Bookmark Information |
| DBPROP_BOOKMARKS | Use Bookmarks |
| DBPROP_BOOKMARKSKIPPED | Skip Deleted Bookmarks |
| DBPROP_BOOKMARKTYPE | Bookmark Type |
| DBPROP_BYREFACCESSORS | Pass By Ref Accessors |
| DBPROP_CACHEDEFERRED | Cache Deferred Columns |
| DBPROP_CANFETCHBACKWARDS | Fetch Backwards |
| DBPROP_CANHOLDROWS | Hold Rows |
| DBPROP_CANSCROLLBACKWARDS | Scroll Backwards |
| DBPROP_CATALOGLOCATION | Catalog Location |
| DBPROP_CATALOGTERM | Catalog Term |
| DBPROP_CATALOGUSAGE | Catalog Usage |
| DBPROP_CHANGEINSERTEDROWS | Change Inserted Rows |
| DBPROP_COL_AUTOINCREMENT | Autoincrement |
| DBPROP_COL_DEFAULT | Default |
| DBPROP_COL_DESCRIPTION | Description |
| DBPROP_COL_FIXEDLENGTH | Fixed Length |
| DBPROP_COL_NULLABLE | Nullable |
| DBPROP_COL_PRIMARYKEY | Primary Key |
| DBPROP_COL_UNIQUE | Unique |
| DBPROP_COLUMNDEFINITION | Column Definition |
| DBPROP_COLUMNRESTRICT | Column Privileges |
| DBPROP_COMMANDTIMEOUT | Command Time Out |
| DBPROP_COMMITPRESERVE | Preserve on Commit |
| DBPROP_CONCATNULLBEHAVIOR | NULL Concatenation Behavior |
| DBPROP_CURRENTCATALOG | Current Catalog |
| DBPROP_DATASOURCENAME | Data Source Name |
| DBPROP_DATASOURCEREADONLY | Read-Only Data Source |
| DBPROP_DBMSNAME | DBMS Name |
| DBPROP_DBMSVER | DBMS Version |
| DBPROP_DEFERRED | Defer Column |
| DBPROP_DELAYSTORAGEOBJECTS | Delay Storage Object Updates |
| DBPROP_DSOTHREADMODEL | Data Source Object Threading Model |
| DBPROP_GROUPBY | GROUP BY Support |
| DBPROP_HETEROGENEOUSTABLES | Heterogeneous Table Support |
| DBPROP_IAccessor | IAccessor |
| DBPROP_IColumnsInfo | IColumnsInfo |
| DBPROP_IColumnsRowset | IColumnsRowset |
| DBPROP_IConnectionPointContainer | IConnectionPointContainer |
| DBPROP_IConvertType | IConvertType |
| DBPROP_IDENTIFIERCASE | Identifier Case Sensitivity |
| DBPROP_ILockBytes | ILockBytes |
| DBPROP_IMMOBILEROWS | Immobile Rows |
| DBPROP_INDEX_AUTOUPDATE | Auto-Update |
| DBPROP_INDEX_CLUSTERED | Clustered |
| DBPROP_INDEX_FILLFACTOR | Fill Factor |
| DBPROP_INDEX_INITIALSIZE | Initial Size |
| DBPROP_INDEX_NULLCOLLATION | NULL Collation |
| DBPROP_INDEX_NULLS | NULL Keys |
| DBPROP_INDEX_PRIMARYKEY | Primary Key |
| DBPROP_INDEX_SORTBOOKMARKS | Sort Bookmarks |
| DBPROP_INDEX_TEMPINDEX | Temporary Index |
| DBPROP_INDEX_TYPE | Index Type |
| DBPROP_INDEX_UNIQUE | Unique |
| DBPROP_INIT_CATALOG | Initial Catalog |
| DBPROP_INIT_DATASOURCE | Data Source |
| DBPROP_INIT_HWND | Window Handle |
| DBPROP_INIT_IMPERSONATION_LEVEL | Impersonation Level |
| DBPROP_INIT_LCID | Locale Identifier |
| DBPROP_INIT_LOCATION | Location |
| DBPROP_INIT_MODE | Mode |
| DBPROP_INIT_PROMPT | Prompt |
| DBPROP_INIT_PROTECTION_LEVEL | Protection Level |
| DBPROP_INIT_PROVIDERSTRING | Extended Properties |
| DBPROP_INIT_TIMEOUT | Connect Timeout |
| DBPROP_IProvideMoniker | IProvideMoniker |
| DBPROP_IRowset | IRowset |
| DBPROP_IRowsetChange | IRowsetChange |
| DBPROP_IRowsetCurrentIndex | IRowsetCurrentIndex |
| DBPROP_IRowsetFind | IRowsetFind |
| DBPROP_IRowsetIdentity | IRowsetIdentity |
| DBPROP_IRowsetIndex | IRowsetIndex |
| DBPROP_IRowsetInfo | IRowsetInfo |
| DBPROP_IRowsetLocate | IRowsetLocate |
| DBPROP_IRowsetRefresh | IRowsetRefresh |
| DBPROP_IRowsetResynch | IRowsetResynch |
| DBPROP_IRowsetScroll | IRowsetScroll |
| DBPROP_IRowsetUpdate | IRowsetUpdate |
| DBPROP_ISequentialStream | ISequentialStream |
| DBPROP_IStorage | IStorage |
| DBPROP_IStream | IStream |
| DBPROP_ISupportErrorInfo | ISupportErrorInfo |
| DBPROP_LITERALBOOKMARKS | Literal Bookmarks |
| DBPROP_LITERALIDENTITY | Literal Row Identity |
| DBPROP_LOCKMODE | Lock Mode |
| DBPROP_LOCKMODES | Lock Modes |
| DBPROP_MAXINDEXSIZE | Maximum Index Size |
| DBPROP_MAXOPENROWS | Maximum Open Rows |
| DBPROP_MAXPENDINGROWS | Maximum Pending Rows |
| DBPROP_MAXROWS | Maximum Rows |
| DBPROP_MAXROWSIZE | Maximum Row Size |
| DBPROP_MAXROWSIZEINCLUDESBLOB | Maximum Row Size Includes BLOB |
| DBPROP_MAXTABLESINSELECT | Maximum Tables in SELECT |
| DBPROP_MAYWRITECOLUMN | Column Writable |
| DBPROP_MEMORYUSAGE | Memory Usage |
| DBPROP_MULTIPLEPARAMSETS | Multiple Parameter Sets |
| DBPROP_MULTIPLERESULTS | Multiple Results |
| DBPROP_MULTIPLESTORAGEOBJECTS | Multiple Storage Objects |
| DBPROP_MULTITABLEUPDATE | Multi-Table Update |
| DBPROP_NOTIFICATIONGRANULARITY | Notification Granularity |
| DBPROP_NOTIFICATIONPHASES | Notification Phases |
| DBPROP_NOTIFYCOLUMNSET | Column Set Notification |
| DBPROP_NOTIFYROWDELETE | Row Delete Notification |
| DBPROP_NOTIFYROWFIRSTCHANGE | Row First Change Notification |
| DBPROP_NOTIFYROWINSERT | Row Insert Notification |
| DBPROP_NOTIFYROWRESYNCH | Row Resynchronization Notification |
| DBPROP_NOTIFYROWSETFETCHPOSITIONCHANGE | Rowset Fetch Position Change Notification |
| DBPROP_NOTIFYROWSETRELEASE | Rowset Release Notification |
| DBPROP_NOTIFYROWUNDOCHANGE | Row Undo Change Notification |
| DBPROP_NOTIFYROWUNDODELETE | Row Undo Delete Notification |
| DBPROP_NOTIFYROWUNDOINSERT | Row Undo Insert Notification |
| DBPROP_NOTIFYROWUPDATE | Row Update Notification |
| DBPROP_NULLCOLLATION | NULL Collation Order |
| DBPROP_OLEOBJECTS | OLE Object Support |
| DBPROP_OPENROWSETSUPPORT | Open Rowset Support |
| DBPROP_ORDERBYCOLUMNSINSELECT | ORDER BY Columns in Select List |
| DBPROP_ORDEREDBOOKMARKS | Bookmarks Ordered |
| DBPROP_OTHERINSERT | Others' Inserts Visible |
| DBPROP_OTHERUPDATEDELETE | Others' Changes Visible |
| DBPROP_OUTPUTPARAMETERAVAILABILITY | Output Parameter Availability |
| DBPROP_OWNINSERT | Own Inserts Visible |
| DBPROP_OWNUPDATEDELETE | Own Changes Visible |
| DBPROP_PERSISTENTIDTYPE | Persistent ID Type |
| DBPROP_PREPAREABORTBEHAVIOR | Prepare Abort Behavior |
| DBPROP_PREPARECOMMITBEHAVIOR | Prepare Commit Behavior |
| DBPROP_PROCEDURETERM | Procedure Term |
| DBPROP_PROVIDERFRIENDLYNAME | Provider Friendly Name |
| DBPROP_PROVIDERNAME | Provider Name |
| DBPROP_PROVIDEROLEDBVER | OLE DB Version |
| DBPROP_PROVIDERVER | Provider Version |
| DBPROP_QUICKRESTART | Quick Restart |
| DBPROP_QUOTEDIDENTIFIERCASE | Quoted Identifier Sensitivity |
| DBPROP_REENTRANTEVENTS | Reentrant Events |
| DBPROP_REMOVEDELETED | Remove Deleted Rows |
| DBPROP_REPORTMULTIPLECHANGES | Report Multiple Changes |
| DBPROP_RETURNPENDINGINSERTS | Return Pending Inserts |
| DBPROP_ROWRESTRICT | Row Privileges |
| DBPROP_ROWSETCONVERSIONSONCOMMAND | Rowset Conversions on Command |
| DBPROP_ROWTHREADMODEL | Row Threading Model |
| DBPROP_SCHEMATERM | Schema Term |
| DBPROP_SCHEMAUSAGE | Schema Usage |
| DBPROP_SERVERCURSOR | Server Cursor |
| DBPROP_SERVERDATAONINSERT | Server Data on Insert |
| DBPROP_SERVERNAME | Server Name |
| DBPROP_SESS_AUTOCOMMITISOLEVELS | Autocommit Isolation Levels |
| DBPROP_SQLSUPPORT | SQL Support |
| DBPROP_STRONGIDENTITY | Strong Row Identity |
| DBPROP_STRUCTUREDSTORAGE | Structured Storage |
| DBPROP_SUBQUERIES | Subquery Support |
| DBPROP_SUPPORTEDTXNDDL | Transaction DDL |
| DBPROP_SUPPORTEDTXNISOLEVELS | Isolation Levels |
| DBPROP_SUPPORTEDTXNISORETAIN | Isolation Retention |
| DBPROP_TABLETERM | Table Term |
| DBPROP_TBL_TEMPTABLE | Temporary Table |
| DBPROP_TRANSACTEDOBJECT | Objects Transacted |
| DBPROP_UPDATABILITY | Updatability |
| DBPROP_USERNAME | User Name |
| DBPROP_VFPOLEDB_ANSI | SET ANSI |
| DBPROP_VFPOLEDB_BLOCKSIZE | SET BLOCKSIZE |
| DBPROP_VFPOLEDB_COLLATE | SET COLLATE setting |
| DBPROP_VFPOLEDB_Column_Caption | Column Caption |
| DBPROP_VFPOLEDB_Column_Comment | Column Comment |
| DBPROP_VFPOLEDB_Column_Default | Default Value |
| DBPROP_VFPOLEDB_Column_Error | |
| DBPROP_VFPOLEDB_Column_Format | Format |
| DBPROP_VFPOLEDB_Column_FormDisplay | DisplayClass |
| DBPROP_VFPOLEDB_Column_FormPath | DisplayClassLibrary |
| DBPROP_VFPOLEDB_Column_InputMask | InputMask |
| DBPROP_VFPOLEDB_Column_RuleExpression | RuleExpression |
| DBPROP_VFPOLEDB_Column_RuleText | RuleText |
| DBPROP_VFPOLEDB_DELETED | SET DELETED |
| DBPROP_VFPOLEDB_EXACT | SET EXACT |
| DBPROP_VFPOLEDB_INDEX | SET INDEX |
| DBPROP_VFPOLEDB_INIT_COLLATE | Collating Sequence |
| DBPROP_VFPOLEDB_NULL | SET NULL |
| DBPROP_VFPOLEDB_ORDER | SET ORDER |
| DBPROP_VFPOLEDB_PATH | SET PATH |
| DBPROP_VFPOLEDB_REPROCESS | SET REPROCESS |
| DBPROP_VFPOLEDB_Rowset_SP | Stored Procedure |
| DBPROP_VFPOLEDB_SESS_ID | Internal Session ID |
| DBPROP_VFPOLEDB_SETDEBUGOUTTO | Debug Output File |
| DBPROP_VFPOLEDB_SETDEFAULTTO | Default Drive and Folder |
| DBPROP_VFPOLEDB_SETFULLPATH | Set Fullpath ON/OFF |
| DBPROP_VFPOLEDB_Table_Comment | Comment |
| DBPROP_VFPOLEDB_Table_DeleteTrigger | DeleteTrigger |
| DBPROP_VFPOLEDB_Table_InsertTrigger | InsertTrigger |
| DBPROP_VFPOLEDB_Table_Path | Path |
| DBPROP_VFPOLEDB_Table_PrimaryKey | PrimaryKey |
| DBPROP_VFPOLEDB_Table_RuleExpression | RuleExpression |
| DBPROP_VFPOLEDB_Table_RuleText | RuleText |
| DBPROP_VFPOLEDB_Table_UpdateTrigger | UpdateTrigger |
| DBPROP_VFPOLEDB_UNIQUE | SET UNIQUE |
See Also
Language Reference for OLE DB Development | Visual FoxPro OLE DB Provider Data Support | Supported Visual FoxPro SET Commands | Supported Visual FoxPro Commands and Functions | Unsupported Visual FoxPro Commands and Functions | Supported OLE DB Objects | OLE DB Provider for Visual FoxPro